<div>
Try this query:<br />
<br />
select SMS_R_System.Name, SMS_G_System_SoftwareProdu<wbr />ct.Product<wbr />Name, SMS_G_System_SoftwareProdu<wbr />ct.Product<wbr />Version from &nbsp;SMS_R_System inner join SMS_G_System_SoftwareProdu<wbr />ct on SMS_G_System_SoftwareProdu<wbr />ct.Resourc<wbr />eID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProdu<wbr />ct.Product<wbr />Name like &quot;%Internet Explorer%&quot;<br />
<br />

</div>


Try this query:

select SMS_R_System.Name, SMS_G_System_SoftwareProduct.ProductName, SMS_G_System_SoftwareProduct.ProductVersion from  SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "%Internet Explorer%"



<div>
<div class="content wysiwyg-content">
Hey all,<br />
<br />
Can anyone guide me to how to write an sms query to find out who has Internet Explorer 7 on their system?<br />
<br />
Patrick
</div>
</div>


Hey all,

Can anyone guide me to how to write an sms query to find out who has Internet Explorer 7 on their system?

Patrick

SMS Query for IE7

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).