myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


query to count all clients at each site

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> query to count all clients at each site Page: [1]
Login
Message << Older Topic   Newer Topic >>
query to count all clients at each site - 7/28/2008 10:46:32 AM   
jseber1982

 

Posts: 65
Score: -2
Joined: 5/16/2007
Status: offline 		I know there are a few queries and reports floating around that count machines connected to each site..But this is a little different

I inherited this network.. we have a central, 4 primaries, and 250 or so secondaries. I am trying to do a count, but since all of the secondaries are proxy management points,,, i only get a count that shows all machines being conneced to the 4 primaries. I am trying to break it down and get a count on how many clients are connected to each secondary site so i can do some capacity planning and get rid of some secondaries.

thanks


_____________________________

Justin Seber
Enterprise SMS Admin
Overclocking Guru
jseber1982@yahoo.com
Post #: 1
RE: query to count all clients at each site - 7/30/2008 5:13:39 AM   
mgroenewald

 

Posts: 197
Score: -2
Joined: 7/2/2004
Status: offline 		does each secondary also have its own AD Site name?

(in reply to jseber1982)
Post #: 2
RE: query to count all clients at each site - 7/30/2008 8:09:00 AM   
gjones


Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		or IP Range?

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to mgroenewald)
Post #: 3
RE: query to count all clients at each site - 7/30/2008 2:42:29 PM   
jseber1982

 

Posts: 65
Score: -2
Joined: 5/16/2007
Status: offline 		The boundary on each secondary site is site bad site name. 

_____________________________

Justin Seber
Enterprise SMS Admin
Overclocking Guru
jseber1982@yahoo.com

(in reply to gjones)
Post #: 4
RE: query to count all clients at each site - 7/30/2008 2:53:59 PM   
jseber1982

 

Posts: 65
Score: -2
Joined: 5/16/2007
Status: offline 		or a report will be fine,. I tried using the default one,,Count clients assigned and installed  for each site....but it is for some reason nowhere near accurate.If i tally up everything from the secondaries... it only equals out to about 1/4 of the machines



_____________________________

Justin Seber
Enterprise SMS Admin
Overclocking Guru
jseber1982@yahoo.com

(in reply to jseber1982)
Post #: 5
RE: query to count all clients at each site - 7/30/2008 4:45:56 PM   
jseber1982

 

Posts: 65
Score: -2
Joined: 5/16/2007
Status: offline 		If you look at the default report.. count ip addresses by subnet... thats exactly what i want. Except instead of it showing subnets,, i need it to show AD sites.

We have our boundaries on the secondaries configured to the AD sites in sites and services. We are working on some consolidation, and need to know how many sms clients we have at each AD site.

This sort of shows me what i need, But it just lists everything. If i could somehow group everything that shows up under a site as a number instead of listing each machine. I will convert it to a report later

select SMS_G_System_COMPUTER_SYSTEM.Name, SMS_R_System.ADSiteName from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_R_System.ADSiteName like "%")


< Message edited by jseber1982 -- 7/30/2008 4:53:38 PM >

_____________________________

Justin Seber
Enterprise SMS Admin
Overclocking Guru
jseber1982@yahoo.com

(in reply to jseber1982)
Post #: 6
RE: query to count all clients at each site - 7/30/2008 7:05:00 PM   
gjones


Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		try this.
http://smsug.ca/blogs/garth_jones/archive/2008/07/30/count-of-device-by-ad-site.aspx


_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to jseber1982)
Post #: 7
RE: query to count all clients at each site - 7/31/2008 8:56:06 AM   
jseber1982

 

Posts: 65
Score: -2
Joined: 5/16/2007
Status: offline 		Perfection!!!

Thanks a lot Garth


_____________________________

Justin Seber
Enterprise SMS Admin
Overclocking Guru
jseber1982@yahoo.com

(in reply to gjones)
Post #: 8
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> query to count all clients at each site Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.469