Hi All,
I want to create a report that lists the count of software by software name and publisher, and on the drilldown show the computer details for that software.
The report runs without errors, however the results returned to not match on the main report and the drilldown. For example Adobe Acrobat 5.0 shows 101 computers, but if I go into the drilldown only 78 computers are present.
I have seen the Altiris KB which advises to delete the vresouce table and INNER JOIN, however this doesnt seem to make any difference. Any help would be greatley appriciated. Please note this report has 2 parameters that are required by the user.
Please help ! :) thanks.
SQL below:
Global Parameters
Software Name
Publisher
LEVEL 0 :
SELECT [Inv_AeX_OS_Add_Remove_Programs].[Name] AS 'Name', [Inv_AeX_OS_Add_Remove_Programs].[Publisher] AS 'Publisher', COUNT(*) AS 'Number' FROM [Inv_AeX_OS_Add_Remove_Programs] WHERE [Inv_AeX_OS_Add_Remove_Programs].[Name] LIKE %Software Name% AND [Inv_AeX_OS_Add_Remove_Programs].[Publisher] LIKE %Publisher% GROUP BY [Inv_AeX_OS_Add_Remove_Programs].[Name], [Inv_AeX_OS_Add_Remove_Programs].[Publisher]
LEVEL 1:
SELECT T1.[Name] AS 'Name', T1.[Publisher] AS 'Publisher', [Inv_AeX_AC_Identification].[Name] AS 'Name', [Inv_AeX_AC_Identification].[Domain] AS 'Domain', [Inv_AeX_AC_Identification].[Last Logon User] AS 'Last Logon User', [Inv_AeX_AC_Identification].[OS Name] AS 'OS Name' FROM ( [vResourceEx] T0 INNER JOIN [Inv_AeX_OS_Add_Remove_Programs] T1 ON T0.[Guid] = T1.[_ResourceGuid] ) INNER JOIN [Inv_AeX_AC_Identification] ON T1.[_ResourceGuid] = [Inv_AeX_AC_Identification].[_ResourceGuid] WHERE T1.[Name] like '%Adobe Acrobat%' AND T1.[Name] = '%Name%' AND T1.[Publisher] = '%Publisher%'