I'm importing data from another Help Desk and i'm a little bit of stuck with the CIs mapping to service contracts.
I can see that the relations are in the sdsc_map table, but there's a way of doing it in a massive way and not from the web interface? Like for example with grloader and an excel spreadsheet:
name class contract_num
*** *** related_contract
Thanks for your help!
Maybe I'm mistaken, but from what I can see it doesn't look like you can related a Service Contract to a CI, you can only relate a CI to a Service Contract. With that being the case, I don't think GRLoader is going to be able to help you.
It may be possible to build a pdm_load file against the sdsc_map table (where the connection between the CIs and the contracts are stored), but I'd of course recommend a backup and a lot of testing prior. If the data load is built incorrectly you may run into issues.
CA SDM: GRLoader - Everthing you need to know - Loading Configuration Item
SUPER GRLOADER (z_loader_sdm_v103_en.zip) by daniel-bighelini