I looked into it a little more and it looks like the information is available in OneClick through a java routine that polls the device and not from an attribute which is mapped in Spectrum. So I doubt it would be something that ends up in the new reporting without an enhancement request.
The value you are looking for is OID 1.3.6.1.2.1.25.6.3.1.2 (hrSWInstalledName) from the Host Resource MIB (RFC2790). It is available in MIB Tools, but by default it is not mapped onto any attribute. The easiest way is probably as Marcel suggested: just get a list of IP's and run it through a script that uses snmp calls directly to the server. If you want to do it in Spectrum CLI, you would first have to map the OID to an attribute in MIB Tools and then pull that attribute from the CLI if you have a list of all the model handles for the devices you want to poll. Hope that helps, Michiel ________________________________ From: Lentz, Jay [mailto:[email protected]] Sent: vrijdag 16 oktober 2009 14:27 To: Helder, Michiel; spectrum Subject: RE: [spectrum] Spectrum RFC 2790 Reports Thanks for the response. I thought there would be an easy way to simply use Spectrum to report on any SNMP OID, poll, and put the results in a simple spreadsheet/report. I know I could go to each device model, expand the RFC 2790 view, then click on the extract to table button for each model, but it is a very manual process. From: Helder, Michiel [mailto:[email protected]] Sent: Thursday, October 15, 2009 2:54 PM To: spectrum Subject: RE: [spectrum] Spectrum RFC 2790 Reports Hi all, The custom reporting features were shown this week during the Dev Exchange in a hands on lab. I believe it is scheduled for 9.2 and I have to say it looks very good. It will also provide an integration between Spectrum and eHealth reporting for those that use both products. I assume they will have a similar session at the Dev Exchange in the UK later this month. So if you're going there, check it out. I am not sure though if all the 2790 info will be available for reporting. From what I understood it will still be a subset of attributes that will be available for reporting, although it will be much larger than what we have now. I'll see if I can dig up some more information on that since actually I am interested in it myself too, as we want to pull that info into our (non-CA) cmdb. Michiel ________________________________ Van: Marcel Schulte [mailto:[email protected]] Verzonden: do 15-10-2009 21:10 Aan: spectrum CC: spectrum Onderwerp: Re: [spectrum] Spectrum RFC 2790 Reports Hi Jay, list, 1. AFAIK not yet - but CA has custom reports on their roadmap - for 9.2 (1H2010) or 10.0 (2H2010-1H2011), don't remember the exact version. 2. What do you want to get reported? The 2790 information of the information subviews? They're all included in attributes - seach the xml files in "topo/config" folder for the right attribute handles. At least you could use CLI to get the snmp communities and get the whole RFC2790 info directly by snmp calls... ;-) If the above does not help please be a little bit more precise in what you want to get reported and I'll provide more information when I'm back at work at morning. Hope this helps. Regards, Marcel On Thu, Oct 15, 2009 at 12:48 AM, Lentz, Jay <[email protected]> wrote: Does Spectrum (I have 9.1.1 on windows) provide any of the following capabilities? 1. Report Manager report for RFC 2790 information, like installed software information for windows models? 2. RFC 2790 information by some type of query, maybe spectrum CLI, if so does anyone have the steps to do so? TIA ----------------------------------------------------------------- This message may contain DynCorp International Privileged/Proprietary information. If this email is not intended for you, and you are not responsible for the delivery of this email message to the addressee, do not keep, copy or deliver this email message to anyone. Please destroy this email in its entirety and notify the sender by reply email. Your cooperation is appreciated. ----------------------------------------------------------------- * --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] * --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] Disclaimer Dit bericht met eventuele bijlagen is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Indien u niet de bedoelde ontvanger bent, wordt u verzocht de afzender te waarschuwen en dit bericht met eventuele bijlagen direct te verwijderen en/of te vernietigen. Het is niet toegestaan dit bericht en eventuele bijlagen te vermenigvuldigen, door te sturen, openbaar te maken, op te slaan of op andere wijze te gebruiken. Ordina N.V. en/of haar groepsmaatschappijen accepteren geen verantwoordelijkheid of aansprakelijkheid voor schade die voortvloeit uit de inhoud en/of de verzending van dit bericht. This e-mail and any attachments are confidential and are solely intended for the addressee. If you are not the intended recipient, please notify the sender and delete and/or destroy this message and any attachments immediately. It is prohibited to copy, to distribute, to disclose or to use this e-mail and any attachments in any other way. Ordina N.V. and/or its group companies do not accept any responsibility nor liability for any damage resulting from the content of and/or the transmission of this message. * --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] ----------------------------------------------------------------- This message may contain DynCorp International Privileged/Proprietary information. If this email is not intended for you, and you are not responsible for the delivery of this email message to the addressee, do not keep, copy or deliver this email message to anyone. Please destroy this email in its entirety and notify the sender by reply email. Your cooperation is appreciated. ----------------------------------------------------------------- Disclaimer Dit bericht met eventuele bijlagen is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Indien u niet de bedoelde ontvanger bent, wordt u verzocht de afzender te waarschuwen en dit bericht met eventuele bijlagen direct te verwijderen en/of te vernietigen. Het is niet toegestaan dit bericht en eventuele bijlagen te vermenigvuldigen, door te sturen, openbaar te maken, op te slaan of op andere wijze te gebruiken. Ordina N.V. en/of haar groepsmaatschappijen accepteren geen verantwoordelijkheid of aansprakelijkheid voor schade die voortvloeit uit de inhoud en/of de verzending van dit bericht. This e-mail and any attachments are confidential and are solely intended for the addressee. If you are not the intended recipient, please notify the sender and delete and/or destroy this message and any attachments immediately. It is prohibited to copy, to distribute, to disclose or to use this e-mail and any attachments in any other way. Ordina N.V. and/or its group companies do not accept any responsibility nor liability for any damage resulting from the content of and/or the transmission of this message. --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
