The 'Requestor' and 'Affected End User' attributes in WEBI reports for Requests display the same value, this value corresponds always to the 'Affected End User'.

book

Article ID: 18232

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

The Business Intelligence(BI) WEBI Reports on Requests coming with the default CA ServiceDesk Universe, may contain 'Requestor' and 'Affected End User' attributes.

These two attributes have always the same value corresponding to the 'Affected End User' value, this is not the correct value for the 'Requestor' attribute.

Note: You may follow the informational solution below to work around the problem; alternatively, please contact CA Support.

Solution:

In the Request Detail in the Service Desk GUI, you can find the Affected End User' and 'Requester' attributes.

In BI WEBI reports, they should respectively match the attributes 'Affected End User' and 'Requestor'.

To review the alias mappings for these attributes follow these steps:

  1. Login to Service Desk interface and go to Administration Tab --> Service Desk --> Application Data -> Codes --> Attribute Aliases

  2. Click on Show Filter

  3. Type: cr in the object name section

  4. Type: requestor% in the Alias Name section

  5. Click Search

  6. The Attribute Alias List with 8 entries will be displayed; see the picture below:

    <Please see attached file for image>

    Figure 1

  7. If the mapping shows:
    Object Name   Alias Name                  Alias Valuecr            requestor_xxx               customer.xxx

    then the mapping is between 'Requestor' and 'Affected End User' (obj: customer).

    To set the correct mapping do:

  8. On SDM Primary, take a backup first by opening a command prompt and type: pdm_extract attr_alias > ca_attr_alias.txt

  9. Go to step 6. and right click and edit on each entry; change the Alias Value from 'customer.xxx' to 'requested_by.xxx' as below:
    Object Name   Alias Name                  Alias Value cr            requestor_combo_name        requested_by.combo_name 

  10. The next time the report will run, the extracted values will correctly match.

Environment

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component:

Attachments

1558702296139000018232_sktwi1f5rjvs16psv.gif get_app