Collection to check if any of Primary or Secondary site not installed with SUP Role or any other Role?…
Browsing: Collections
This catatory Contains posts about sccm collections and its relevant informaiton
I was looking at client health percentage other day and found many systems were reported as not healthy though I…
Creating collection to get computers that starts and end with particular string is used mostly using % .If this percentile…
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…