PMN_SRVRLIST

Return to Index

View: PS_PMN_SRVRLIST

This view is used to list server definitions in the Process Monitor.

PlatformView Text
DefaultSELECT 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 NameDescription
    SERVERNAMEServer Name
    BEGINDTTMBegin Date/Time
    LASTUPDDTTMSpecifies 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.
    SERVERSTATUSServer 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
    SRVRHOSTNAMEServer Hostname
    SERVERSTATUSDESCRServer Status
    DESCRDescription
    DESCR2Descr2
    DISTNODENAMEReport Distribution Node Name
    MAXAPIAWAREMax API Aware Tasks
    SLEEPTIMESleep Time
    HEARTBEATHeartbeat
    DAEMONENABLEDDaemon Enabled
    DAEMONGROUPDaemon Procedure Group
    DAEMONSLEEPTIMEDaemon Sleep Time
    PRCSTHRESHOLDDisk Space Threshold
    PRCSDISKSPACEDisk Space Available
    SRVRLOADBALOPTNServer Load Balancing Option
    0=Do Not Use for Load Balancing
    1=Use for Load Balancing
    MAXCPUMax. CPU Usage required
    MINMEMMin. Memory Required
    OPSYSOperating System
    0=DOS (inactive)
    1=NT/Win95 Client (inactive)
    2=NT/Win2000
    3=OS/2 (inactive)
    4=UNIX
    5=VMS (inactive)
    6=MPE/XL (inactive)
    7=OS390
    8=NT
    9=OS/400 (inactive)

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010