Bulk association of Component to Asset
I don't see any import mechanism to associate components to assets. Possibly little ongoing need for a tool except for when migrating data into the CMDB.
Is it acceptable to go direct into the database tables and write a SQL statement to insert the relationship without using the provided screens.
What I am looking to do is associate each workstation with a desk , telephone and network floor port, each of which would be defined as components. Is it simply 1 table to be updated with the asset the component is assigned to, or are there other linked relationships that need to be managed at the same time.
Approx 330 workstations to do, and all the data is held electronically at present so is rather labour intensive compared to a quick SQL UPDATE if appropriate.
Kind Regards,
Andy
Is it acceptable to go direct into the database tables and write a SQL statement to insert the relationship without using the provided screens.
What I am looking to do is associate each workstation with a desk , telephone and network floor port, each of which would be defined as components. Is it simply 1 table to be updated with the asset the component is assigned to, or are there other linked relationships that need to be managed at the same time.
Approx 330 workstations to do, and all the data is held electronically at present so is rather labour intensive compared to a quick SQL UPDATE if appropriate.
Kind Regards,
Andy