Unable to right click or create/edit certain Configuration Items reports, such as Services

book

Article ID: 157973

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server) Asset Management Solution CMDB Solution

Issue/Introduction

When trying to access the right click menu or create or edit certain out of box Configuration Items (CI), such as Services, these functions do not work. Other CIs, such as Computers, however, do work.

Cause

Two causes will result in this:

  1. This is a defect. Certain older CI reports do not include drill-down or edit capabilities in their drill-down tab, resulting in right click, create and edit issues. Or,
  2. This is working as designed, if this is a custom report. Custom reports do not necessarily immediately enable the right click menu or creation/editing of their records.

Resolution

Depending on the cause, two solutions are available.

Cause: Out of box CI report is unable to use right click or create/edit.
Solution: For Symantec Management Platform 7.1 pre-SP2, clone the problem reports and add the missing areas to their drill-down tab, as described in the following articles:

Right click menu fails to work when using a custom report or custom resource
http://www.symantec.com/business/support/index?page=content&id=TECH176318

How to enable double click editing of assets in a custom report
http://www.symantec.com/business/support/index?page=content&id=HOWTO83282

Or, upgrade to Symantec Management Platform 7.1 SP2 or higher, which should resolve the issue.

This article also includes some 7.1 SP2 (which should be backward compatible with older versions of 7.1) modified reports. These can be imported into the Symantec Management Platform Console (in reports, right click on a report folder and choose Import) to overwrite the out of box versions, which will also fix the issue. Reports so far included are: 

  • Services = All Resources Picker Report


Cause: Custom report is unable to use right click ore create/edit.
Solution: Edit the custom report and ensure that its drill-downs include these functions (similar to the above issue and solution and the following article), and, for SQL reports, ensure that the GUID is used in the SELECT statement and is referred to as "_ItemGuid".

Right click menu fails to work when using a custom report or custom resource
http://www.symantec.com/business/support/index?page=content&id=TECH176318

For example:

  1. Click on the Edit button of the custom report.
  2. In the Parameterized Query tab, review the SQL script. The SELECT statement is likely to not be passing the GUID as "_ItemGuid", such as:

    SELECT Name
    FROM vComputer

    Or,

    SELECT Guid, Name
    FROM vComputer
     
  3. Change the SELECT to include the GUID and refer to it as "_ItemGuid", such as:

    SELECT Guid '_ItemGuid', Name
    FROM vComputer
     
  4. Click on the Save Changes button.


Related Article

How to create a custom report for assets
http://www.symantec.com/business/support/index?page=content&id=HOWTO100089


Applies To

ITMS 7.1 pre-SP2.
ITMX 7.x.

Attachments

All Resources Picker Report.xml get_app