Just to sound a note of caution, removing CI records and using pdm_load for CMDB data is not usually recommended. It's always preferable to deactivate records. However, inactive records are still matched. If you want to clean up in bulk, my approach would be to use GRLoader, along these lines:
1. Back up the MDB database before running the update at the final step below.
2. Extract the UUID and reconciliation fields (name, serial number, asset tag, system name, DNS name and MAC address) for the CIs that you wish to deactivate, from ca_owned_resource, into a text file.
3. Create a spreadsheet from the text file, with the UUID column first, labelled 'id', and the other columns labelled with their correct field names (name, serial_number, asset_num, etc). Add column 'status' and set the whole column to the value for 'inactive'.
4. In the spreadsheet, change the name, serial number, asset tag, system name and DNS name to 'XXX' plus their original text if they are non-empty, and clear the MAC address.
5. Use GRLoader to import the spreadsheet, with 'update only' flagged, in 'simulate' mode. Review the output and adjust as needed.
6. When you are satisified with the output from the simulate, run GRLoader again in live mode. That should deactivate your original records and update their identifying fields so that they will not match any subsequent import.
Regards,
James
------------------------------
Consultant
IDC Technologies
------------------------------
Original Message:
Sent: 07-01-2020 09:47 AM
From: Jason Lara
Subject: Configuration Automation - SDM Integration
Hello Asim,
Thanks for your reply, i tried to do a pdm_load -r to those tables after a pdm_extract but it says that they were skipped because they read only tables.
Regards.
Original Message:
Sent: 07-01-2020 03:16 AM
From: asim Shah
Subject: Configuration Automation - SDM Integration
Hi Jason
Make sure you have deleted reference records from below table also and them try to import again
ca_logical_asset_***
ca_asset_**
Original Message:
Sent: 06-30-2020 04:11 PM
From: Jason Lara
Subject: Configuration Automation - SDM Integration
Hello,
I'm not really sure if this case goes to Service Desk or CCA. I have an integration between CCA 12.8 SP06 and 17.1 SDM.
I have a job to import servers from cca to CMDB of SDM. There was a lot of information on the CMDB that was manually loaded and we wanted to clean the CI's to import fresh data from CCA.
We did a pdm_extract data from ci_owned_resource and busmgt, then a pdm_load with -r. I made the import from CCA but it says that a lot of CI's are skipped as if they were still on the CMDB.
What could be wrong here?
Regards.