![]() ![]() Sms_combineddeviceresources.resourceid = sms_r_system.resourceid SMS_R_SYSTEM.Client from SMS_R_System join sms_combineddeviceresources on 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. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |