Video Screencast Help
Search Video Help Close Back
to help

Please can you fix the default ShowContextMenu drilldown?

Created: 06 Jun 2012 | 2 comments
QuietLeni's picture
0 Agree
0 Disagree
0 0 Votes
Login to vote

Dear Symantec,

Since I got onto SMP 7.1, whenever I make a new Report, I ALWAYS have to go to the Drilldowns area and delete the current ShowContextMenu item and re-create it because it is not working AT ALL!

I just realised, however, that the reason for this not working is because the Guid of the Computer in the report generator is setting the ALIAS to be "_ItemGuid". If you change this alias to be "_ResourceGuid", then the report and its drilldown starts to work.

So... can you please set Computer Reports to use the default alias of "_ResourceGuid" and set the Parameter Mapping to be "_ResourceGuid" mapped to "_ResourceGuid" in the Drilldown tab?

Kindest regards,

QuietLeni

Comments 2 CommentsJump to latest comment

odami's picture

You have to use the Alias function of SQL to set the Guid field to _ItemGuid.

Example:

 

Select 
ai.Guid AS [_ItemGuid]
,ai.Name as [Computer Name]
From vRM_Asset_Item ai
 
Symantec cannot set [_ResourceGuid] as the default because many tables use [Guid] in place of [_ResourceGuid]

 

0
Login to vote
QuietLeni's picture

Yes, you may be able to set this, but I want Symantec to make the default functionality work again!

I stand by the accuracy of my Inventory of the organisation. Don't blame me for the picture that it presents...

0
Login to vote