Symantec Management Platform (Notification Server)

 View Only

Inconsistent Report Drilldown Context Menu with Resource Manager

  • 1.  Inconsistent Report Drilldown Context Menu with Resource Manager

    Posted Oct 15, 2012 12:16 PM

    I'm in the process of migrating from NS 6.x to 7.1 SP2 MR1.  Anyway, while building a custom report I've encountered some strange behavior hopefully someone can explain.

    So given the following query with '_ItemGuid' wired up to the default drilldown "ShowContextMenu".  When I right-click the menu shows 6 items none of which are the "Resource Manager".

    SELECT
       comp.[Name]
       ,prog.[DisplayName]
       ,comp.[Guid] '_ItemGuid'
    FROM [vComputer] comp
    JOIN [Inv_AddRemoveProgram] prog
    ON comp.[Guid] = prog.[_ResourceGuid]

    Now with the exact same report if I do not display the "prog.[DisplayName]" column the right-click menu shows about 15 items the first one being the "Resource Manager".

    SELECT
       comp.[Name]
       --,prog.[DisplayName]
       ,comp.[Guid] '_ItemGuid'
    FROM [vComputer] comp
    JOIN [Inv_AddRemoveProgram] prog
    ON comp.[Guid] = prog.[_ResourceGuid]

    Or I can have the same query as the first except use a LEFT JOIN and show computers that don't have not reported add or remove program inventory.  Click on a computer that doesn't have add remove program inventory and I see the full context menu.  Click on a computer that has a program displayed and I only get 6 items on the context menu.

    SELECT
       comp.[Name]
       ,prog.[DisplayName]
       ,comp.[Guid] '_ItemGuid'
    FROM [vComputer] comp
    LEFT JOIN [Inv_AddRemoveProgram] prog
    ON comp.[Guid] = prog.[_ResourceGuid]

    How come the context menu doesn't always show the Resource Manager and other items?  Is there a way to configure it so the full context menu is displayed?  Any help or insight would be appreciated.

    Thanks