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