Last Login Report - All Users

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 ADManager Plus?

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