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
