Dql To Get The Count On User’s Login To Documentum?

1.	Dql To Get The Count On User’s Login To Documentum?
Answer» SELECT count () from dm_user where last_login_utc_time>DATE (NOW)-90 Note:* This QUERY retrieves the use LOGIN information by using their last successful login as REFERENCE Select count () from dm_user where last_login_utc_time>DATE (NOW)-90 Note:* This query retrieves the use login information by using their last successful login as reference

Answer»

SELECT count (*) from dm_user where last_login_utc_time>DATE (NOW)-90

Note: This QUERY retrieves the use LOGIN information by using their last successful login as REFERENCE

Select count (*) from dm_user where last_login_utc_time>DATE (NOW)-90

Note: This query retrieves the use login information by using their last successful login as reference

Discussion