How do I delete a specific incident?

Version 9

    Verified Product Versions

    LANDESK Service Desk 7.6LANDESK Service Desk 7.7.xLANDESK Service Desk 7.8.xLANDESK Service Desk 2016.xLANDESK Asset Central 2016.x

    Question

    Attached script will delete one or more incidents. Specify which incident(s) to delete via a sql select statement in the script.

    It will need to be amended to include deletion from any user-defined tables that depend on incident.

    Answer

    Take a backup first! and ensure that all users are logged out of the system.

     

    Find the Script Attached below

     

    NOTE: These are example SQL scripts written for the OOTB database which will need to be altered to accomodate the DB structure that you apply it to.  Currently no Oracle version exist but your DBA can use the existing example to adapt.


    Assistance to customize the script to meet your requirements can be requested via your Account Manager to engage professional services.