Create PowerShell script to parse version from readme.txt on a list of servers
$30-250 USD
In Progress
Posted over 11 years ago
$30-250 USD
Paid on delivery
The requirements are to have a PowerShell script created that will connect to a list of servers remotely on C$ share and go to a file within a subdirectory of System32 and parse information from line #4 of the readme file and save it to a CSV file. The CSV file should include the server name and the HP Insight Storage Agents version in column #2. This process needs to work in a domain environment so that I can specify credentials. After this is complete, I should have a PowerShell *.PS1 file that I can schedule on a server in the domain.
Step by Step Process:
1. PowerShell script goes out and queries a list of server found in [login to view URL] file in the same location as the PowerShell script.
2. The script will query a file located here C:\Windows\system32\CpqMgmt\cqmgstor\[login to view URL]
\\servername\c$\ Windows\system32\CpqMgmt\cqmgstor\[login to view URL]
3. The script parses line #4 for this follow info: HP Insight Storage Agents v9.00.0.0
4. The script then store the server name and this “HP Insight Storage Agents v9.00.0.0” version information into a CSV file format.
5. In the last column in the CSV I would like to have the date that the script was ran. See the example below..
6. This process loops through each server name listed in the “”[login to view URL]” file and records it to the CSV file.
7. Once this process is complete the CSV file is attached to an email and the email is sent. I need to be able to change the FROM and TO email names along with the subject and a basic body message.
8. I need to also be able to input credentials into the script to use to connect to the servers remotely. We have 3 geographical domains called, Americas, EMEA and AsiaPacific which all have different credentials. So I will modify the script and have 3 different versions that I can run in each domain.
Output Results in CSV Example:
Server name: PSP Version: DATE:
SERVER01A HP Insight Storage Agents v9.00.0.0 10/16/2012
SERVER01B HP Insight Storage Agents v8.70.0.0 10/16/2012
Reference Links:
[login to view URL]
[login to view URL]
EXAMPLE, [login to view URL] & WORDFILE WITH PROJECT DESCRIPTION ATTACHED.