Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage User Detail Report?

Posted By Justin K over 9 years ago

Is there anyway (via report or custom lookup) that I would be able to retrieve the following information:

User Code

Date Created

Last Login

Parents

0 TomTarget over 9 years ago

Using Crystal

SY_USER does not seem to have a creation date. So my guess would be no for that.

SY_ACTIVITYLOG (if you have it set to track log ins) could get you the last login Filter the LogDescription for "User Successfully Authenticated"

Note that in version 2015 you should have some ability to sort and filter the log without using crystal.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 TomTarget over 9 years ago

Using Crystal

SY_USER does not seem to have a creation date. So my guess would be no for that.

SY_ACTIVITYLOG (if you have it set to track log ins) could get you the last login Filter the LogDescription for "User Successfully Authenticated"

Note that in version 2015 you should have some ability to sort and filter the log without using crystal.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Justin K over 9 years ago in reply to TomTarget

Thanks for the info Tom. I'll give it a try.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Sage User Detail Report?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING