Today I was looking at Packages to see how many packages are created without any distribution Points added. This might…
Browsing: WQL Quiries
This Catagory contains WQL quiries which are basically Collection quiries help you to get the information
Creating collection to get computers that starts and end with particular string is used mostly using % .If this percentile…
Full Details http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 This collection is created using sub selected queries http://eskonr.com/2011/12/sccm-collection-sub-selected-quiries/ 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 …
collection to get all 32 Bit and 64 Bit servers. 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…
SCCM collection that returns all windows XP or Windows 7 machines which has 1 GB of RAM(1024*1024 KB) running with…
The collection listed below might help you to identify if any computers in organization that do not follow the standard…
Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could…
Use Subselected query to get the results: select * from SMS_R_System where SMS_R_System.NetbiosName like "%rts%" and SMS_R_System.ResourceId not in (select…