Symantec Management Platform (Notification Server)

 View Only
Back to discussions
Expand all | Collapse all

Reporting in NS 7.x Help Needed Active Directory VS discovery

  • 1.  Reporting in NS 7.x Help Needed Active Directory VS discovery

    Posted Mar 06, 2011 08:17 PM

    I am very frustrated with trying to create this report at this time.  I am hoping someone already has these reports I am looking for.  The purpose of these reports is to tie out what computer I have left to deploy too.

     

    I am looking for the sql to create a report that finds workstation (nonserver) computers that meets the following:

    Was imported via AD

    and

    Was discovered by network discovery (plus task that discovered it)

    and

    is a windows workstation

    and

    has no agent

    I am also looking for the following too:

    Is a workstation

    and

    in AD

    and

    WAS NOT discovered by Network discovery