Establishing Associations or Relationships Between existing data
Does anyone have experience creating relationship between two different sets of existing records in a batch/bulk mode using SQL tools? The situation at hand is that we have a number of workstations discovered by scans and a number of monitors loaded with the SDP csv import tool. I would like to establish a relationship between the two records (525 records total) so that it will appear in the "Relationships" tab one sees in Asset Home > Workstations > Asset Name.
Does anyone have some advice on how this can be done? (SQL tools, direct to the database tables are fine)
Thanks!
-george