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:

    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;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


      

     


    Article Number:

    000117042


    Article Type:

    Solutions to a Product Problem



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