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

ManiNav
ManiNav Member Posts: 120
in NAV/Navision Classic Client
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

  • ManiNav
    ManiNav Member Posts: 120
    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

  • ManiNav
    ManiNav Member Posts: 120
    Hi Everyone,

    I am using NAV 2009 R2.

    Thanks in advance,
    Mani.
  • ManiNav
    ManiNav Member Posts: 120
    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.
  • ManiNav
    ManiNav Member Posts: 120
    Hi Expert/@RockWithNAV ,@ShaiHulud,@vaprog,

    Please help me for the above query.

    Thanks,
    Mani.
  • ManiNav
    ManiNav Member Posts: 120
    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.
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    @ManiNav - Sorry for the delay mate, You are absolutely right and that's the standard out of the box solution which you implemented.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • ManiNav
    ManiNav Member Posts: 120
    No issue,
    Thanks alot @RockWithNav for your reply.

Categories