What tables do I need to migrate a Cloud Resource Disco schedule across environments?

jdiegeliv · ‎09-15-2020

We have a series of schedules created via Cloud Management wizard. What tables do I need to export that schedule to another environment? Update sets didn't catch it all. I exported the discovery_accel_config and cmp_discovery_ldc_config and my schedule starts but just sits there.

Cloud Management -> Service Accounts -> Service Account -> Create Discovery Schedule

jdiegeliv · ‎09-24-2020

The tables were as follows:

discovery_schedule
cmdb_ci_azure_subscription
cmdb_ci_cloud_service_account
cmp_discovery_ldc_config
discovery_accel_config
discovery_credentials
cmdb_ci_azure_datacenter
cmdb_rel_ci

View solution in original post

sachin_namjoshi · ‎09-15-2020

You need to export and import XML from below records

discovery_schedule

discovery_range_item

discovery_schedule_range

Regards,

Sachin

jdiegeliv · ‎09-15-2020

Wouldn't those be different for Cloud Resource schedules though?

sachin_namjoshi · ‎09-15-2020

No, it will be same.

If you see OOB UI action "create discovery schedule", it creates records in same tables.

Regards,

Sachin

jdiegeliv · ‎09-15-2020

How does a Cloud Resource schedule know what Cloud Service Account it's running for ?