Scheduled jobs and tables installed with normalization of firmware models
Scheduled jobs that run during the normalization of firmware models embedded into Operational Technology (OT) assets and tables that store firmware normalization details are installed with the OT Asset Management application.
| Scheduled job | Description |
|---|---|
| Firmware Content Upload | - Uploads data from the firmware tables to the CDS Client Staging \[cds\_client\_staging\] table. - Skips the upload if Content Data Service \(CDS\) hasn’t pulled all data. - Uses the Firmware configuration \[sn\_itam\_firmware\_configuration\] table to identify the firmware tables from which the content should be pushed. - Skips the upload if normalization hasn't run after the latest pull. |
| Firmware Content File Manager | Triggers during on-premise content import and export actions. |
| Firmware – Daily Job | - Sets the time when the data is pulled by the Content Data Service \(CDS\). - Sets current life-cycle phase of model life cycles. |
| Firmware – Apply latest content changes | Processes changes in the content tables after content pull. |
| Firmware - Generate Lifecycles | Updates firmware model records with the recently updated content life-cycle details. This is a weekly job. |
| Firmware Normalization | Normalizes firmware models using the newly downloaded content. |
| Table | Description |
|---|---|
| Firmware model normalization [sn_itam_firmware_model_norm] | Stores the normalization rule and hash used to perform normalization of firmware models. |
| Firmware product [sn_itam_firmware_product] | Stores firmware product records. |
| Custom firmware product [sn_itam_cust_firmware_product] | Stores custom firmware product records. |
| Firmware product version [sn_itam_firmware_product_version] | Stores firmware product version records. |
| Custom firmware product version [sn_itam_cust_firmware_product_version] | Stores version records of custom firmware products. |
| Firmware publisher [sn_itam_firmware_publisher] | Stores firmware publisher records. |
| Custom firmware publisher [sn_itam_cust_firmware_publisher] | Stores custom firmware publisher records. |
| Firmware lifecycle definition [sn_itam_firmware_lifecycle_def] | Stores the life-cycle phase of firmware models. Also stores the start and end date of each life-cycle phase. |
| Firmware model lifecycle [sn_itam_firmware_model_lifecycle] | Stores life-cycle definitions of firmware models. |
| Firmware normalization map [sn_itam_firmware_norm_mapping] | Stores the hash values that are used to normalize discovered firmware models. |
| Firmware CPE mapping [sn_itam_firmware_cpe_mapping] | Stores details of mapping between firmware and CPE. |
| Custom firmware CPE mapping [sn_itam_cust_firmware_cpe_mapping] | Stores custom firmware and CPE mapping details. |
| Firmware content audit [sn_itam_firmware_content_audit] | Stores content values that changed. |
| Manage firmware library [sn_itam_firmware_manage_library] | Stores import and export content data. |
| Firmware configuration [sn_itam_firmware_configuration] | Stores opt-in and opt-out data. |
Parent Topic:Enterprise Asset Management reference
Related topics
Domain separation and Enterprise Asset Management
Components installed with Enterprise Asset Management
Asset fields for enterprise assets
Asset audit fields for enterprise assets
Enterprise model categories and corresponding classes
Mandatory fields in the bulk import spreadsheets
Normalization status for enterprise models
Model fields for Enterprise Asset Management
Contract fields for Enterprise Asset Management
Maintenance plan fields for Enterprise Asset Management
Maintenance schedule fields for Enterprise Asset Management
Work plan fields for Enterprise Asset Management
Work plan schedule fields for Enterprise Asset Management
Expense line fields for Enterprise Asset Management
Fields inherited from a parent asset group to a sub group