Additional ServiceNow Indexes for Performance
Creating additional indexes on your ServiceNow instance substantially improves the intake of data exported from FlexNet Manager Suite.
ServiceNow enables you to create your own database indexes. A worked example suggests that, with the following indexes added, you can expect better than four-fold performance increase in the initial data transforms to finish the import of data that has been exported from FlexNet Manager Suite.
| Database table | New column indexed |
|---|---|
Contract [ast_contract]
|
vendor_contract
|
Software Model [cmdb_software_product_model]
|
x_fls_flexera_fnms_id
|
Product Model [cmdb_model]
|
model_number
|
Computer [cmdb_ci_computer]
|
x_fls_flexera_fnms_computer_id
|
Software Installation [cmdb_sam_sw_install]
|
x_fls_flexera_fnms_application_id
|