Create PowerShell script to parse version from [login to view URL] on a list of servers

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 [url removed, login to view] file in the same location as the PowerShell script.

2. The script will query a file located here C:\Windows\system32\CpqMgmt\cqmgstor\[url removed, login to view]

\\servername\c$\ Windows\system32\CpqMgmt\cqmgstor\[url removed, login to view]

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

[url removed, login to view]

[url removed, login to view]


TURNAROUND TIME FRAME: Trying to see if this can be done within 24 hours..
PRICE: Hopefully this can be done for about $50

Skills: Shell Script, Software Architecture

See more: psp version powershell, powershell server list txt, powershell parse file version, powershell script psp version, www regular expressions info, using regular expressions, using expressions, use regular expressions, regular expressions list, regular expressions info, regular expressions in c, regular expressions example, regular expressions c, psp create, hp com, example regular expressions, c regular expressions, create shell script, create psp, architecture project description, americas line, powershell parse version, Powershell, powershell 2, microsoft windows powershell

About the Employer:
( 20 reviews ) Tomball, United States

Project ID: #2571959

Awarded to:


It looks like you have a good handle on what you want done (and how to go about doing it!). This should be a very quick turnaround. Thanks!

$50 USD in 1 day
(10 Reviews)

3 freelancers are bidding on average $167 for this job


Pls check MSGs

$250 USD in 1 day
(3 Reviews)

I want offer my IT services to accomplish the software requirements.

$200 USD in 5 days
(0 Reviews)