Another DOOZIE!

I have a mission for anyone who thinks they can do it...

I have two Excel spreadsheets. Each spreadsheet has almost the same data. See below:

XLS01

SERVER NAME| DOMAIN NAME   | LOCAL ADMIN
-------------------------------------------------------------
MSServer1      |       Local User    |    Administrator
-------------------------------------------------------------
MSServer1      |         Domain1     |   Domain Admins
-------------------------------------------------------------
MSServer1      |         Domain2     |   Domain Admins
-------------------------------------------------------------
MSServer02    |       Local User    |   Administrator
-------------------------------------------------------------
MSServer02    |         Domain1     |  Domain Admins

XLS02

SERVER NAME| DOMAIN NAME   | LOCAL ADMIN
-------------------------------------------------------------
MSServer1      |       Local User    |    Administrator
-------------------------------------------------------------
MSServer1      |         Domain1     |   Domain Admins
-------------------------------------------------------------
MSServer1      |         Domain2     |   Domain Admins
-------------------------------------------------------------
MSServer02    |       Local User    |   Administrator
-------------------------------------------------------------
MSServer02    |         Domain1     |  Domain Admins
-------------------------------------------------------------
MSServer02    |         Domain1     | Backup Operators

NOW COMES THE FUN PART..
I want to build a PS script that will see the differences (see last entry in XLS02) and create a NEW XLS file that shows me the Computer name, the difference, and whether it was added or removed from the control file (XLS01).

Is anyone up to the challenge? Can anyone even help me figure this one out??? Someone's gotta have a clue to get this to work.

Thank you in advance.

Matthew Jaramillo

I'll give you a big picture answer. If this were my problem then here is how I would approach it:

• Use Import-CSV to slurp document 1 into a variable
• Use Import-CSV to slurp document 2 into a variable
• Use Compare-Object to compare those two variables for differences.
  

Okay, I got the data imported, but am having issues with getting the differences read. It gives me a list of the servers, and info above, but that's it.

Any more help would be appreciated, guys. Thanks!

st the code that you are using abd a detailed explanation of how it fails.