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

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.

Best Answer

  • ManiNavManiNav Member Posts: 88
    Accepted Answer
    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.

Answers

  • ManiNavManiNav Member Posts: 88
    Hi Everyone,

    I am using NAV 2009 R2.

    Thanks in advance,
    Mani.
  • ManiNavManiNav Member Posts: 88
    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:

    ha3v0623pnl9.png



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

    Thanks,
    Mani.
  • ManiNavManiNav Member Posts: 88
    Hi Expert/@RockWithNAV ,@ShaiHulud,@vaprog,

    Please help me for the above query.

    Thanks,
    Mani.
  • ManiNavManiNav Member Posts: 88
    Accepted Answer
    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.
  • RockWithNAVRockWithNAV Member Posts: 981
    @ManiNav - Sorry for the delay mate, You are absolutely right and that's the standard out of the box solution which you implemented.
  • ManiNavManiNav Member Posts: 88
    No issue,
    Thanks alot @RockWithNav for your reply.
Sign In or Register to comment.