PSP Version report

[jcolby]

Good Afternoon All -

I have been given the task within my company to upgrade all of our management agents to version 7.4. I was hoping that there was a way for me to generate some type of report from within SIM that would tell me which version of the agents we are running. I have not seen anything in SIM itself that might be able to do this, nor in any of the documentation that I have found.

Thanks for any help you may be able to provide (please be gentle, as I'm very new to the HP / SIM world)

[NJK-Work]

Hi jcolby,

I am not aware of any way (not to say there is not) using SIM. I ended up using a 3rd party tool to collect the version information for a particular file that is part of the PSP. I my case I use BV-Control for Windows (Bindview) and I scan for the file:

%SYSTEMROOT%\System32\Cpqmgmt\CqMgServ\cqmgserv.exe

If you dont have BV or similar reporting tool, you could probably easily write a script to scan for this file on all your servers and grab the version info.

Nelson

[jcolby]

Interesting approach. I will have to look into that some. I was hoping to be able to do it from inside of SIM. I tried doing it by creating a custom list (a suggestion I found in the forums) and it just didn't seem to work correctly. If anyone has any pointers on how to do it that way I would love to hear them.

Thanks,
James

[Rob Buxton · Accepted solution]

You don't specifiy the version of HPSIM, so I'll assume version 5.
From Reports, Select General ->Software and select the description, name and version fields.

Sort by Describption and look for the HP Insight Management Agents entries or if you have old agents they may be called Foundation Agents.

Or the following sql would extract the details direct from the database:
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

[jcolby]

Thank you very much for your suggestion, that is exactly what I was looking for.

Thanks,
James