Does anyone have any query SQL SERVER where it will list all the elements that are being monitored?
Version: CA Unified Infrastructure Management - 8.2
It's not really possible to query the DB for all monitored items, as this information is not stored in the DB in the first place. There's a probe (unsupported) around in the community that gathers the configuration files from all probes, but you'd need to parse those yourself too.
The closest you can get (without extra scripts / probes) is probably querying CM_DEVICE and CM_CONFIGURATION_ITEM, as well as CM_CONFIGURATION_ITEM_METRIC. These tables, however, contain information about items that have been discovered, which does not implicate that those items are also being monitored.
Retrieving data ...