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.
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.
The file should be readable by jira.
Add these lines to the file:
def objectFacade = ComponentAccessor.getOSGiComponentInstanceOfType(ObjectFacade)
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.