PMN_SRVRLIST

index back

Process Monitor Server List

This view is used to list server definitions in the Process Monitor.
SELECT A.SERVERNAME , A.BEGINDTTM , A.LASTUPDDTTM , A.SERVERSTATUS , A.SRVRHOSTNAME , X.XLATLONGNAME , B.DESCR , S.DESCR , B.DISTNODENAME , B.MAXAPIAWARE , B.SLEEPTIME , B.HEARTBEAT , B.DAEMONENABLED , B.DAEMONGROUP , B.DAEMONSLEEPTIME ,A.PRCSTHRESHOLD ,A.PRCSDISKSPACE ,B.SRVRLOADBALOPTN ,B.MAXCPU , B.MINMEM ,B.OPSYS FROM PSSERVERSTAT A , PS_SERVERDEFN B , PS_PRCSSRVROPSYS S , PSXLATITEM X WHERE A.SERVERNAME = B.SERVERNAME AND A.SERVERSTATUS = X.FIELDVALUE AND S.OPSYS = B.OPSYS AND X.FIELDNAME = 'SERVERSTATUS'

  • Related language record: PMN_SRVRLSTLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name
    BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    SERVERSTATUSCharacter(2)VARCHAR2(2) NOT NULLServer Status
    0=Error
    1=Down
    2=Suspended
    3=Running
    4=Purging
    5=Running With No Report Node
    6=Suspended - Disk Low
    7=Suspended - Offline
    8=Running - Report Rep. Full
    9=Overloaded
    SRVRHOSTNAMECharacter(80)VARCHAR2(80) NOT NULLServer Hostname
    SERVERSTATUSDESCRCharacter(30)VARCHAR2(30) NOT NULLServer Status
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCR2Character(30)VARCHAR2(30) NOT NULLDescr2
    DISTNODENAMECharacter(15)VARCHAR2(15) NOT NULLReport Distribution Node Name
    MAXAPIAWARENumber(3,0)SMALLINT NOT NULLMax API Aware Tasks
    SLEEPTIMENumber(4,0)SMALLINT NOT NULLSleep Time
    HEARTBEATNumber(4,0)SMALLINT NOT NULLHeartbeat
    DAEMONENABLEDCharacter(1)VARCHAR2(1) NOT NULLDaemon Enabled
    DAEMONGROUPCharacter(8)VARCHAR2(8) NOT NULLDaemon Procedure Group
    DAEMONSLEEPTIMENumber(4,0)SMALLINT NOT NULLDaemon Sleep Time
    PRCSTHRESHOLDNumber(8,0)INTEGER NOT NULLDisk Space Threshold
    PRCSDISKSPACENumber(8,0)INTEGER NOT NULLDisk Space Available
    SRVRLOADBALOPTNCharacter(2)VARCHAR2(2) NOT NULLServer Load Balancing Option
    0=Do Not Use for Load Balancing
    1=Use for Load Balancing
    MAXCPUNumber(3,0)SMALLINT NOT NULLMax. CPU Usage required
    MINMEMNumber(3,0)SMALLINT NOT NULLMin. Memory Required
    OPSYSCharacter(1)VARCHAR2(1) NOT NULLOperating System
    0=DOS
    1=NT/Win95 Client
    2=Windows
    3=OS/2
    4=UNIX
    5=VMS
    6=MPE/XL
    7=OS390
    8=NT
    9=OS/400
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19