Symantec Management Platform (Notification Server)

 View Only
  • 1.  Inaccurate Summary Reports

    Posted Nov 16, 2010 11:36 AM

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



  • 2.  RE: Inaccurate Summary Reports

    Broadcom Employee
    Posted Nov 18, 2010 05:33 AM

    It looks like the report is not getting distinct values to do the count on.  Try cloning the report and replace query 1 with the script below.

    Select
    t0.[Name] AS 'Name',
    t0.[Publisher] AS 'Publisher',
    COUNT(*) AS 'Number'
    FROM
    (
    SELECT distinct
    [Inv_AeX_OS_Add_Remove_Programs] ._ResourceGuid,
    [Inv_AeX_OS_Add_Remove_Programs].[Name] AS 'Name',
    [Inv_AeX_OS_Add_Remove_Programs].[Publisher] AS 'Publisher'
    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%
    ) t0
    GROUP BY t0.[Name], t0.[Publisher]



  • 3.  RE: Inaccurate Summary Reports

    Posted Nov 18, 2010 11:02 AM

    I agree with doug   yes