List of users who logged into docbase for the last 90 days????

I tried to query by

select * from dm_user where DATEDIFF(day,last_login_utc_time,DATE(TODAY))

<=90.

But it shows dm_query_e_not_attribute for last_login_utc_time ,even though it is an attribute of dm_user.Please let me knw how to proceed.

Find more posts tagged with

Comments

KSMatson

The most easiest way is to use this query

select * from dm_user 
where last_login_utc_time >= date(today) - 90 
and r_is_group = 0;

askarthik

Hi,

I tried the below mentioned query,but I am getting the error

Query Error:[DM_QUERY_E_NOT_ATTRIBUTE]error: "You have specified an invalid attribute name (last_login_utc_time)."

Please let me know as to how, I can proceed with this.

KSMatson

The last_login_utc_time attribute was introuduced in 5.3, obviously if you are using a version prior to 5.3 it wont work. What version of CS are you using?

If you are using a version 5.3 and above then it is indeed very strange that you are seeing the no attribute error. Run 'describe dm_user' dql and check if the last_login_utc_time attribute is present.