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
Subscribe to:
Post Comments (Atom)
FREE Cybersecurity Certifications
Here's 15 FREE courses provided by the Qualys. The cybersecurity firm Qualys focuses on providing cloud-based security and compliance so...
-
These Courses Includes Video Lectures, Tutorial and Notes. Discover the Following Free Courses. 1. Microsoft Azure Fundamentals Course AZ-90...
-
Hexadecimal SignedInteger UnsignedInteger ErrorDescription 0x80000001 -2147483647 2147483649...
-
Here is a collection of free Microsoft azure courses on Udemy: AZ-900 Microsoft Azure Fundamentals - Udemy Course Link ...
No comments:
Post a Comment