Client Management Suite

Does Network Discovery keep a last contact time that is updated with each scan?

I'm looking to use network discovery to identify network resource which are no longer alive.  These will be devices that do not have an agent installed.

Here is a report I wrote for this purpose.  I believe this will give you what you are looking for. 

-- JVH 2012-JUN-12
--
-- Discovered Devices with Date Last Seen

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'

SELECT distinct
   inv._ResourceGuid,  
   inv.[Base IP Address] as 'IP',
   dt.[Name] as 'Device Type',
   inv.[Display Name],
   inv.[DNS Hostname],
   inv.[NetBios Name],
   inv.[NetBios Domain],  
   i.name as 'Scan Task',
   im.[Date Last Seen],
   vc.[OS Name],
   vc.[IsManaged]
FROM Inv_Device_Discovery_Task im
    JOIN Inv_Device_Identification inv ON im._ResourceGuid = inv._ResourceGuid
    JOIN Inv_Device_Details dd ON dd._ResourceGuid=im._ResourceGuid
    JOIN DeviceType dt ON dt.DeviceTypeId = dd.DeviceTypeId
    JOIN (Item i
               join ItemClass ic on i.Guid=ic.Guid and ic.ClassGuid in ('f1f9f77a-5c4d-47fb-b3ce-cc33a80463db','e08f800f-bb6f-4e02-9a49-7c21d18befc4')
              )ON im.TaskGuid = i.Guid
    LEFT JOIN vComputer vc ON im._ResourceGuid = vc.Guid

WHERE IsManaged is Null or IsManaged = '0'
 AND       ([vc].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))

order by [Date Last Seen] asc

Thanks for the query!

Does the Inv_Device_Discovery_Task.[Date Last Seen] update with each scan?  Will it update if only ICMP is enabled?