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