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