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 <[email protected]> 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 > --------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
