topic Re: Need a script to find firmware version of a Smart Array Controller in Server Management - Systems Insight Manager

Need a script to find firmware version of a Smart Array Controller

Suresh D — Mon, 03 Nov 2008 14:23:31 GMT

Hello All,

I'm in need of a script to find the firmware version of a Smart Array Controller. Can any one help me out please?

Regards,

Suresh

Re: Need a script to find firmware version of a Smart Array Controller

Hense, Klaus — Tue, 04 Nov 2008 07:19:32 GMT

Hello,
create a report in hpsim.
Go to reports > manage reports > edit the report "All Array controllers ..." > add the show Firmware level > store the report and run it.
now it show you the server name, arraycontroller modell, firmware, etc....

Re: Need a script to find firmware version of a Smart Array Controller

Suresh D — Tue, 04 Nov 2008 07:22:52 GMT

Hello Klaus,

Thanks for your reply, I can do this for a single server. My requirement is I want to run a query on more than 800 servers.

Is there a script to find?

Thanks

SureshD

Re: Need a script to find firmware version of a Smart Array Controller

Derek_56 — Wed, 05 Nov 2008 17:11:03 GMT

Suresh,

HP SIM already has a report for array controllers that includes everything except firmware. Just edit the "Array Controllers - Servers" report and add 'Firmware' to the output. If you want a subset of all servers, just create a new collection and base the same kind of report on your new collection.

- Derek

Re: Need a script to find firmware version of a Smart Array Controller

Hense, Klaus — Wed, 05 Nov 2008 20:52:37 GMT

Hallo,
you can run the report against your 800Server and create a answer csv-File. In Excel you can work with the data ...

The data is in a HPSIM SQL Server DB.
You can create a SQL Query etc...

Re: Need a script to find firmware version of a Smart Array Controller

Sen Hu — Sun, 04 Jan 2009 18:49:16 GMT

If you are using .csv (comma separated values), highly recommend biterscripting. Excel is great for manual operation. For processing a csv file programmatically (on a large number of servers), biterscripting seems appropriate. Free download at http://www.biterscripting.com . A simple csv script will do the job. Put it in an accessible folder (including a web location) and set the $path to that location as follows.

set $path = $path+"|http://www.mywebsite.com/scripts" (for example)

Sen