Count of Logged-In Users

Hi Guys,

Is there any DQL to provide the following information,

-- No. of users logged into the system for the past 1 month

-- No. of users imported a document for the past 1 month

-- No. of users created workflows for the past 1 month

Any help is really appreciated.

Regards,

Rajkumar Sukumar

Find more posts tagged with

Has auditing been turned on?

No. of users logged into the system for the past 1 month

select * from dm_user where datediff(month,last_login_utc_time,date(today))=1

No. of users imported a document for the past 1 month

select count (distinct r_creator_name) from dm_document where datediff(month,r_creation_date,date(today))=1

No. of users created workflows for the past 1 month

You need to query from dm_audittrail table with event name "dm_startworkflow".

select count (distinct user_name) from dm_audittrail where event_name ='dm_startworkflow' and datediff(month,time_stamp,date(today))=1