Remedy - Server - How to check the AR Server Group ranking on ARSystem v9.1.x at Database level and servgrp_board opFlags

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

Remedy - Server - How to check the AR Server Group ranking on ARSystem v9.1.x at Database level and servgrp_board opFlags
How to check the AR Server Group ranking on ARSystem v9.1.x at Database level and servgrp_board opFlags
Remedy AR System Server
AR System Server
Remedy AR System Server v9.1.x
How to review the AR Server Group ranking at database level on ARSystem v9.1.x.



 
N/A
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

Running this query:
select * from servgrp_board;

will give this result (example)
serverNameserverPortintervalCountpendingSignalsopFlagscachePeerListenerPort
{servername}0668601;1;0;1;0;1;1;0;1;1;1;0;0;1;1;1;1;140001

Running this query:
select * from servgrp_op_mstr;

will give this result (example):
 operationopNumconfigLabelconfigCommandcategoryStrs
1Administration2   
2Approval Server-1Approval-Server-Suspended:SG-Check-ConfigApproval-CHK-CONFIG;Approval
3Archive4   
4Assignment Engine-1Assignment-Engine-Suspended:SG-Check-ConfigAE-CHK-CONFIG;AE-CACHE;AE-ASSIGN
5Atrium Integration Engine9   
6Atrium Integrator10   
7Business Rules Engine-1Business-Rules-Engine-Suspended:SG-Check-ConfigBR-CHK-CONFIG;BR-BRIE
8CMDB-1CMDB-Service-Suspended:SG-Check-ConfigCMDB-CHK-CONFIG;CMDB
9DSO6   
10E-Mail Engine7   
11Cognitive Training Service1  Cognitive
12Escalation3   
13Flashboards8   
14Full Text Index5   
15Reconciliation Engine-1Reconciliation-Engine-Suspended:SG-Check-ConfigReconciliation-CHK-CONFIG;Reconciliation
16Service Failover11   
17SLM Collector-1SLM-Collector-Suspended:SG-Check-ConfigSLM-CHK-CONFIG
18Smart Reporting User Sync-1Smart-Reporting-User-Sync-Suspended:SG-Check-ConfigSmartReportingUserSync-CHK-CONFIG;SmartReportingUserSync

Sort order is as follows:
opNum 1-10
opNum -1 (these are sorted alphabetical order after the 10th opNum record)

i.e:
1; = Cognitive Training Service opNum 1
1; = Administration opNum 2
1; = Escalation opNum 3
0; = Archive opNum 4
1; = Full Text Index opNum 5
0; = DSO opNum 6
1; = Email Engine opNum 7
1; = Flashboards opNum 8
0; = Atrium integration Engine opNum 9
1; = Atrium integrator opNum 10
1; = Service Failover opNum 12

OpNum -1 is sorted in alphabetical order
0; = Approval Server opNum -1
0; = Assignment Engine opNum -1
1; = Business Rules Engine opNum -1
1; = CMDB opNum -1
1; = Reconciliation Engine opNum -1
1; = Smart Reporting User Sync opNum -1
1 = SLM Collector opNum -1


Related Information:
Remedy - Server/ITSM - How to Rank Operations in a Server Group

 
Remedy AR System Server
AR System Server
Remedy AR System Server v9.1.x
Remedy AR System Server
AR System Server
Remedy AR System Server v9.1.x
Attachment(s):