Need to delete a few CI classes, which hold irrelevant data, Using Rome version
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2022 12:26 AM
Working on a CMDB with a huge number of irrelevant CIs & Classes ( confirmed irrelevance from the relevant Business and Technical owners).
Would really help if I could some guidance on it.
- Labels:
-
Data Foundations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2022 05:07 PM
Hi, records can be archived, deleted manually, or all records in a table can be deleted via menu module 'Tables & Columns' (UI button 'Delete All Records'), but I would first check to ensure that the records are nor used\referenced in current tasks, reports, scripts, workflows, catalogs etc.
If the classes\tables are custom you will also be able to delete them via 'Tables & Columns' once you have deleted all the records in the table, again I would suggest that you check to see if they are used anywhere first and would also recommend that you use an update set to push any required code changes to prod. I am not sure if you can delete tables by update-set (I doubt it would be possible if they contain existing records) but I would include an table deletions in an update-set.
If you are going to delete records I would recommend that you first export them as xml, so that you have a backup just in case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2022 11:24 PM
Hi Tony, Management of records isn't a problem , I got the Data Manager for it.
Deleting OOB tables is the problem, custom tables is easy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022 05:02 PM
Hi, deletion of an OOB table would never be an appropriate thing to do, and I don't think it's possible.
If you don't want to use the table, then just don't use it.
You can set menu modules as inactive and update ACL's to prevent direct access and reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2022 09:39 PM
Hi Tony, I am fine with disabling discovery for a Class as well. A sample use case is as follows. The Windows servers (cmdb_ci_win_server) when being discovered, have their disks being discovered. The Disks are showing up in a separate table as well (cmdb_ci_disk). I don't want the disks to be discovered in a separate table.
Similar scenarios exist in Routers and Switches, as shown in the screenshots.
If you can help or direct on how to disable a Class that will be helpful.
