Client Management Suite

 View Only
Back to Library

SQL Report: Computers with MS Office 2003 Without 2007 Compatibility Pack 

Aug 27, 2008 10:14 PM

Here's some SQL that'll query computers with MS Office 2003 without the Office 2007 compatibility pack. Just go to reports, create a new one, and select 'Enter SQL Directly', then copy and paste the sql into there. 

SELECT T0.[Domain] AS 'Domain', T0.[Name] AS 'Name',
T0.[OS Name] AS 'OS Name', T1.[Name] AS 'Name' FROM 
[Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Microsoft Office%' AND T1.[Name] LIKE '%Edition 
2003%' AND T0.[Name] NOT IN (SELECT T0.[Name] AS 'Name'
FROM [Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Compatibility Pack for the 2007 Office system')

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Migration User
Sep 03, 2008 02:57 PM

Interesting. Altiris Console doesn't care, but it can't hurt for me to tidy up my SQL. :)

Migration User
Sep 03, 2008 01:57 PM

We were able to run this in our environment. I handed the results off to our end user technology team for them to review.
One item to note is that I had to break up the SQL before it ran and returned data. My SQL Server Mgmt Studio did not like it all bunched together.
-d
SELECT T0.[Domain] AS 'Domain',
T0.[Name] AS 'Name',
T0.[OS Name] AS 'OS Name',
T1.[Name] AS 'Name'
FROM [Inv_AeX_AC_Identification] T0
INNER JOIN [Inv_AeX_OS_Add_Remove_Programs] T1
ON T0.[_ResourceGuid] = T1.[_ResourceGuid]
WHERE T1.[Name] LIKE 'Microsoft Office%'
AND T1.[Name] LIKE '%Edition 2003%'
AND T0.[Name] NOT IN
(
SELECT T0.[Name] AS 'Name'
FROM [Inv_AeX_AC_Identification] T0
INNER JOIN [Inv_AeX_OS_Add_Remove_Programs] T1
ON T0.[_ResourceGuid] = T1.[_ResourceGuid]
WHERE T1.[Name]
LIKE 'Compatibility Pack for the 2007 Office system')

Related Entries and Links

No Related Resource entered.