SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, Where SMS_CM_RES_COLL_SMS00001.IsApproved= "0" Clients requiring a reboot select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, Inner join SMS_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System SCCM Clients Collections Clients not approved select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, All queries tested in SCCM Current Branch 1902. All Office 365 Pro Plus 2016 (Office 365 Pro Plus).All SQL Server Management Studio v17 installed.All SQL Server Management Studio installed.Based on the computer manufacturer model.All Windows 10 Aniversary Update (1607).All Windows 10 Fall Creators Update (1709).All Windows 10 April 2018 Update (1803).All Windows 10 October 2018 Update (1809).All computer objects with client installed in the specific site “21”.All SCCM client computers with less than 5GB free disk space on C:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |