Cloud Pak System Software Monitoring Server predefined queries

Cloud Pak System Software Monitoring Server is shipped with a set of predefined queries that you can apply to a table or chart view. This topic describes the queries delivered as part of the Tivoli® Management Services infrastructure. The Cloud Pak System Software Monitoring Server queries are available for every item in the Navigator.

Expand the

Monitoring Server branch of the Queries tree to see these query groups:

Agent Operations Log: This log and the EIB Change Log are good diagnostic tools to use when problems arise such as a true situation that is not raising an alert as expected. They also provide information that can help in planning optimization strategies.; Agent Operations Log provides information about situation and connectivity messages that occur on the managed system associated with the Navigator physical view item or the link source. It is useful for diagnostic research with IBM® Software Support.
Catalog Check: The Catalog Check queries compare the application catalogs of the hub Cloud Pak System Software Monitoring Server with those of the remote monitoring server and report any discrepancies. These queries are used in the Manage Cloud Pak System Software Monitoring Servers workspaces:; Compare Enterprise Catalogs; Compare TEMS Catalogs
Custom SQL: The custom SQL (Structured Query Language) queries provide information that the portal server (TEPS) database gathers from the hub Tivoli Enterprise Monitoring Server. These queries are for the Situation Event Results workspace and the Self-Monitoring Topology workspace.
EIB Change Log: The Enterprise Information Base log, like the Agent Operations log, is stored on the hub monitoring server.; EIB Change Log provides information about changes to Enterprise Information Base objects such as situations. It is useful mainly for diagnostic research with IBM Software Support. This is an ODBC query of the EIB Change Log attributes.
ITM Audit Log: The ITM Audit Log query is stored on the hub monitoring server.; ITM Audit Log provides information on critical state-changing events in the monitoring environment.
Managed System: The Managed Systems queries are used to check vital heartbeat information from the monitoring server and monitoring agents.; Current® Managed Systems Status, when applied to a table view, displays all the Managed Systems attributes. It displays such information as the agent product code and the host name and IP address of the managed system. The Enterprise Navigator item has a Managed System Status workspace that uses this query. A threshold was applied to the Status column that highlights any offline managed systems.; ITV Managed System Count is a count of the managed systems reporting to each monitoring server.; Tivoli Enterprise Monitoring Servers; Windows Systems Online lists the Windows OS managed systems that are online. Other OS agents have similar queries.; Windows Systems Offline lists the Windows OS managed systems that are unavailable. Other OS agents have similar queries.
Situation Definition: Situation Definition uses the Situation Definition attributes to retrieve information that describe every aspect of the situations defined to this hub monitoring server.
Situation State Events: The Situation State Events queries collect status information on situation events.; Events by Owner Using ID; Selected Event Using ID; Similar Events by Situation Name lists all the events for the same situation. Such events would occur when the situation is true on more than one managed system or the situation is true on the same managed system more than once (a display item was defined in the Advanced Situation options window). You can see table views that use this query: From the Enterprise Status workspace, right-click the link anchor for an acknowledgment in the My Acknowledged Events view, and click Event Details - Similar by Situation Name.; Similar Events by Source lists all the events from the same managed system as the event you are viewing. You can see table views that use this query: From the Enterprise Status workspace, right-click the link anchor for an acknowledgment in the My Acknowledged Events view, and click Event Details - Similar by Source.; Similar Events by Resource lists all the events for situations that were defined with the same attribute group as the one used for this situation. You can see table views that use this query: From the Enterprise Status workspace, right-click the link anchor for an acknowledgment in the My Acknowledged Events view, and click Event Details - Similar by Resource.; Events by Owner Using Name returns all the events by owner.; Selected Event Using Name returns all events by their short name.; Similar Events by Situation Display Name return all events by their full name.; Similar Events by Source using Situation Display Name; Similar Events by Resource using Situation Display Name
Situation Status: Situation Status Detail; Situation Status Summary
Situation Status Current: These queries use the Active Situation Status attributes to display status information on situations and policies that are running.; Alternate Current Situation Status is an alternate query for message log initialization.; Current Active Situation Status Using ID; Pure Event Occurrences Using ID displays the situations with pure events opened when applied to a table view.; Current Active Situation Status Using Name; Pure Event Occurrences Using Name displays the situations with pure events opened when applied to a table view.
Situation Status Log: These queries use the Situation Status attributes to display status information on started situations and policies.; Open Events Count Using ID - Enterprise shows the every open event on the Enterprise and the number of intervals the situation has been true since it was started.; Open Events Count Using ID - Managed System shows the every open event on the managed system and the number of intervals the situation has been true since it was started.; Situation Status Log shows the status of the situations on this managed system. It is similar to the message log view.; Open Events Count Using Name - Enterprise shows the every open event on the Enterprise and the number of intervals the situation has been true since it was started.; Open Events Count Using Name - Managed System shows the every open event on the managed system and the number of intervals the situation has been true since it was started.