Discovery Query

This query will tell you, how many devices have been found by the various discovery methods in the pass 7 days.

 

 

 

select

            AgentName as ‘Agent Name’,

            count(AgentName) as ‘count’

from

            v_AgentDiscoveries

Where

            Datediff(DD,agenttime,Getdate()) < 7

group by

            AgentName

order by

            AgentName

Leave a Reply

Your email address will not be published. Required fields are marked *