In the logmon prode, we have a single profile with multiple watcher rules that reads a powershell script and alerts on two different values. We have a watcher rule that alerts on the "State" column, and another that alerts on the "Preferred" column. However, i'm trying to see where i can find the different values in the database, because searching now I only see one "SAMPLEVALUE" column in s_qos_data.
Release:
Component: UIMLGM
S_QOS_SNAPSHOT) sqs ON sqs.table_id = sqs.table_id where sqd.robot like '%<robot_name>%' and sqd.qos = '<QOS_LOGMON_OBJECT_1>' or sqd.qos = 'QOS_LOGMON_OBJECT_2>' order by robot, qos, sampletime desc
Here is an example query and results from my query execution which did include both QOS objects, so you can see the results: This was for cdm QOS but you can easily adjust the query.
select sqd.table_id, sqd.robot, sqd.qos, sqd.source, sqs.samplevalue, sqs.sampletime from S_QOS_DATA sqd left outer join (select * from S_QOS_SNAPSHOT) sqs ON sqs.table_id = sqs.table_id where sqd.robot like '%mag%' and sqd.qos = 'QOS_DISK_USAGE_PERC' or sqd.qos = 'QOS_CPU_USAGE' order by robot, qos, sampletime desc
table_id robot qos source samplevalue sampletime
435 mag-e3 QOS_CPU_USAGE mag-e3 2.00 2019-01-31 09:56:38.000
435 mag-e3 QOS_CPU_USAGE mag-e3 0.00 2019-01-31 09:56:38.000
435 mag-e3 QOS_CPU_USAGE mag-e3 1.00 2019-01-31 09:56:38.000
435 mag-e3 QOS_CPU_USAGE mag-e3 2.00 2019-01-31 09:56:38.000
435 mag-e3 QOS_CPU_USAGE mag-e3 0.00 2019-01-31 09:56:38.000
431 mag-e3 QOS_DISK_USAGE_PERC mag-e3 0.00 2018-06-05 17:10:01.000
431 mag-e3 QOS_DISK_USAGE_PERC mag-e3 1.00 2018-06-04 04:21:57.000
776 mag-e3 QOS_DISK_USAGE_PERC mag-e3 1.00 2018-06-04 04:21:57.000
When you examine logmon qos in the database in the S_QOS_DATA table, or check the S_QOS_DEFINITIONS table, check to see if you are saving specific QOS objects/definitions such as QOS_LOGMON_VARIABLE_STATE and QOS_LOGMON_VARIABLE_PREFERRED.
You can ADD a new (custom) QOS definition for each QOS variable.
See logmon probe and/or the Help doc:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/logmon-log-monitoring/logmon-use-case-examples.htmlhttps://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/logmon-log-monitoring/logmon-use-case-examples