--The number of users connected on the environment at the moment 

select count(Nr) USERS_NUMBER FROM ( SELECT count(OPRID) as Nr FROM PSACCESSLOG where to_date(sysdate)-to_date(LOGINDTTM)>=0 and to_date(LOGOUTDTTM)-to_date(sysdate)>=0 group by OPRID) 

--The users connected on the environment at the moment 

select DISTINCT OPRID, LOGIPADDRESS, TO_CHAR(LOGINDTTM ,'YYYY-MM-DD:hh:mi:ss') LOGINTIME,TO_CHAR(LOGOUTDTTM ,'YYYY-MM-DD:hh:mi:ss') LOGOUTIME, TO_CHAR((sysdate),'YYYY-MM-DD:hh:mi:ss') CURRTIME FROM PSACCESSLOG where to_date(sysdate)-to_date(LOGINDTTM)>=0 and to_date(LOGOUTDTTM)-to_date(sysdate)>=0

Continue reading

Share:

SELECT  DISTINCT P.LABEL_ID,P.LBLTEXT,P.FIELDNAME,P.RECNAME,F.LENGTH  

,(CASE WHEN F.FIELDTYPE = '0' THEN 'Character' 

       WHEN F.FIELDTYPE='1' THEN 'Long Character'

       WHEN F.FIELDTYPE='2' THEN 'Number'

       WHEN F.FIELDTYPE='3' THEN 'Signed number'

       WHEN F.FIELDTYPE='4' THEN 'Date'

       WHEN F.FIELDTYPE='5' THEN 'Time'

       WHEN F.FIELDTYPE='6' THEN 'DateTime'

       WHEN F.FIELDTYPE='8' THEN 'Attachment'

       ELSE 'TBD' 

  END) as Field_Type

FROM SYSADM.PSPNLFIELD P,SYSADM.PSDBFIELD F

WHERE P.PNLNAME='JOB_DATA1'

AND P.FIELDNAME=F.FIELDNAME

ORDER BY P.LBLTEXT;

Continue reading

Share: