Clarity

I am in need of some help, I am trying to construct a query that will return who is currently logged into Clarity.   It's seems simple.   I'm running 7.5.3 FP08 Thanks in advance.

Did you check table: CMN_SESSIONS?

I found CMN_USER_SESSION_V table in 8.1 maintaining information about current sessions. Pease verify if the table is present in 7.5.3.

James,This works for me.. SELECT CS.ID, SR.USER_ID,CSU.USER_NAME, SR.FULL_NAME, SR.UNIQUE_NAME, CS.CREATED_DATE
FROM SRM_RESOURCES SR,
CMN_SESSIONS CS,
CMN_SEC_USERS CSU
WHERE SR.USER_ID = CSU.ID AND
SR.USER_ID=CS.USER_ID
ORDER BY CS.CREATED_DATE DESC , UNIQUE_NAME     HTH    

Thats the same query we use.  we have created a portlet that is on our clarity administrators overview page:     SELECT @SELECT:DIM:USER_DEF:IMPLIED:User_Sessions:CS.Id:Id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:SR.User_Id:User_Id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:CSU.User_Name:User_Name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:SR.First_Name:First_Name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:SR.Last_Name:Last_Name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:SR.Unique_name:Res_Id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:User_Sessions:CS.Created_Date:Created_Date@
FROM Srm_Resources SR,
Cmn_Sessions CS,
Cmn_Sec_Users CSU
WHERE SR.User_id = CSU.ID AND
@FILTER@ note, this is identical to Keri's, just in nSQL format for a portlet, so i'm not stealing credit from her :manvery-happy:

Matpj,Great Minds....!!!  :smileywink:     Message Edited by furrelkt on 07-08-2009 08:17 AM [left]

Sorry for the late reply.   I do want to thank you all for your input. With these queries, I have what I need.