Deleting a Config Item

newer
hiding CIs [was : Deleting a...

older
Configuration Item Import

Yasir Mughal

19 Aug 2010 19 Aug '10

5:08 a.m.

Is there any way to remove unwanted Config Items? Thanks,

Show replies by date

Bryan Baldwin

19 Aug 19 Aug

6:28 a.m.

On 08/19/2010 05:08 PM, Yasir Mughal wrote:

...

Is there any way to remove unwanted Config Items?

The simplest thing you can do is set the item to "invalid". Bryan

The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that. Thanks, On 8/19/10, Bryan Baldwin wrote:

...

On 08/19/2010 05:08 PM, Yasir Mughal wrote:

...
Is there any way to remove unwanted Config Items?

The simplest thing you can do is set the item to "invalid".

Bryan --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Bryan Baldwin

6:52 a.m.

On 08/19/2010 06:40 PM, Yasir Mughal wrote:

...

The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that.

I don't see why you can't simply make corrections to the data as it stands. You don't really have to remove the database rows, but you probably can. This is not recommended to do so if your config items have been in use and linked in tickets etc etc. Even so, there are six tables that may contain data about the config item you wish to remove. mysql> show tables like "%config%"; +---------------------------+ | Tables_in_otrs (%config%) | +---------------------------+ | configitem | | configitem_counter | | configitem_definition | | configitem_history | | configitem_history_type | | configitem_version | +---------------------------+ 6 rows in set (0.00 sec) Deleting the main row in configitem should be enough, although this may leave some dangling bits in the other five tables. As such, its recommended to edit the item or simply set it to "invalid". Cheers! Bryan

Yasir Mughal

7:13 a.m.

Thanks for the hint, as some of the records has been entered by mistake and there is no point in keeping those in DB. On 8/19/10, Bryan Baldwin wrote:

...

On 08/19/2010 06:40 PM, Yasir Mughal wrote:

...
The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that.

I don't see why you can't simply make corrections to the data as it stands. You don't really have to remove the database rows, but you probably can. This is not recommended to do so if your config items have been in use and linked in tickets etc etc. Even so, there are six tables that may contain data about the config item you wish to remove.

mysql> show tables like "%config%"; +---------------------------+ | Tables_in_otrs (%config%) | +---------------------------+ | configitem | | configitem_counter | | configitem_definition | | configitem_history | | configitem_history_type | | configitem_version | +---------------------------+ 6 rows in set (0.00 sec)

Deleting the main row in configitem should be enough, although this may leave some dangling bits in the other five tables. As such, its recommended to edit the item or simply set it to "invalid".

Cheers!

Bryan --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Yasir Mughal

7:14 a.m.

BTW, I still do not understand how to set an individual item (data) as invalid. On 8/19/10, Yasir Mughal wrote:

...

Thanks for the hint, as some of the records has been entered by mistake and there is no point in keeping those in DB.

On 8/19/10, Bryan Baldwin wrote:

...
On 08/19/2010 06:40 PM, Yasir Mughal wrote:

...
The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that.

I don't see why you can't simply make corrections to the data as it stands. You don't really have to remove the database rows, but you probably can. This is not recommended to do so if your config items have been in use and linked in tickets etc etc. Even so, there are six tables that may contain data about the config item you wish to remove.

mysql> show tables like "%config%"; +---------------------------+ | Tables_in_otrs (%config%) | +---------------------------+ | configitem | | configitem_counter | | configitem_definition | | configitem_history | | configitem_history_type | | configitem_version | +---------------------------+ 6 rows in set (0.00 sec)

Deleting the main row in configitem should be enough, although this may leave some dangling bits in the other five tables. As such, its recommended to edit the item or simply set it to "invalid".

Cheers!

Bryan --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Bryan Baldwin

8:22 a.m.

On 08/19/2010 07:14 PM, Yasir Mughal wrote:

...

BTW, I still do not understand how to set an individual item (data) as invalid.

I'm sorry, for ITSM config items the states are either inactive, expired, or retired which indicate the item is not in service.

Yasir Mughal

27 Aug 27 Aug

4:46 a.m.

Now I know the tables, wondering if anybody out there, with good grip on SQL can throw in a little sql script to delete the data. I have a feeling that it will be useful for lot of people out there. Thanks, On 8/19/10, Bryan Baldwin wrote:

...

On 08/19/2010 06:40 PM, Yasir Mughal wrote:

...
The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that.

I don't see why you can't simply make corrections to the data as it stands. You don't really have to remove the database rows, but you probably can. This is not recommended to do so if your config items have been in use and linked in tickets etc etc. Even so, there are six tables that may contain data about the config item you wish to remove.

mysql> show tables like "%config%"; +---------------------------+ | Tables_in_otrs (%config%) | +---------------------------+ | configitem | | configitem_counter | | configitem_definition | | configitem_history | | configitem_history_type | | configitem_version | +---------------------------+ 6 rows in set (0.00 sec)

Deleting the main row in configitem should be enough, although this may leave some dangling bits in the other five tables. As such, its recommended to edit the item or simply set it to "invalid".

Cheers!

Bryan --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Alexander Halle

19 Aug 19 Aug

8:45 a.m.

Yasir Mughal wrote :

...

The invalid option is for the metadata, I am looking for delete option for the actual data. For example I was adding information for computers, and out of 8 entries, one is incorrect and I want to delete that.

Hi, currently you can't delete config items via the GUI or a provided script. There exists a bug report (http://bugs.otrs.org/show_bug.cgi?id=4952) which you can subscribe to get notifications and to show how many users needs the solution. But although deleting config items is a common question here no one subscribed this bug :( Please notice that you can set config items to inactive and so on but they will still get displayed. So this is very annoying if you make errors, especially if you use the import function to add a lot of config items in one go (I use a test system to reduce this risk for one-time imports). Regards Alexander -- radprax Gesellschaft fuer medizinische Versorgungszentren mbH, Bergstr. 7 - 9, 42105 Wuppertal, Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119 Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate Tewaag Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 132/5889/0264, DE 814559152 Web: http://www.radprax.de

5466

Age (days ago)

5474

Last active (days ago)

List overview

Download

8 comments

3 participants

participants (3)

Alexander Halle
Bryan Baldwin
Yasir Mughal