Looking for an experienced powershell scripter to modify a server inventory script to ouput result in excel to multiple files instead of one and capture some information in Active Directory. The modified script should:
1. Save the output file using the server name (example: [login to view URL], [login to view URL], etc.), each server output should be in their on excel file. The original powershell script output all servers inventoried into 1 excel file.
2. Transpose the output from horizontal to vertical
3. Get computer object path in AD
4. Add additioanal excel worksheet with the 1st row containing headers (No., Descriptions, Status)
The inventory script used can be found here:
[login to view URL]