Dear AllI have weird problem that i have made 5 collections for different locations here.It is showing clients in it but if you look carefully there are 40 clients missing from the collections as compared to the default all xp system collection.What could be wrong here can anyone explainor purpose a soluton.What would be the correct collection query to show exact the same number of client as it is showing in all xp system collectionRegardsFarhanFarhan

Hi, The query used in the Windows XP all Systems collection can be viewed if you edit the collection membership rules. I have pasted it in below. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 5.1" and SMS_R_System.ADSiteName = "Default-First-Site-Name" I don't know how you determine location but if you use AD-sites the below Query is an example of a Query you could use. It will display all Windows XP clients in AD site "Default-first-site-name" select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 5.1" and SMS_R_System.ADSiteName = "Default-First-Site-Name" How do the query you use look like? Regards, Jörgen

Dear All,These are the collection queries which is based on our active directory site and we are using in sccm:-Active directory site collection queriesselect SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ADSiteName = "banglore" or SMS_R_System.ADSiteName = "hyderabad-dfs" select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ADSiteName = "dehli" OR SMS_R_System.ADSiteName = "dehli7" select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ADSiteName = "mumbai" or SMS_R_System.ADSiteName = "goa-dfs" select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ADSiteName = "mumbai1" select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ADSiteName = "calcutta01"we have only 1 primary site mumbai and 3 secondary sites banglore,mumbai1,calutta01.and my All xp system collection query isselect SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from sms_r_system where OperatingSystemNameandVersion like '%Workstation 5.1%'Can sombody check these queries is it right or i am wrong somewhere because of that there is big difference of clients in my collections that are missing as compared to the number of clients shown against all systems query.RegardsFarhan

Here's my guess.When you add filters like "by adsite", that attribute comes from Heartbeat DDR. It could be that in the "all systems" collection, there are a few computers which have not reported ADSite yet, via their Heartbeat Data Discovery Record, but they exist in "All Systems" without the ADsite attribute.If you can identify a specific computer which doesn't exist in your "by adsite" collections, find that computer in the "all systems" collection, and right-click on that computer, and look at properties. Look for the ADsite attribute on that particular computer.Standardize. Simplify. Automate.

Dear Sherry Yes there are sone systems that are from the other countries adsites and they are in the all systems collection but not in all adsite collectons is it normal and if it is can you explain me what is concept or reason behind that and why its happening.RegardsFarhan

Dear AllWaiting for your kind repliesRegardsFarhan