One of the problems with the canned compliance reports is the lack of easily isolated Service Pack information, so I created a report that allows you to select Windows 2000, XP, or Vista and then filter out the most recent SP for that OS.

1. Create a new report
2. Give your report a meaningful name
3. Enter SQL directly
4. Copy and paste this SQL into the text box
5. Click finish (testing won't work here, because we need to create a few parameters first)

*Continued below*

SELECT T0.[Name] AS 'Name', 
T0.[Domain] AS 'Domain', 
T0.[Last Logon User] AS 'Last Logon User', 
T1.[OS Name] AS 'OS Name', 
T1.[Service Pack] AS 'Service Pack' 

FROM [Inv_AeX_OS_Operating_System] T1 
RIGHT OUTER JOIN [Inv_AeX_AC_Identification] T0 
ON T1.[_ResourceGuid] = T0.[...

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')

There are many installshield applications (MSI)/ Other Vendor MSI which come wrapped in setup.exe. The packagers can extract the MSI easily, but while installing the MSI, sometimes an error comes which says that the MSI can be installed only through setup.exe.

This can be solved by two ways:

1. For Installshield applications, Set the Property ISSETUPDRIVEN=1, this will remove the error and you can install your MSI.
2. If the above does not work and also for non Installshield packages, if you still get the error, then you can create a verbose log file and search for "Return Value 3". This will take you to the Custom Action which has caused the error. You can disable this CA and then try installing the application. This works most of the time. However there are some applications in which...

I may be crazy but I could not find a nice easy way of reporting on the success of a software delivery task other than the 'status' tab (Which I can't copy to Excel).

So when I came across KB Article: How do I make a report that will give me the same info as the Status tab? https://kb.altiris.com/article.asp?article=3709&p=1

I was very happy however there are 2 issues:

1. I need to specify the GUID.
2. I need cannot limit based on success or failed.

So attached is my report that solves these issue, please rename from .txt to .xml.

By the way there are no warranties etc. my environment is NS v6.0.6074