Video Screencast Help

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