How to start Reference Number (Id) on a Process at a specific value

Version 7

    Verified Product Versions

    LANDESK Service Desk 7.7.x

    Environment:

     

    Service Desk - All Versions

     

    Question: 

     

    We are about to go live with LANDesk ServiceDesk, we would like to change the starting reference number for Incidents to keep in sequence with our existing numbering plan, i.e. I would like to start recording incidents at a specific value.

     

    Answer:

     

    This is achievable by copying out the following value and running this in your SQL Management towards the relevant Service Desk Database.

     

     

    Please ensure before applying the script, that a backup of your LANDesk ServiceDesk Database has taken place and tested thoroughly before going live, additionally when re-seeding, please do ensure that you are starting from a number that is not in use already.

     

    In the example scripts below, we will start recording each process type from Reference Number 50000.

     

     

    Incident  -- DBCC CHECKIDENT ('im_incident', RESEED, 49999)

     

    Request -- DBCC CHECKIDENT ('rm_request', RESEED, 49999)

     

    Problem -- DBCC CHECKIDENT ('pr_problem', RESEED, 49999)

     

    Change --  DBCC CHECKIDENT ('cm_change', RESEED, 49999)

     

     

    For Oracle

     

    In Oracle Databases, this is known as Dropping the Sequence whereby we start at reference number 50000.

     

     

    DROP SEQUENCE RM_REQUEST$SEQ;

    CREATE SEQUENCE RM_REQUEST$SEQ MINVALUE 1 MAXVALUE 999999999999999999999999999

    INCREMENT BY 1 START WITH 50000

    NOCACHE NOORDER NOCYCLE;

     

    DROP SEQUENCE CM_CHANGE$SEQ;

    CREATE SEQUENCE CM_CHANGE$SEQ MINVALUE 1 MAXVALUE 999999999999999999999999999

    INCREMENT BY 1 START WITH 50000

    NOCACHE NOORDER NOCYCLE;

     

    DROP SEQUENCE PR_PROBLEM$SEQ;

    CREATE SEQUENCE PR_PROBLEM$SEQ MINVALUE 1 MAXVALUE 999999999999999999999999999

    INCREMENT BY 1 START WITH 50000

    NOCACHE NOORDER NOCYCLE;

     

    DROP SEQUENCE IM_INCIDENT$SEQ;

    CREATE SEQUENCE IM_INCIDENT$SEQ MINVALUE 1 MAXVALUE 999999999999999999999999999

    INCREMENT BY 1 START WITH 50000

    NOCACHE NOORDER NOCYCLE;