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