Jump to content

Last login date


Joshua
 Share

Recommended Posts

Hi 
I'm looking at getting data from created analysts but can't seem to locate the table where this is stored.

Could you confirm where I would find last login date on the SQL server for the screenshot attached?

Capture.PNG

Link to comment
Share on other sites

Guest Mary

Hi @Joshua

The Last time logged in is stored in the swanalysts table within the sw_systemdb database. 

Log on to Hornbill Core Services > Interactive SQL and run the following to obtain the details you require. 

Use sw_systemdb;

SELECT Analystid, Name, LastLogOnTime from swanalysts;

Link to comment
Share on other sites

unsure if our old supportworks follows the same SQL table? 

I've done a search for SWANALYST but nothing in there, is it under a different table name in older versions? After rereading your comment I think it's for a Cloud hosted setup Skanska is running a on perm SQL DB.

Capture.PNG

Link to comment
Share on other sites

Hi @Joshua

From the screenshot you appear to be looking at your MSSQL database, this is not where the data you require is stored.

As Mary mentions above, you need to log on to the Supportworks Server itself and run the Interactive SQL console to access the sw_systemdb database, not the swdata database

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...