Last scanned time

Last scanned time





SELECT resource.resourcename                       "Asset Name", 
       Max(net.ipaddress)                          "IP Address", 
       Longtodate(Max(LASTSUCCESSAUDIT.audittime)) "Last success Scan Date", 
       Longtodate(Max(audithistory.audittime))     "Last Scan Date", 
       Max(audithistory.auditstatus)               "Aduit Status", 
       Max(aaauser.first_name)                     "User" FROM   resources resource 
       LEFT JOIN resourceowner rOwner 
              ON resource.resourceid = rOwner.resourceid 
       LEFT JOIN resourceassociation rToAsset 
              ON rOwner.resourceownerid = rToAsset.resourceownerid 
       LEFT JOIN sduser sdUser 
              ON rOwner.userid = sduser.userid 
       LEFT JOIN aaauser aaaUser 
              ON sduser.userid = aaauser.user_id 
       LEFT JOIN departmentdefinition deptDef 
              ON rOwner.deptid = deptDef.deptid 
       LEFT JOIN resourcelocation resLocation 
              ON resource.resourceid = resLocation.resourceid 
       LEFT JOIN networkinfo net 
              ON resource.resourceid = net.workstationid 
       LEFT JOIN lastauditinfo 
              ON resource.resourceid = lastauditinfo.workstationid 
       LEFT JOIN audithistory LASTSUCCESSAUDIT 
              ON lastauditinfo.last_success_auditid = LASTSUCCESSAUDIT.auditid 
       LEFT JOIN audithistory 
              ON lastauditinfo.last_auditid = audithistory.auditid 
GROUP  BY resource.resourcename 
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • Related Articles

                      • Last work log added

                        This report is used to get the latest worklog added in the request. To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT wo.WORKORDERID ...

                      • Project Time spent

                        MSSQL SELECT pr.ProjectID "Project ID", pr.TITLE "Project Title", taskdet.TaskID "TaskID", taskdet.TITLE "Title", tkd.description "Task Description", taskowner.FIRST_NAME "Owner", dateadd(s, datediff(s, GETUTCDATE(), getdate()) + ...

                      • Problem time spent

                        SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", catadef.CATEGORYNAME "Category", LONGTODATE(prob.REPORTEDTIME) "Reported Date", ownaaa.FIRST_NAME "Technician", priodef.PRIORITYNAME "Priority", statdef.STATUSNAME "Status", ...

                      • Time elapsed analysis

                        This Report gives a clear picture of, how long the request was handled by each technician, stayed in each group and stayed in different statuses. Capturing each action performed on the request can be helpful for the request management team to assess ...

                      • Average Resolution Time based on Group

                        This report is used for the customers that support groups provide a consistent level of support. It can be confusing and frustrating for customers to have some support groups resolve quickly, while other support groups takes days to resolve the ...

                        Related Products