Re: [itsm] Possibly spam: Configuration Item Import

There is a table called link_relation that maintains those links. I will be attempting a merge of that table from one of my environments to another since cloning and importing don't seem to carry this table. Best regards, Jim ITIL Process Manager NCDOR 919-715-4932 919-696-0056 - cellular james.burk@dornc.com

...

...

Jim Jackson 8/26/2010 9:23 AM >>> Does anyone have to be a way to import while maintaining the relationships? There is no way we can manually maintain relationships for 3,000 servers with related software, hardware, and network items.

On Tue, Aug 24, 2010 at 8:00 AM, wrote: James Burk wrote :

We have multiple ITSM environments for system and acceptance testing and then production. I have created my CIs and Services and have linked them in their upstream and downstream relationships in the systems test environment. I can export/import the CIs to populate the next two environments, but I lose the relationships. Where are these links maintained and how can I preserve the relationships as I migrate through my environments? (without having to create them all over again)?

Hi Jim, according to Marcos Mail (http://lists.otrs.org/pipermail/itsm/2010-August/000933.html) the relationships are stored in the database table "link_relation" (http://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png , look a bit left and above the center). But I haven't yet delved into this. Exporting or importing them is a common question but AFAIR there was no answer to this on the mailing list or in the forum, I'm sorry :( 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 ************************************ -- Jim Jackson IT Process Manager-Configuration ----------------------------------------------------------------------------- E-Mail correspondence to and from this sender may be subject to the North Carolina Public Records Law, and may be disclosed to third parties. ------------------------------------------------------------------------------