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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.