That's what I need to figure out because our orginal query displayed the
same results. It seems to keep a history of the last 3 networks.. I need to
get the latest one.
I used the following query to create a similar report. One thing I noticed
however is that the total number of clients in this report was higher than
the actual number of sms clients on our network. This could be explained
by
roaming clients and SMS having logged a client at serveral different
subnets.
SELECT Distinct IPSUB.IP_Subnets0, SYS.Client0, Count(*) AS 'Count'
FROM v_RA_System_IPSubnets IPSUB inner join v_R_System SYS on
SYS.ResourceID
= IPSUB.ResourceID
WHERE SYS.Client0 = 1
Group by IPSUB.IP_Subnets0, SYS.Client0
Order by IPSUB.IP_Subnets0
"Jay (Work)" wrote:
Hello all -
SMS 2003 SP1, need to report on systems counts per subnet. Any help
would
be appriciated.
Thank you
Jay
Re: SMS Advance Client not assigned to the site ... added 3 subnets individually on top of that. ... In the Roaming Boundaries tab,... all clients in our network are XPs so I don't need to worry ...Sms 2003 has 2 types of clients: ... (microsoft.public.sms.admin)
Re: Preventing Users who travel from switching SMS sites ... All of the VLAN subnets for Corp HQ are in one AD site, ... If the SMS client is not supposed to move from site to site, ... within the site boundaries of Primary1. ... The clients are XP SP2 mostly. ... (microsoft.public.sms.admin)
Re: SMS Advance Client not assigned to the site ... Not only have I added the SMSSite (which includes all the 3 subnets that were configured in AD Sites & Services) in the Site Boundaries, but also added 3 subnets individually on top of that. ... After doing this I ran the AD System Discovery and then updated the collection but still no clients got assigned to the site. ... Now since there was no way of knowing when sms 2003 went rtm which client you would install. ... (microsoft.public.sms.admin)
RE: SMS Advance Client not assigned to the site ... The very first time when I opened the SMS admin console,... all clients from our building were dicovered. ... Before installing SMS, I went under AD Sites and Services and created a site ... called "SMSSite" and added all above subnets to it. ... (microsoft.public.sms.admin)
Re: SMS Advance Client not assigned to the site ...Legacy clients are assigned based site boundaries, advanced clients are assigned based on roaming boundaries. ... By configuring site boundaries, you by default also configure roaming boundaries. ... Now since there was no way of knowing when sms 2003 went rtm which client you would install. ... If you want to solve this without starting to push to "unassigned resources" than you could add your 3 ip subnets to the subnet boundaries. ... (microsoft.public.sms.admin)
