custom report to display all user ids

Hello, Thanks for asking about this request. Please check out KB article that will help you with this request.  Hope this report delights you!

Thanks
Sam

this helps, thank you Sam

Hi Sam,

upon using this query for a couple of days, i noticed seeing negative values on the "Days_Unused" column, may i know how can  i prevent this? i think those users who are currently logged in when the report is generated triggers negative value.

Hello,

I think that the value for Days_Unused column for currently active users should be 0 (zero) and cannot get negative.. 

If the issue still there, please contact support directly in a dedicated ticket and provide some additional details like screenshots, etc.

Regards,
Victoria -