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
where
SMS_R_System.Name in (Select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName = "Symantec Endpoint Protection")
and SMS_R_System.Name in (Select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName = "CrowdStrike Windows Sensor")
Microsoft Endpoint Manager | Configuration Manager | Intune | Azure | SQL Server | Active Directory | Azure AD | Windows Server | Windows 10/11 | iOS/iPadOS | iMac/macOS | OSD | Autopilot | MDT | Task Sequence | Application Packaging | Software Updates | Microsoft 365 | Exchange
Showing posts with label WQLQuery. Show all posts
Showing posts with label WQLQuery. Show all posts
Tuesday, 20 September 2022
Friday, 3 December 2021
Configuration Manager: WQL Query to find the machines based on Deployment Status
WQL Query to find the machines falls under unknown tab for any application or software update deployments:
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
Join SMS_SUMDeploymentAssetDetails D
On SMS_R_System.resourceID = D.resourceID
Where D.assignmentID = '<Assignment ID>' and D.StatusType = '<Status No>'
To 'Assignment ID', Open Configuration Manager Console > Monitoring > Overview > Deployment > Select and right click the deployment and tick the Assignment ID
And for machine status, below are the values for the respective status (Screenshot from Microsoft Document - SMS_SUMDeploymentAssetDetails Server WMI Class):
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
Join SMS_SUMDeploymentAssetDetails D
On SMS_R_System.resourceID = D.resourceID
Where D.assignmentID = '16779116' and D.StatusType = '4'
Subscribe to:
Posts (Atom)
What's new in Microsoft Intune: April 2025
Microsoft Intune's April 2025 release introduces several enhancements aimed at improving device management and security: Custom Naming ...

-
Hexadecimal SignedInteger UnsignedInteger ErrorDescription 0x80000001 -2147483647 2147483649...
-
Managing Windows feature updates through Microsoft Intune is crucial for maintaining device security and performance. However, administra...
-
In this post, we'll look at how to fix the 0x800f0954 error that may appear when installing optional Windows features such as RSAT tools...