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
<ahalle-otrs@radprax.de> 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