Linking Configuration items directly on the DB. [SOLVED]

Moderator: crythias

Post Reply
Amukinado
Znuny newbie
Posts: 76
Joined: 02 Jun 2010, 15:52
Znuny Version: 3.2.8
Location: Portugal

Linking Configuration items directly on the DB. [SOLVED]

Post by Amukinado »

Hi! Had a nice weekend?
I'm stuck with this. I can't figure out what where the link between CONFIGURATION ITEMS is made on the database.

I have so many "articles" in to CI classes, and i wish to link them. It has to be done on the config item part directly on the DB because there are more than 5000 things to relate. I've been making tests linking CI's but the only thing i see is a change in configitem_history, wich add's a record matching the linked object configitem_id on the configitem_history table and a textstring.

Something like this: 4970%%ITSMConfigItem.

On the linked field it happens the same thing but with with the data related with the linked object. This part is obvious.

But if I change it in the DB it does nothing to the app. I supose this is not the data it's reading, but a historical change record. Can you help finding the correct table/field... whatever...


Any one can help?

Thanks!

Regards
Bruno
Last edited by Amukinado on 22 Jun 2010, 17:00, edited 3 times in total.
OTRS V3.2.8 - ITSM 3.2.6 - Cent OS 5.9x64
Amukinado
Znuny newbie
Posts: 76
Joined: 02 Jun 2010, 15:52
Znuny Version: 3.2.8
Location: Portugal

Re: Linking Configuration items directly on the DB.

Post by Amukinado »

Solved! Don't rely only on documents like I was doing! Lesson learnd!

When i looked at the DB through the mysqclient there's a table called link_relation!

Regards
Bruno
OTRS V3.2.8 - ITSM 3.2.6 - Cent OS 5.9x64
Post Reply