I did it once If I'm not wrong... btw, still if I'm well remembering, it was just some insert into:
mysql> desc link_relation; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | source_object_id | smallint(6) | NO | PRI | NULL | | | source_key | varchar(50) | NO | PRI | NULL | | | target_object_id | smallint(6) | NO | PRI | NULL | | | target_key | varchar(50) | NO | PRI | NULL | | | type_id | smallint(6) | NO | PRI | NULL | | | state_id | smallint(6) | NO | MUL | NULL | | | create_time | datetime | NO | | NULL | | | create_by | int(11) | NO | MUL | NULL | | +------------------+-------------+------+-----+---------+-------+ On Fri, Aug 20, 2010 at 12:30 PM, Alexander Halle <[email protected]>wrote: > Hi, > > has anybody an idea how to mass set links when you have a lot of similiar > sets of CIs ? > > Example : > > - Switch1 is linked to Switch1-Port1, Switch1-Port2, Switch1-Port3 > - Switch2 is linked to Switch2-Port1, Switch2-Port2, Switch2-Port3 > - Switch3 is linked to Switch3-Port1, Switch3-Port2, Switch3-Port3 > - Switch4 is linked to Switch4-Port1, Switch4-Port2, Switch4-Port3 > > The mass creating can be done via csv import, but the linking will be a > nightmare via GUI :( > > Thanks in advance > > 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 > > > --------------------------------------------------------------------- > 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
