topic Report on Servers with current Support Pack version in Server Management - Systems Insight Manager

Report on Servers with current Support Pack version

Andrew Cowan_1 — Thu, 24 Nov 2005 18:35:47 GMT

Hi, we have a 100 servers. Is it possible to get a report out of HPSIM that lists server and current Proliant Support Packs's installed.

Re: Report on Servers with current Support Pack version

Rob Buxton — Thu, 24 Nov 2005 22:03:13 GMT

You can if you're happy to write a procedure to use a bit of SQL to get the details from the HPSIM Database.

The following SQL is from a script I use to do just that:
select CAST(R_Software.DeviceName AS char(20)), CAST(R_Software.Version AS char(24))from R_Software
WHERE (R_Software.Description LIKE '%Foundation Agents Service%' OR
R_Software.Description LIKE '%Insight Management Agents%')
AND (R_Software.SnapShotID=-1)
order by R_Software.DeviceName ASC

Re: Report on Servers with current Support Pack version

Mikael Rönnbäck — Fri, 25 Nov 2005 04:18:23 GMT

Rob, I'm also interested in the same thing, but is this just an sql query you run from anywhere or can I somehow integrate this in a report in SIM ?

Re: Report on Servers with current Support Pack version

Steve Kadish — Mon, 28 Nov 2005 10:23:30 GMT

The built-in "System Software" report will give this information, but probably gives more information that you want. You can run it so it generates a CSV file and sort on the software name.

- Steve