Login Host Name History
I will be doing an upgrade to a new ALM server in a month but our Desktop environment is really locked down so our Desktop Support needs to visit each user that accesses ALM from their laptop to setup the IE ActiveX controls for the new server. (Most users access from Citrix)
I'm trying to get a list of all users that have logged in from a system outside of citrix to supply DT support but I can't find anywhere that has a history of this info.
This gives me what I want, but it's only for the currently logged in users, not history.
select LS_USER_NAME, LS_CLIENT_HOST from qcsiteadmin_db.td.LOGIN_SESSIONS Where LS_CLIENT_TYPE = 'Application Lifecycle Management Client UI' Group by LS_USER_NAME, LS_CLIENT_HOST Order by LS_USER_NAME
Is there anywhere else I could get this data from? i poked around the ALM server logs but didn't see anything in there either.
There is a table in the qcsiteadmin database which is called SESSIONS_HISTORY.
That table stores, like the name says, a history of logins.
Please take a look at that table and see if that work for your needs.