Skip navigation
1086 Views 5 Replies Latest reply: Oct 10, 2013 5:09 PM by dmshimself RSS
chrisjgill Apprentice 104 posts since
Jun 24, 2011

Has received 2 of 9 achievements.
Currently Being Moderated

Mar 7, 2012 2:58 AM

User session history

Since 7.4, I understand that user sessions only show active users logged in


Is there a query or way to show user session history over say a week?


Also, can this be broken down between analysts/end users?


The reason for this is to see how many of the licences are actually being used on a daily basis



  • dmshimself ITSMMVPGroup 2,248 posts since
    Dec 16, 2007

    Has received 7 of 9 achievements.
    Currently Being Moderated
    1. Mar 8, 2012 6:40 PM (in response to chrisjgill)
    Re: User session history

    The user sessions table was made hard delete for performance reasons I think.  The very issue you raise was one that has been raised before, but I'm not sure what LANDesks best practise alternative is at the moment to provide what was standard functionality.  I did pencil in a workaround which was to use the new features in 7.4 and 7.5 to be able to create an entry in an integration table each time an object was created.  This is currently used in LANDesk to allow request processes to pass out parameters to an external application, such as the LANDesk Management Suite and is nicely described in the manuals.


    Although there are big warnings against using the facility on objects which are updated too often, it did strike me as a away of retaining when a user sessions table was created and (from memory) deleted.


    Triggers might be another alternative to stash the contents of user sessions somewhere safe and arrange to delete them every so often.


    I don't think MI in 7.5 would help because it only runs once a day to collect the stats.


    As I say it was just something I played around with when the change in functionality kicked in.  Ideally a LANDesk article might appear with a better way [Hint to LANDesk!]

  • Currently Being Moderated
    3. Oct 10, 2013 6:26 AM (in response to dmshimself)
    Re: User session history

    We are adding more analysts to service desk a 3rd time, and managing who is fixed vs concurrent obviously depends on how much the analyst has web desk open during the day.  I have a query which shows active user sessions, which is great.


    But, history would be really nice.  When you say triggers, I assume you mean a trigger in SQL to dump the user sessions table elsewhere everytime it's updated?


    Has anyone done this?  And has anyone seen any issues result?  Thanks.

  • Expert 613 posts since
    Jan 6, 2010

    Has received 4 of 9 achievements.
    Currently Being Moderated
    4. Oct 10, 2013 8:10 AM (in response to Miketedeschi)
    Re: User session history

    I would assume trigger is a SQL trigger, it's the only thing that makes sense.


    My DBA is always harping on me about using triggers.  Their the easy button but they also add overhead to everything you do and your forget about them.

  • dmshimself ITSMMVPGroup 2,248 posts since
    Dec 16, 2007

    Has received 7 of 9 achievements.
    Currently Being Moderated
    5. Oct 10, 2013 5:09 PM (in response to
    Re: User session history

    What I have done is enable event manager settings on the user session table on create and delete events.  So when LDSD creates a session (login) and deletes when they logout.  This gives you a legit method of recording when someone logged in and when they logged out.  You can then use this as a source for quite accurate reporting data for user sessions.


    Note I don't think you need to be licensed for event manager to generate this list of data, but you'd need to check and also keep the table of records generated under control.

More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS®  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software