Last Login Report - All Users
SELECT AaaUser.FIRST_NAME "Users",
MAX(AaaLogin.NAME) "LoginName",
MAX(AaaContactInfo.EMAILID) "Email",
MAX(AaaAccSession.USER_HOST) "IP Address",
longtodate(MAX(AaaAccSession.OPENTIME)) "Logged In Time" ,
longtodate(MAX(AaaAccSession.CLOSETIME)) "Logged Out Time" FROM AaaUser
INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID
Left JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID
LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID
INNER JOIN AaaAccount ON AaaAccount.login_id=AaaLogin.LOGIN_ID
INNER JOIN AaaAccSession ON AaaAccount.ACCOUNT_ID = AaaAccSession.ACCOUNT_ID
LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID WHERE SDUser.STATUS = 'ACTIVE'
GROUP BY AaaUser.FIRST_NAME
New to ADSelfService Plus?
Related Articles
Last Login Time of Technicians
Use Case: The query generates a report with the technician name and his login timestamps. DB: MSSQL & Postgres Query SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", ...Query to take report of all techinician details with last login time (V10.6)
The query is compatiable with version 10.6 and above: Query: Select au.FIRST_NAME "Technicianname" , ar.NAME "Role",al.name "Login Name",aci.emailid "EmailID",SDUSER.STATUS "Status(Active/Inactive)",longtodate(MAX(AaaAccSession.OPENTIME)) "Last ...Query to show all login activities for a specific period
PGSQL & MSSQL: select acs.account_id, ad.org_name "Account Name", sdo.name "Site Name", au.first_name "First Name", au.last_name "Last Name", al.name "Login Name", aci.emailid "Email ID", sdu.jobtitle "Job Title", aci.landline "Telephone",aci.mobile ...Query to show Technicians' login name, email, role and last login_ PGSQL & MSSQL
Query for build: 105 series SELECT AaaUser.FIRST_NAME "Technician Name", aal.name "Login Name", aci.emailid "Email ID", SDUSER.STATUS "Status(Active/Inactive)", aar.name "Role", longtodate(MAX(AaaAccSession.OPENTIME)) "Logged In Time" FROM AaaUser ...Query to get the Login Hours of Technicians (Postgres)
1) To generate the total login hours per technician tested in Builds 14201 (Postgres): select ai as "Account ID", tn as "Technician Name ( First Name )", lh as "Login hours", LONGTODATE(llt) as "Last Login Time", ln as "Login Name", domain as ...