Create report to get/track the users who have login the NAV in Particular time(Jan 2020 to June 20).

ManiNav

Hi Everyone,

Is it possible to track the user by report that who have(Or how many user) login the NAV in particular time eg. from Jan 2020 to June 2020.
If it is then how can i proceed.

please guide for the above query.

Regards,
Mani.

ManiNav

Hi Everyone,

I finished this requirement.

Explaination: In "User Setup" table one boolean field 'Register time' is there; after enable this field i use to get Login log details in table: "User Time register" .
so, i designed one report with "User time register" as dataitem and filter with below code.

User Time Register - OnPreDataItem()

"User Time Register".SETCURRENTKEY("User ID",Date);
"User Time Register".SETRANGE(Date,LoginStartDate,LoginEndDate);

In design body section, kept 'user id' and 'date' field to get details.

Thanks all,
Mani.

ManiNav

Hi Everyone,

I am using NAV 2009 R2.

Thanks in advance,
Mani.

ManiNav

Hi Everyone,

In Nav-2018, "Session event" table has all details, but in NAV-2009; i am not able to find any table for login details to capture data and to use in report generation as for my above requirement.
In NAV-2009 in database information-> session-> drilldown button comes to database sessions and here i can see all login log details; but here how i will find table details.

Please find below screenshot for reference:





So, please guide me, how can i proceed this.
[Your help will be appreciable please..]

Thanks,
Mani.

ManiNav

Hi Expert/@RockWithNAV ,@ShaiHulud,@vaprog,

Please help me for the above query.

Thanks,
Mani.

ManiNav

Hi Everyone,

I finished this requirement.

Explaination: In "User Setup" table one boolean field 'Register time' is there; after enable this field i use to get Login log details in table: "User Time register" .
so, i designed one report with "User time register" as dataitem and filter with below code.

User Time Register - OnPreDataItem()

"User Time Register".SETCURRENTKEY("User ID",Date);
"User Time Register".SETRANGE(Date,LoginStartDate,LoginEndDate);

In design body section, kept 'user id' and 'date' field to get details.

Thanks all,
Mani.

RockWithNAV

@ManiNav - Sorry for the delay mate, You are absolutely right and that's the standard out of the box solution which you implemented.

ManiNav

No issue,
Thanks alot @RockWithNav for your reply.