Report on Servers with current Support Pack version

[Andrew Cowan_1]

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.

[Rob Buxton]

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

[Mikael Rönnbäck]

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 ?

[Steve Kadish · Accepted solution]

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