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
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