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 <bryan.baldwin@otrs.com> 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
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
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 <bryan.baldwin@otrs.com> 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
BTW, I still do not understand how to set an individual item (data) as invalid. On 8/19/10, Yasir Mughal <mughal@gmail.com> 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 <bryan.baldwin@otrs.com> 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
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 <bryan.baldwin@otrs.com> 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 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
participants (3)
-
Alexander Halle -
Bryan Baldwin -
Yasir Mughal