Need an easy way to identify which jobs are using which preboot configuration so we can delete unneeded preboot configurations

Products

• Ghost Solution Suite

Issue/Introduction

Can't delete preboot configurations as the 'In use by ...' says 'Yes'.

Need an easy way to identify which jobs are using which preboot configurations

Environment

GSS 3.3 

Cause

Preboot configurations are assigned to a job

Resolution

1. The following SQL can be used to identify which jobs are using which preboot configuration:
   
   

   Select task.event_id, task.bootoption_id, event.name, boot_options.pxe_description
From task, event, boot_options
Where task.event_id = event.event_id AND task.bootoption_id = boot_options.bootoption_id
Order by boot_options.pxe_description

   

   
   
   
2. Then, from the GSS Console locate the job, edit it, and remove the preboot configuration that is assigned to it.
3. Once all the jobs have been removed the 'In use by ...' field should be empty.
   At this point, the preboot configuration can be deleted.