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

        Resources

            • 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 Technicians

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