Is there a way to report on the time a CA Service Desk (CA SDM) ticket is opened minus the time the ticket spends in a certain status (i.e. on hold)?

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

Is there a way to report on the time a CA Service Desk (CA SDM) ticket is opened minus the time the ticket spends in a certain status (i.e. on hold)?

Environment

CA Service Management 14.x and 17.x

Resolution

Unfortunately, there is no function out of the box in either CA Service Desk Manager (CA SDM) or CA Business Intelligence/JasperSoft that provides this information in one step.

The reason is that the time the ticket spends in a certain status (i.e. On Hold) is not stored anywhere at the MDB level so it can not be retrieved as a single piece of information.

This information, however, can be retrieved from the ticket's Activity Log. Within the Activity log, it is documented when the status of a ticket has changed and the corresponding time stamp.

Unfortunately, this will require custom report writing.  You will need the time stamp for a specific request (call_req_id and time stamp) for an initial action. Then search for an action type "ST" which means status changed. If the action_description contains HOLD, or whatever status you wish to report on, take the time stamp again.

Unfortunately, custom report writing is out of scope for Broadcom Support, but the following alternatives are recommended:

1. Post a comment in Broadcom Communities where many CA SDM customers share knowledge and ideas.

https://community.broadcom.com/enterprisesoftware/communities/communityhomeblogs?CommunityKey=e2cd3188-49bc-4f38-88f1-74260f56fa66

2. Engage Broadcom Services to offer a solution.