Custom Reporting

[mike]

Hello,

I am trying to create a report that will prompt to enter an AD boundary then once runned it will count the clients and list some system resources.

I have gotten to runing a query on the entire AD site with the system resources needed be listed.

 

SELECT

a.Netbios_Name0,

a.User_Name0,

a.Operating_System_Name_and0,

a.AD_Site_Name0,

b.IP_Addresses0

From

v_RA_System_IPAddresses b,

v_R_System a

WHERE a.ResourceID=b.ResourceID

 

But now I want to query say boundary 2 only and not the entire listing.

I have tried using the 'count' command with no success and also the v_SiteBoundary_ADSite view with column ADSiteName. but couldnt find a relation with the current views that I am using.

 

Any help appreciated.

 

Thanks,

mike

 

Ok so I have this but still having issues:

SELECT

a.Netbios_Name0,

a.User_Name0,

a.Operating_System_Name_and0,

a.AD_Site_Name0,

b.IP_Addresses0,

Count(SMS_Installed_Sites0) AS 'Count'

From

v_R_System a,

v_RA_System_IPAddresses b,

v_RA_System_SMSInstalledSites c

WHERE a.ResourceID=b.ResourceID AND b.ResourceID=c.ResourceID

Group By

a.Netbios_Name0,

a.User_Name0,

a.Operating_System_Name_and0,

a.AD_Site_Name0,

b.IP_Addresses0,

c.SMS_Installed_Sites0