Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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

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