Enterprise Asset Management normalization

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Enterprise Asset Management Normalization

    The Enterprise Asset Management (EAM) normalization process standardizes the manufacturer, model name, model number, and model type data of enterprise models. This is achieved by comparing discovered data against the ServiceNow repository of normalized equivalents within the EAM Content Service. Users can either manually update model records or utilize the normalization content for comparison.

    Show full answer Show less

    Key Features

    • Scheduled Jobs: Several scheduled jobs facilitate the normalization process, including:
      • EAM - Daily Job: Initializes data pulling from the EAM Content Service.
      • EAM - Content Upload: Daily uploads custom content to the EAM Content Service, contingent on opting in.
      • EAM - Enterprise Lifecycles: Updates model records with lifecycle changes.
      • EAM - Normalization: Normalizes models that remain unnormalized.
      • EAM - Apply latest content changes: Updates content tables in the EAM Content Service.
    • Normalization Tables: Various tables are installed with EAM normalization, including:
      • Custom Enterprise Model Type
      • Custom Enterprise Manufacturer
      • Custom Enterprise Product Model
      • Custom Enterprise Model Library
      • Enterprise Model Type
      • Enterprise Manufacturer
      • Enterprise Product Model
      • Enterprise Model Library
      • Enterprise Lifecycle Definition
      • EAM Content Audit
      • Manage Enterprise Library
      • Enterprise Asset Configurations

    Key Outcomes

    By utilizing the EAM normalization process, customers can ensure accurate and standardized asset data, facilitating better asset management and decision-making. Regular updates and normalization help maintain data integrity and compliance with lifecycle management practices.

    The Enterprise Asset Management normalization process enables you to normalize your manufacturer, model name, model number, and model type data of your enterprise models.

    Overview

    The normalization process compares the discovered manufacturer, discovered model, discovered model type, and the discovered model number values against the ServiceNow repository of normalized equivalents in the Enterprise Asset Management Content Service.

    To standardize your enterprise models, the data must be normalized. You can manually update the model records with the normalization content, or you can compare your data against the Enterprise Asset Management Content Service.

    Scheduled jobs for Normalization

    The following are the scheduled jobs that run during the normalization process.
    Scheduled job Description
    EAM - Daily Job

    Sets the time when data is pulled by the Enterprise Asset Management Content Service. This job runs only once, when the normalization process is started for the first time.

    If a model has gone beyond its end of its lifecycle date, this job enables the Content lifecycle phase check box in the Enterprise Model Lifecycle tab in a model record.
    EAM - Content Upload A daily job that uploads any content to the Enterprise Asset Management Content Service that you have added in the following custom tables:
    • Custom Enterprise Model Type [sn_eam_cd_custom_model_type]
    • Custom Enterprise Manufacturer [sn_eam_cd_custom_manufacturer
    • Custom Enterprise Product Model [sn_eam_cd_custom_product_model]
    • Custom Enterprise Model Library [sn_eam_cd_custom_model_library]
    Note:
    This job only runs if you have opted in to the Enterprise Asset Management Content Service.
    EAM - Enterprise Lifecycles Updates the model record with information about newly created or deleted life cycles.
    EAM - Normalization Normalizes all the models that haven't been normalized.
    EAM - Apply latest content changes Updates any changes in the content tables to the Enterprise Asset Management Content Service.

    Tables installed with Enterprise Asset Management normalization

    Several normalization tables are installed with the activation of the Enterprise Asset Management application.
    Table 1. Tables installed
    Table Description
    Custom Enterprise Model Type [sn_eam_cd_custom_model_type] Stores custom enterprise model type records.
    Custom Enterprise Manufacturer [sn_eam_cd_custom_manufacturer] Stores custom enterprise manufacturer records.
    Custom Enterprise Product Model [sn_eam_cd_custom_product_model] Stores custom enterprise product model records.
    Custom Enterprise Model Library [sn_eam_cd_custom_model_library] Stores enterprise model library records.
    Enterprise Model Type [sn_eam_cd_model_type] Stores enterprise model type records.
    Enterprise Manufacturer [sn_eam_cd_manufacturer] Stores enterprise model manufacturer records.
    Enterprise Product Model [sn_eam_cd_product_model] Stores enterprise product model records.
    Enterprise Model Library [sn_eam_cd_model_library] Stores enterprise model library records.
    Enterprise Lifecycle Definition [sn_eam_cd_lifecycle_definition] Stores lifecycle phase of an enterprise model and associated dates.
    EAM Content Audit [sn_eam_content_audit] Stores the content values that changed.
    Manage Enterprise Library [sn_eam_manage_cd_library] Stores import and export content data.
    Enterprise Asset Configurations [sn_eam_configuration] Stores opt-in and opt-out data.