It is useful for Administrators to be able to convert a Contact "uuid" or "id" into the actual Contact "name."
Examples of use:
How to convert the id or uuid into an actual Contact name?
Any version of CA Service Desk Manager or CA ITSM.
The "real name" of a user is stored in the ca_contact table in the fields first_name, middle_name and last_name.
There is additional information related to the user stored in another table usp_contact, but that is not needed for relating id to name.
Example: Identifying who ran a long running query.
Long running queries over two seconds are written to the CA SDM/ITSM /log/stdlog.
Here is an example:
05/24 10:19:16.93 MY_SERVER sqlagt:select0 4076 ERROR sqlclass.c 1057 The following statement took 71012 milliseconds: Clause (SELECT call_req.open_date, call_req.id, call_req.ref_num, call_req.id FROM call_req WHERE ( call_req.active_flag = 1 AND call_req.priority = 3 AND ( call_req.assignee IS NOT NULL OR call_req.group_id IS NOT NULL ) AND ( call_req.type = ? ) AND call_req.description LIKE ? ) AND ( ( call_req.group_id IN (SELECT grpmem.group_id FROM grpmem WHERE grpmem.member = ?) ) ) ORDER BY call_req.open_date DESC) Input (<string>I|<string>QUOKKA|<uuid>C4BDFCD53AA2D84EA04F74ECAE8B4965)
1. Identify the id or uuid.
All SQL queries of this type contain the uuid of the contact who called them as the last item.
Here, that uuid is:
2. Add "U" to the front of the string and surround with single quotes:
3. Call from either pdm_extract or via the web client interface.
3A. Through the interface:
3B. Through pdm_extract:
You may now use the user information to further trouble-shoot the original issue.