Challenge :
I would like to check probe *** version in my environment.
Example :
Here is an example how to walk through 3 specific probe (colored in red) version in a large environment.
These information is stored in 2 tables (CM_NIMBUS_ROBOT and CM_NIMBUS_PROBE) so we can make it joined.
select
cmnp.probe_name,
cmnp.probe_status,
cmnp.pkg_version,
cmnr.domain,
cmnr.hub,
cmnr.robot,
cmnr.origin,
cmnr.os_major,
cmnr.os_minor
from CM_NIMBUS_PROBE cmnp
INNER JOIN CM_NIMBUS_ROBOT cmnr on cmnr.robot_id = cmnp.robot_id
where cmnp.probe_name IN ('snmptoolkit','interface_traffic','hub')
order by cmnp.probe_name