Running Exchange 2007 Server.
I have been given a list of approx 10,000 usernames on an Excel sheet. Management would like me to provide their Exchange mail server, their database, their mailbox size.
The names are located on C:\USERS.xls
I need to amend this file so that the relevant info is next to it.
I was thinking of doing something like get-content C:\Users.txt | foreach-object get XXXXX
Then with the output of the above, copy and paste it into the original XLS file
But does anyone know how I can do this? What script do I need to write?