The PA Scores table pa_scores, pa_scores_l1, pa_scores_l2 is a domain separated table. It has a domain field, and scores collected on a domain separated instance will have a domain associated with the score. The mechanism which determines the domain of a score is either: the domain of the "run as" user, or a domain configuration (

The Domain Support plugin, which provides access to the Domain Configuration, enables the collection of scores across multiple domains using a single data collection job. The use of a domain configuration record will add additional query parameters to indicator and breakdown sources so that records from multiple domains are returned. In turn, the results set is aggregated per domain and a score for each domain is recorded.

Data vs process tables

Regardless of whether a domain configuration is used or not, the domain context of where the data collection job is running will always be determined by the run as user. This is unlikely to be an issue when collecting scores on a data table for example: incident. Common practice is to use an administrator user from the global domain for use as the run as user for data collection jobs. Due to domain rules on data tables, this user (and the data collector running under it) will have full visibility of all incident records. However when scores are being collected on a process table (a table with a sys_overrides field) e.g. contract_sla using a run as user from the global domain restrict visibility of records on the contract_sla table to the global domain. This visibility also flows down through database views, where a join is made to a the contract_sla table e.g. incident_sla.

It is common practice for MSPs to define these types of process records: business rules, SLAs client scripts, on a process domain, not in the global domain. If this is the case, a run as user with appropriate visibility into these process domains is required to be set by jobs containing sources on process tables.

MSP best practice

Please see the attached best practice doc for more information and an overview and a best practice approach for setting up Performance Analytics on a Domain Separated isntance.


Article Information

Last Updated:2020-01-21 23:29:48
MSP PA best practice.pdf