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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Obsolete = 0 and SMS_R_System.Client = 1 and SMS_G_System_OPERATING_SYSTEM.Caption like "%windows%2003%" and SMS_G_System_OPERATING_SYSTEM.CSDVersion like "Service Pack1"
Subscribe to:
Post Comments (Atom)
Adding devices to SCCM collection using query method
Overview The "Add Machines to Collection" tool is a simple, user-friendly UI-based solution designed to quickly add machines...
-
Error: File C:\Windows\ccmsetup\{8971B736-FB0A-4D07-AE81-82D40BBCD630}\client.msi installation failed. Error text: ExitCode: 1603 Acti...
-
Streamlining Deployments with a GUI Tool Built on PowerShell In our ongoing efforts to enhance efficiency and streamline our deployment proc...
No comments:
Post a Comment