Hi,
I'm new to SMS and I can't figure out how to query the domain for softwares products that are not on our company's standard list of applications. I tried doing the following in my query.
select distinct SMS_R_System.Name, count(SMS_G_System_SoftwareProduct.ProductName) from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceID group by SMS_R_System.Name having SMS_R_System.ResourceDomainORWorkgroup= "HHQ" and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 5.1%" and SMS_R_System.IPSubnets= "10.200.35.0" and count(SMS_G_System_SoftwareProduct.ProductName)< 10 and order by SMS_R_System.Name
My intention was to query the system by domain, Windows XP and by the ipsubnet as we dont have a very powerful machine atm.
The error I am receiving is "Syntax error" when I try to click ok. Can you guys please help me to quickly accomplish this task?
Thank you and more power to this forum....
I'm new to SMS and I can't figure out how to query the domain for softwares products that are not on our company's standard list of applications. I tried doing the following in my query.
select distinct SMS_R_System.Name, count(SMS_G_System_SoftwareProduct.ProductName) from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceID group by SMS_R_System.Name having SMS_R_System.ResourceDomainORWorkgroup= "HHQ" and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 5.1%" and SMS_R_System.IPSubnets= "10.200.35.0" and count(SMS_G_System_SoftwareProduct.ProductName)< 10 and order by SMS_R_System.Name
My intention was to query the system by domain, Windows XP and by the ipsubnet as we dont have a very powerful machine atm.
The error I am receiving is "Syntax error" when I try to click ok. Can you guys please help me to quickly accomplish this task?
Thank you and more power to this forum....