Jump to content

Last Log on / Activity - Tables and columns


Recommended Posts

Morning all,

Wondering if anyone can help me, im trying to find out the last log on for all full users, now I know I can see last logon in the admin side in the users section but i cant pull a report from there. So i have two questions around this.

Firstly, what table does the last login time sit under, i have tried searching database direct but am not getting any results.

Secondly, a lot of our staff leave there computers on 24-7 (I know not great for the planet) so it could show that they last logged on 2 weeks ago but they have been working every day. Is there another field somewhere that captures the last time the said users made any changes to the system, logged a ticket, resolved one, updated one, sent a email etc...? If so where is it?

Many thanks

H

Link to comment
Share on other sites

Yelah,nodrog,
Even if staff leave the PC on for 24/7 you dont have to leave the session logged in. If you set the idle timeout to 1 hour it will time out, forcing them to re-login to Hornbill. 

Kind Regards

Keith Stevenson

Link to comment
Share on other sites

@yelyah.nodrog

The 'last logon' field is in the sys_accounts table under h_last_logon

I don't know how to do this, but maybe there's a way of getting the 'h_datelastmodified' field from the h_itsm_requests table to tell you who last updated any requests (presumably you could filter the requests to show the last 2 weeks or something?)

 

Link to comment
Share on other sites

As @Paul Alexander mentioned its in the sys_accounts table under h_last_logon.

image.png.5eff2e4ed755e55c1093eebf224d0030.png

 

I've attached a report I use which has the value,  ignore the custom attrib fields (I use for recharging depts) but hopefully gives you the last logon info.

Nasim

ng-license-accounting-incl-blank-attrib-and-cost-code.report.txt

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...