(DMCM) Support Tip: Report last login date for users without enabling auditing.

0 Likes

The Dimensions CM Administration Console shows the last login date for registered users in the current base database.  This information can also be queried from the pcms_users_profile database view.

e.g.

select user_name, login_date from <basedb>.pcms_users_profile order by login_date desc;

where <basedb> is the base database you are reporting on.

Labels:

Support Tip
Comment List
Related
Recommended