SELECT S.SERVERNAME,
X.XLATSHORTNAME,
X.FIELDVALUE,
cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU,
cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,
TO_CHAR(S.LASTUPDDTTM, 'DD - MM - YYYY HH :MI :SS') LAST_UPDATE_TIME
FROM PSSERVERSTAT S, PSXLATITEM X
WHERE X.FIELDNAME = 'SERVERSTATUS'
AND X.FIELDVALUE = S.SERVERSTATUS
X.XLATSHORTNAME,
X.FIELDVALUE,
cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU,
cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,
TO_CHAR(S.LASTUPDDTTM, 'DD - MM - YYYY HH :MI :SS') LAST_UPDATE_TIME
FROM PSSERVERSTAT S, PSXLATITEM X
WHERE X.FIELDNAME = 'SERVERSTATUS'
AND X.FIELDVALUE = S.SERVERSTATUS