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 Device Collection. Show all posts
Showing posts with label Device Collection. Show all posts
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...