AleksaCvijanovic
Member
- Messages
- 24
- Reaction score
- 0
- Points
- 1
How can I modify this query to return only the devices that have a specific application installed?
I try this but am getting error "The query statement that you entered is not valid"
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_NETWORK_ADAPTER_CONFIGURATION ON SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId INNER JOIN SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress LIKE "10.18.%" AND SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Therefore%"
I try this but am getting error "The query statement that you entered is not valid"
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_NETWORK_ADAPTER_CONFIGURATION ON SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId INNER JOIN SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress LIKE "10.18.%" AND SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Therefore%"
