topic Re: List Version Control Agent status in Server Management - Systems Insight Manager

List Version Control Agent status

Tom Bate — Thu, 08 Nov 2007 10:15:55 GMT

Is there any way to use the Version Control Repository Manager to create a list of servers that are running the agent and what level they are at?

Re: List Version Control Agent status

Rancher — Thu, 08 Nov 2007 11:43:37 GMT

You can do this though the Reports option in SIMS, under General, Software. Unfortuntely this will show all HP software installed. I don't know of any other way to get this information.

Re: List Version Control Agent status

Rob Buxton — Thu, 08 Nov 2007 14:17:08 GMT

I run a report manually from the HPSIM Database to get an idea of the PSP by looking at the Foundation Agents, here's the SQL. Not quite what you're after but you'll get the idea.

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

You can also just use the reporting mentioned above and then sort it by the description, that will at least group what you want.