SQL to get the Process Scheduler Server status.



SELECT S.SERVERNAME, X.XLATSHORTNAME,X.FIELDVALUE,S.MAXCPU,S.PRCSDISKSPACE,S.LASTUPDDTTM
      FROM PSSERVERSTAT S, PSXLATITEM X
     WHERE X.FIELDNAME = 'SERVERSTATUS'   AND X.FIELDVALUE = S.SERVERSTATUS;

Comments