topic Re: HP HTTP Server / System Management Homepage in Server Management - Systems Insight Manager

HP HTTP Server / System Management Homepage

Jon_151 — Wed, 13 Aug 2008 17:27:25 GMT

Is there a way to tell what version of the HP HTTP Server or System Management Homepage a server is running using HPSIM?

Re: HP HTTP Server / System Management Homepage

Rob Buxton — Wed, 13 Aug 2008 23:57:27 GMT

I once wrote a script that pulled the data out of the HPSIM database and formatted a web page.

This gave me the level of PSP Foundation Agent but didn't get to the level of the HP SMH.

The basic SQL was;
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

Also if you ran a standard HPSIM report on Software, you can then sort by Description.

Re: HP HTTP Server / System Management Homepage

Jon_151 — Thu, 14 Aug 2008 10:12:43 GMT

Thanks Rob, You the man!

Re: HP HTTP Server / System Management Homepage

Jon_151 — Thu, 14 Aug 2008 10:13:34 GMT

Thanks again.