Last login date

[Joshua]

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?

[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;

[Joshua]

Amazing Mary! 

thank you very much!

[Joshua]

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.

[Steve Giller]

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