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: [url removed, login to view], [url removed, login to view], 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:
[url removed, login to view]