Thursday, July 30, 2015

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;

No comments:

Post a Comment