Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search and remove multiple records from Insight CMDB automatically

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.

 

 

2 answers

1 accepted

0 votes
Answer accepted

I solved it, very very easy

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

1 vote

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.

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?

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

98 views 1 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you