Custom Report - Sys Description Cisco Devices

Custom Report - Sys Description Cisco Devices

Hello,

I need assistance in creating a custom report (trying to use the submit query feature using MS SQL).

I need to find the IOS version of all of our Cisco switches inventoried in OpManager. I noticed this information is included in the Sys Desc. field on the device summary page. I can't seem to find this information using the ms sql query, i tried a few tables but am not sure where this information is stored. Any help or direction is appreciated.

Thanks!




I would like to have an ouput of Device NAME, IP Address, Sys Desc.

                New to ADSelfService Plus?