Search and remove multiple records from Insight CMDB automatically

[Deleted user]

Hi all,

We use Insight with a CMDB. We would like to search and remove a list of records. The key to search for is "registration number".

The idea is to loop through a list of registration numbers and if found delete the record.

I have no experience with scripting and new to Insight. Hope there is anyone with some tips.

[Deleted user · Accepted solution]

I solved it, very very easy

"Registrationnumber" IN ("<number>","<number>")

[PD Sheehan]

Is this a one-time thing? Or some automation that you want to happen at some regular interval?

Can't you just use IQL to search for matching records and then manually invoke the bulk delete feature?

If you want something regular, you can use the built-in automation feature with a scheduled trigger (with IQL) and delete object action.

[Deleted user]

Hi Peter-Dave. It needs to run at a regular interval.

With built-in automation you mean in Jira or does Insight has its own automation?

[PD Sheehan]

Insight has its own automation. But looking more carefully, I see that it's missing a built-in action to delete. But you can create an automation event with a short delete script.

Create a script file in your jira installation file system. A suggested path is <jira-home>/scripts.

Eg. <jira-home>/scripts/insight_automation/deleteObject.groovy

The file should be readable by jira.

Add these lines to the file:

import com.atlassian.jira.component.ComponentAccessor
import com.riadalabs.jira.plugins.insight.channel.external.api.facade.ObjectFacade
def objectFacade = ComponentAccessor.getOSGiComponentInstanceOfType(ObjectFacade)
objectFacade.deleteObjectBean(object.id)

Add the script file to the insight whitelist: <yoursite>/secure/admin/InsightPluginWhiteList.jspa

Create an Insight automation:

Look under the Object Schema configuration. There is an Automation tab.

1. Create a new Rule
2. Give it a name
3. Set the "run as" user to a service or admin account with delete permissions
4. Add a trigger
   • Event Trigger = Scheduled Event
   • Condition=Enter the IQL that returns records that you want to delete regularly
   • Cron Expression = set the interval
5. Add an action
   1. Action=Execute Groovy Script
   2. File Path = /path/to/your/script.groovy