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

Version 5
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System Server


    APPLIES TO:

    Remedy AR System Server v9.1.x



    PROBLEM:

    How to review the AR Server Group ranking at database level on ARSystem v9.1.x.



     


    CAUSE:

    N/A


    SOLUTION:

    Running this query:
    select * from servgrp_board;

    will give this result (example)

                                                                                        
    serverNameserverPortintervalCountpendingSignalsopFlagscachePeerListenerPort
    {servername}0668601;1;0;1;0;1;1;0;1;1;0;0;1;1;1;140001
      
    Running this query:
    select * from servgrp_op_mstr;

    will give this result (example):
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
     operationopNumconfigLabelconfigCommandcategoryStrs
    1Administration1   
    2Approval Server-1Approval-Server-Suspended:SG-Check-ConfigApproval-CHK-CONFIG;Approval
    3Archive3   
    4Assignment Engine-1Assignment-Engine-Suspended:SG-Check-ConfigAE-CHK-CONFIG;AE-CACHE;AE-ASSIGN
    5Atrium Integration Engine8   
    6Atrium Integrator9   
    7Business Rules Engine-1Business-Rules-Engine-Suspended:SG-Check-ConfigBR-CHK-CONFIG;BR-BRIE
    8CMDB-1CMDB-Service-Suspended:SG-Check-ConfigCMDB-CHK-CONFIG;CMDB
    9DSO5   
    10E-Mail Engine6   
    11Escalation2   
    12Flashboards7   
    13Full Text Index4   
    14Reconciliation Engine-1Reconciliation-Engine-Suspended:SG-Check-ConfigReconciliation-CHK-CONFIG;Reconciliation
    15Service Failover10   
    16SLM Collector-1SLM-Collector-Suspended:SG-Check-ConfigSLM-CHK-CONFIG
      
    Sort order is as follows:
    opNum 1-10
    opNum -1 (these are sorted alphabetical order after the 10th opNum record)

    i.e:
    1; = Administration opNum 1
    1; = Escalation opNum 2
    0; = Archive opNum 3
    1; = Full Text Index opNum 4
    0; = DSO opNum 5
    1; = Email Engine opNum 6
    1; = Flashboards opNum 7
    0; = Atrium integration Engine opNum 8
    1; = Atrium integrator opNum 9
    1; = Service Failover opNum 10
    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 = SLM Collector opNum -1



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

      

     


    Article Number:

    000117042


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles