Service Graph Connector For Microsoft Azure - Migrating to a new hardware type modelOverview Hardware types are configuration items (CI)s that represent pre-defined virtual machine types provided by cloud vendors. Cloud vendors provide several hundreds of out-of-box types. In most cases, customers are using the out-of-box types(Example- Basic_A0, Basic_A1, Standard_A1 in Azure). Old Hardware Type Model This model uses the class cmdb_ci_compute_template (label: Hardware Type). This class is a dependent class on cmdb_ci_logical_datacenter.The result of this modelling is that each out-of-box hardware type is modelled in the CMDB N times where N = number of service accounts * number of logical datacenters.Customers with hundreds of service accounts end up discovering millions of hardware type records in the CMDB. This slows down connector and other related flows that can cause performance issues.Hence, customers are puzzled by the fact that hundreds of hardware types present in the cloud (AZURE) result in millions of records being persisted in the CMDB. New Hardware Type Model This model reduces the number of hardware type records in the CMDB.Hardware types are populated in cmdb_ci_cloud_hardware_type (label: Cloud Hardware Type). This is an independent class. It will create one record for each hardware type irrespective of the Service account and Data center.This will reduce the millions of hardware type records to hundreds of records. Release This feature is available in the following release. Release Version - 1.3.0 (Service Graph Connector for Microsoft Azure) Solution To migrate to a new hardware type model, set the System Property "sn_itom_pattern.use a single hardware type for cloud data centers" to true. To do this, Navigate to Filter Navigator -> enter sys_properties.list -> Search for sn_itom_pattern.use a single hardware type for cloud data centers To Delete old model Hardware type records, import the update set in Global Scope and commit it. Once the update set has been committed, follow the steps below: Navigate from the Filter Navigator -> System Definition -> Scheduled Jobs -> Search for job Named "SG-Azure - Mark old hardware type records as Absent"Activate the Scheduled job by clicking on "Active" and then click on "Update"This Schedule Job will periodically update the old model(cmdb_ci_compute_template) CIs status as Absent. Table cleaner will clean the Absent records in cmdb_ci_compute_template table.This schedule Job deletes all the records from the cmdb_ci_compute_template table which populated by "SG-Azure", expect this step to take time(maybe days depending on Ci's in cmdb_ci_compute_template table). Once all the required records got deleted, modify "sn_sg_azure_integ.is_delta_sync_enabled" property to false, this is needed to fetch the complete azure data after the hardware type change. Once full load completes, switch back that property to ‘true’ to receive the incremental pulls. To do this, Navigate to Filter Navigator -> enter sys_properties.list -> Search for sn_sg_azure_integ.is_delta_sync_enabled Note: 1. If you haven't deleted old model hardware type records but migrated to a new model and run SGC Azure, you may observe both old and new model records and relations in CMDB. 2. You can adjust the repeat interval of job and can also create below system property value to optimize the performance. delete_old_hardware_type_batch_size - The number of records updated during each Job process. The default value is 10000 Note: 1. Changing the System property "sn_itom_pattern.use a single hardware type for cloud data centers" from true to false by flipping it is not supported.