SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, Select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, Where SMS_G_System_LOGICAL_DISK.DeviceID = "C:" and SMS_G_System_LOGICAL_DISK.FreeSpace Disk Drives -> Status SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
#Windows 10 icollections free
Inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid where c.LastEnforcementMessageID = 3 All SCCM client computers with less than 1GB free disk space on C: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, Where c.LastEnforcementMessageID = 9 Collection of ConfigMgr clients waiting for another installation to finish. Inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from sms_r_system AS sms_r_system Where SMS_CM_RES_COLL_SMS00001.IsApproved= "2" Collection of clients requiring a reboot. Inner join SMS_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId Where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan >= DateAdd(dd,-30,GetDate())) Collection of clients not approved. Where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_R_System.Nameįrom SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId Inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System SCCM Query Collections Computers that have 30 days old hardware information.
#Windows 10 icollections software
Note: Some of these collection queries require software or hardware inventory to be enabled. Simply copy and paste these into the sccm query statement of the query rule. Let me know in the comments below if you need a specific query and I will add it to this list. These collections demonstrate different queries you can use to create all the collection you need. Here are some useful queries for System Center Configuration Manager that you can use to create collections.
0 kommentar(er)
