Components installed with Application Insights

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Several types of components are installed with the installation of the Application Insights application, including tables and user roles.

    Note:
    The Application Files table lists the components that are installed with this application. For instructions on how to access this table, see Find components installed with an application.

    Roles installed

    Role title [name] Description Contains roles
    Application Insights administrator

    [sn_app_insights.admin]
    Users of the Application Insights application cannot:
    • Apply filters on graphs for events or transactions.
    • View syslog_transaction and sysauto records.
    • Create alerts.

    None

    Tables installed

    Table Description
    Application Insights Aggregates

    [sn_app_insights_aggregates]

    		 Temporarily stores aggregates for average, median, and 95th percentile of various statistics such as events processed and transactions.
    Application Insights ECC Queue Aggregates

    [sn_app_insights_ecc_queue]

    		 Temporarily stores ECC queue aggregates for average, median, and 95th percentile of various ECC-related statistics such as inbound and outbound processing.
    Metric Trigger

    [sn_app_insights_metric_trigger]

    		 Log of triggered metric threshold events.
    Metric trigger log

    [sn_app_insights_metric_trigger_log]

    		 Log of metric trigger events.
    P1 Predict

    [sn_app_insights_p1_predict]

    		 Stores the prediction model values to determine if a system is about to experience a P1 event.
    Slow Patterns To Scripts Mapping

    [sn_app_insights_slow_patterns_to_scripts_mapping]

    		 Stores mapping of slow patterns to scripts.
    Script Referenced Slow Pattern

    [sn_app_insights_st_slow_pattern_referenced_script]

    		 Temporarily holds the count of scripts referenced from the source of a slow pattern.
    Slow patterns metrics

    [sn_app_insights_st_slow_patterns]

    		 Temporarily stores metrics of slow patterns such as execution counts and times.
    Slow Patterns To Scripts Mapping ST

    [sn_app_insights_st_slow_patterns_to_scripts_mapping]

    		 Temporarily stores additional calculated relationship mapping of slow patterns to scripts with execution count and time.
    Scheduled Jobs

    [sn_app_insights_st_sysauto]

    		 Temporarily stores metrics of scheduled jobs including processing duration, error, and run counts.
    Conditional threshold

    [sn_app_insights_trigger_condition]

    		 Stores the configuration of metric thresholds, which are a logical combination of the individual triggers in the sn_app_insights_metric_trigger table.