1 Reply Latest reply on Jun 23, 2016 12:37 PM by Jamie Cannon

    Help with backfilling values

    CAGreen Apprentice

      Hi, I currently have a ranked object within my incident window, I require the Impact and Urgency fields to be changed from non mandatory to mandatory fields


      However when I change the properties of those fields to TRUE, all the incident calls break as these fields have been left blank and are no longer amendable.


      Any new call raised works as expected, this is for use with the console version of Landesk 7.8.1

        • 1. Re: Help with backfilling values
          Jamie Cannon ITSMMVPGroup

          Your best option is going to be to run a quick SQL command on the database itself.


          First, do a Select * from im_impact and find the QUID of the value you want each "existing" one to be set to.

          Second run a statement like:


          Update im_incident

          Set im_impact ='INSERT GUID HERE'

          Where im_impact IS NULL


          The attribute names may need to be tweaked a little bit but this should get you pointed in the right direction.  If you need a step through, support should be able to walk you through this pretty quickly as long as you have access to the database.