Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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

Created: 06 Mar 2011

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


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


is a windows workstation


has no agent

I am also looking for the following too:

Is a workstation


in AD


WAS NOT discovered by Network discovery