SQL Database query for OpManager

 OpManager allows searches for database information, while logged into the server there is a link at the top right to various links for help and searches.

Checking Engine ID of devices

OpManager had an issue with timing out the monitors, but it was successful using the MIB Browser and the Monitors would work after sending a get from the MIB Browser

 To check if the device EngineID seems to be changed when the test fails in OpManager. When the device is added to OpManager using SNMPV3 we will update the device engineid to 2 tables (Enginetable, usmtable)

select * from Enginetable

select * from usmtable

If the device EngineID is changed in the device and still the old EngineID is listed in OpManager we will face this issue. We need to make sure that EngineID in the device and the one configured in OpManager is same when test fails. 

Check for devices in NCM

select * from ncmresource

Search for Serial and FW Version

SELECT DISPLAYNAME,IPADDRESS, DNSNAME, HI.HW_MANUFACTURER, HW_MODEL, HW_SERIALNUMBER, HW_OSVERSION, to_timestamp(ADDED_TIME/1000) as DiscoveredTime, LAST_UPDATED_TIME FROM HardwareInformation HI JOIN ManagedObject mo ON HI.MOID=mo.MOID JOIN OpMDeviceDetails OD ON mo.MOID=OD.MOID JOIN TopoObject tobj ON tObj.NAME=mo.NAME JOIN NODE node ON node.NAME=mo.NAME WHERE ISNODE='true'

Discovery Date And Time By Device And Ip Address

SELECT DISPLAYNAME, to_timestamp(ADDED_TIME/1000), IPADDRESS FROM OpMDeviceDetails OD JOIN ManagedObject mo ON OD.MOID=mo.MOID JOIN TopoObject tobj ON tObj.NAME=mo.NAME WHERE ISNODE='true'

TO SEE THE NEXT POLLING EVENT

select to_timestamp(timeval/1000), period, name, ACTIVE from PolledData where agent='pccsarrut1.dn.srp.gov.10000000001'

select to_timestamp(timeval/1000), period, name, ACTIVE from PolledData where agent='DEVICE NAME.PROBE ID'

Get the device name and probe id from the Snapshot page URL

Hardware Information search

 select * from hardwareinformation hw inner join managedobject mo on mo.moid=hw.moid