The solution contains pre-defined SQL analytics that are used in rules.
As part of rule processing, the SQL analytics run pre-defined queries against the proactive monitoring repository database or the configured PowerCenter repositories on demand.
For examples, the SQL Analytic, get_no_session , gets the total number of sessions from the PowerCenter repository and the SQL Analytic, pc_get_email, gets the email address for a specified alert recipient from the proactive monitoring repository
The solution also uses analytics to fetch CPU and memory consumption details from the hosts that you configured for monitoring and adds these details into the body of the email and RTAM alert notifications.