CA Service Management

Expand all | Collapse all

Service Catalog - Modify Request ID format

Jump to Best Answer
  • 1.  Service Catalog - Modify Request ID format

    Posted 01-23-2017 09:11 AM

    Hi all,

     

    in Service Catalog requests numeration is '10001', '10002', '10003', ...

     

    Is it possible to add some digit to request id? Eg: '1000001', '1000002,'1000003',...

     

    Best regards,

    S.



  • 2.  Re: Service Catalog - Modify Request ID format
    Best Answer

    Posted 01-23-2017 09:49 AM

    Good Afternoon Salvatore.

     

    After you execute this query:
    SELECT name,id FROM usm_lastid where name = 'request_id'
    You'll see the current and latest/highest delivered value.
    request_id 10155

     

    You could decide to update that row like this:
    update usm_lastid set id = 100001 where name = 'request_id'

     

    1. Stop the SC-Service
    2. Update the row as in above update-query
    3. Start the SC-Service
    4. And open a new request there after (its id will be 100002, the 'last'+1)

    With a local test, I could then also add a note and attachment to this new request.

    You can also check for this in tecdoc: https://ecm.ca.com/kb/Pages/authoring/create-KB-Article.aspx?kbid=TEC477449

    Please test this carefully and let me know your findings.

     

    Thanks and kind regards, Louis van Amelsfort.



  • 3.  Re: Service Catalog - Modify Request ID format

    Posted 01-23-2017 01:02 PM

    It works, thank you..

     

    Best regards,

    S.