Struggling with this one. I can't seem to figure this out. I am trying to filter by OS in this query. What I have is working but I can't seem to get it to filter by OS type. I want only Windows 7 and Windows XP machines to show up in this collection. If anyone can help I would greatly appreciate it.
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 where SMS_R_System.Name not in (select SMS_R_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "communicator.exe" and SMS_G_System_SoftwareFile.FileVersion >= "4.0") and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway in ("REMOVED FOR SECURITY")
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Struggling with this one. I can't seem to figure this out. I am trying to filter by OS in this query. What I have is working but I can't seem to get it to filter by OS type. I want only Windows 7 and Windows XP machines to show up in this collection. If anyone can help I would greatly appreciate it.
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 where SMS_R_System.Name not in (select SMS_R_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "communicator.exe" and SMS_G_System_SoftwareFile.FileVersion >= "4.0") and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway in ("REMOVED FOR SECURITY")Share this post
Link to post
Share on other sites