Jump to content


  • 0
mike

Custom Reporting

Question

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

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.