How to add IE8 or IE9 in Windows 7 to SMSWEB report

Does anyone remember the ever popular SMSWEB report?  We use this in our SCCM 2007 environment to create qualification reports for our workstations.  We just discovered that Windows 7 does not display IE8 or IE9 in "Programs and Features" program list.  It's now a "Feature" you turn on and off.  So the SQL query doesn't find it.  So how do I add it to the query?
Below is the query.  It's the same query duplicated to accomodate x64 OS's (thanks to previous forum here!).  
 
SELECT Add_Remove_Programs_DATA.displayname00 as 'Software Installed', Add_Remove_Programs_DATA.publisher00 as 'Publisher', Add_Remove_Programs_DATA.version00 as 'Version' FROM System_DATA INNER JOIN Add_Remove_Programs_DATA ON System_DATA.MachineID = Add_Remove_Programs_DATA.MachineID where System_DATA.name0 = '::computername::' and (Add_Remove_Programs_DATA.Displayname00 like 'Windows Internet Explorer%' or Add_Remove_Programs_DATA.Displayname00 like 'Microsoft Office Professional%' or Add_Remove_Programs_DATA.Displayname00 like '%SAS%' or Add_Remove_Programs_DATA.Displayname00 like 'Symantec%' or Add_Remove_Programs_DATA.Displayname00 like 'Configuration%'or Add_Remove_Programs_DATA.Displayname00 like '%Java%' or Add_Remove_Programs_DATA.Displayname00 like '%Mozilla%'or Add_Remove_Programs_DATA.Displayname00 like 'Adobe%' or Add_Remove_Programs_DATA.Displayname00 like '%Broadcom%'or Add_Remove_Programs_DATA.Displayname00 like '%Intel%') union SELECT Add_Remove_Programs_64_DATA.displayname00 as 'Software Installed', Add_Remove_Programs_64_DATA.publisher00 as 'Publisher', Add_Remove_Programs_64_DATA.version00 as 'Version' FROM System_DATA INNER JOIN Add_Remove_Programs_64_DATA ON System_DATA.MachineID =  Add_Remove_Programs_64_DATA.MachineID where System_DATA.name0 = '::computername::' and (Add_Remove_Programs_64_DATA.Displayname00 like 'Windows Internet Explorer%' or Add_Remove_Programs_64_DATA.Displayname00 like 'Microsoft Office Professional%' or Add_Remove_Programs_64_DATA.Displayname00 like '%SAS%' or Add_Remove_Programs_64_DATA.Displayname00 like 'Symantec%'or Add_Remove_Programs_64_DATA.Displayname00 like '%Java%' or Add_Remove_Programs_64_DATA.Displayname00 like '%Mozilla%'or Add_Remove_Programs_64_DATA.Displayname00 like 'Adobe%' or Add_Remove_Programs_64_DATA.Displayname00 like '%Broadcom%'or Add_Remove_Programs_64_DATA.Displayname00 like '%Intel%') order by 'Software Installed'

I think you will need to add to the query to look for the software file iexplore.exe with a file verison of 9 or greater to get that information.

I found another canned report that will show me IE8 and IE9 for Windows 7.  The query is
 
Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID
WHERE SP.ProductName = @variable AND SP.ProductVersion >= @variable1
Order by SP.ProductName, SP.ProductVersion
 
How do I add this query into the SMSWEB query?  I guess I need to know how to add the equivalent table (the above report uses a view v_GS_SoftwareProduct) to the select statement for the SMSWEB query:
 
SELECT Add_Remove_Programs_DATA.displayname00 as 'Software Installed', Add_Remove_Programs_DATA.publisher00 as 'Publisher', Add_Remove_Programs_DATA.version00 as 'Version' FROM System_DATA INNER JOIN Add_Remove_Programs_DATA ON System_DATA.MachineID = Add_Remove_Programs_DATA.MachineID
 
If I new the correct table and how to do the INNER JOIN, I think I can do it.  When I look at dbo.SoftwareProduct in SSMS, I don't see a ResourceID so it must be a different table I haven't found yet.
 
Am I on the right track? 
 

You should never query the table directly, you should use only the SQL views. The query looks fine to me, what issue are you having with it?
 
I’m curious why you are using smsweb vs the built-in web report or better yet SSRS reports.

We used the SMSWEB report b/c it gives a nice summary of hardware and a specific subset of software we tweak the query statement for.  I want to add IE8 and/or IE9 but they don't show up in Add_Remove_Program_Data.  I wasn't aware there were other canned reports that could do the same thing.  Which reports are you referring to?
 
Could you help me with the INNER JOIN to get the other view included into my SMSWEB query if the canned reports don't provide the same thing SMSWEB does?
 
Thanks!!
 
 

You should look at SSRS, this will allow you to do that same thing as smsweb and it allow to email subscriptions too.  http://technet.microsoft.com/en-ca/library/cc431436
 
There are about 300+ report built-in to CM07. The close report that is built-in is called "Computers with a specific file".
 
First off you should NEVER query the SQL table directly, it can cause issues with SQL locking ad this could cause SQL transaction to be lost. The query as written should work for you.. If not it is because of the way you have security setup for smsweb service account.. Make sure that your service account has been added to both webreport_approle and smssch_users within your SQL db. Then the query will work without any translations.
 

We have a SQL reporting server in my current environment, but it was setup for another purpose.  Can I tag on SCCM's reporting to this server without much additional strain on it?  Is it easy to keep the SCCM reports separate from the reports that already exist (on the SQL reporting server side)? 
 
I'm no SQL admin, so forgive potentially silly questions.