Service Catalog - Modify Request ID format

[Sutot]

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.

[Louis van Amelsfort]

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.

[Sutot]

It works, thank you..

 

Best regards,

S.