Name

sn_cmdb_ws.CMDBWsConstants

Description

No description available

Script

var CMDBWsConstants = Class.create();
CMDBWsConstants.prototype = {
  initialize: function() {},

  DATATYPE: {
      BOOLEAN: "boolean",
      NUMBER: "number",
      STRING: "string"
  },

  ROLES: {
      ADMIN: "admin",
      MAINT: "maint",
      SN_CMDB_ADMIN: "sn_cmdb_admin",
      SN_CMDB_EDITOR: "sn_cmdb_editor",
      SN_CMDB_USER: "sn_cmdb_user",
      ASSET: "asset"
  },

  TABLES: {
      //cmdb_ci tables
      CMDB_CI: 'cmdb_ci',
      CMDB_REL_CI: 'cmdb_rel_ci',
      CMDB_GROUP: 'cmdb_group',
      CMDB_GROUP_CONTAINS_ENCODED_QUERY: "cmdb_group_contains_encoded_query",
      CMDB_CI_LOGICAL_DATACENTER: 'cmdb_ci_logical_datacenter',
      CLOUD_SERVICE_ACCOUNT: 'cmdb_ci_cloud_service_account',

      // cmdb workspace tables
      SN_CMDB_WS_GROUP_QUERY_METADATA: 'sn_cmdb_ws_group_query_metadata',
      SN_CMDB_WS_GROUP_METADATA: "sn_cmdb_ws_group_metadata",
      SN_CMDB_WS_DATACENTER_TYPE: 'sn_cmdb_ws_datacenter_type',
      SN_CMDB_WS_QUERY_CATEGORY: 'sn_cmdb_ws_insight_query_category', //internally referred as mapping table
      SN_CMDB_WS_INSIGHT_DATA: 'sn_cmdb_ws_insight_data', // old table used to store aggregate data for insights (will be deprecated in future)
      SN_CMDB_WS_PRODUCT_INSIGHT_DATA: 'sn_cmdb_ws_product_insight_data', // new table for storing aggregate data for insights(extends from base aggregate data table)
      SN_CMDB_WS_ATTESTATION_TASK_TO_CI: "sn_cmdb_ws_attestation_task_to_ci",
      SN_CMDB_WS_IMP_ACTION_CARD_CONFIG: "sn_cmdb_ws_imp_action_card_config",
      SN_CMDB_WS_FEATURE_CATEGORY: "sn_cmdb_ws_feature_category",
      SN_CMDB_WS_RATING_CONFIG: "sn_cmdb_ws_rating_config",
      SN_CMDB_WS_SERVICENOW_DISCOVERY_SOURCE: "sn_cmdb_ws_servicenow_discovery_source",
      SN_CMDB_WS_BASE_AGGREGATE_DATA: 'sn_cmdb_ws_base_aggregate_data',
      SN_CMDB_WS_SERVICE_GRAPH_CONNECTOR: 'sn_cmdb_ws_service_graph_connector',

      //qb tables
      QB_SAVED_QUERY: 'qb_saved_query',
      QB_QUERY_STATUS: 'qb_query_status',
      SYSAUTO_QUERY_BUILDER: 'sysauto_query_builder',

      // sys tables
      SYS_CHOICE: 'sys_choice',
      SYSAUTO: 'sysauto',
      SYSAUTO_PA: 'sysauto_pa',
      SYSAUTO_SCRIPT: 'sysauto_script',
      M2M_ACTION_ASSIGNMENT_ACTION_CONFIG: "sys_ux_m2m_action_assignment_action_config",
      SYS_OBJECT_SOURCE: 'sys_object_source',
      PA_JOB_LOGS: 'pa_job_logs',

      // data manager tables
      CMDB_DATA_MANAGER_POLICY_AND_ATTRIBUTES: 'cmdb_data_manager_policy_and_attributes',
      CMDB_DATA_MANAGEMENT_POLICY_EXECUTION: 'cmdb_data_management_policy_execution',

      // IH-ETL tables
      CMDB_INST_APPLICATION: 'cmdb_inst_application',

      // NLQ
      NLQ_QUERY_LOG: 'nlq_query_log',

      //svc_ci_assoc
      SVC_CI_ASSOC: 'svc_ci_assoc',

      // CMDB Health tables
      CMDB_HEALTH_RESULT: 'cmdb_health_result',
      CMDB_DUPLICATE_AUDIT_RESULT: 'cmdb_duplicate_audit_result',

      //PA tables
      PA_SCORES_L1: 'pa_scores_l1',
      PA_INDICATORS: 'pa_indicators'
  },

  PERSONAS: {
      CMDB_ADMIN: 'cmdb_admin',
      CMDB_EDITOR: 'cmdb_editor'
  },

  COLS: {
      SYS_ID: 'sys_id',
      ID: 'id',
      TYPE: 'type',
      CI_CATEGORY: 'ci_category',
      CI_CLASS: 'ci_class',
      CLOUD_PROVIDER: 'cloud_provider',
      COUNT: 'count',
      STATE: 'state',
      LAST_REFRESHED: 'last_refreshed',
      DATACENTER_CLASS: 'datacenter_class',
      FAILURE_COUNT: 'failure_count',
      ACTIVE: 'active',
      DOT: ".",
      DISCOVERY_SOURCE: 'discovery_source',
      TARGET_SYS_ID: 'target_sys_id',
      TARGET_TABLE: 'target_table',
      SOURCE_FEED: 'source_feed',
      IN: 'IN',
      SYS_CREATED_ON: 'sys_created_on',
      SYS_UPDATED_ON: 'sys_updated_on',

      //CI table columns
      SYS_CLASS_NAME: 'sys_class_name',

      //qb table columns
      QUERY: 'query',
      RESULT_TABLE: 'result_table',
      STATUS: 'status',
      TABLE_NAME: 'table_name',
      UPDATED: 'sys_updated_on',
      SOURCE: 'source',
      REPORT_SOURCE: 'report_source',

      // sys table columns
      NAME: 'name',
      ELEMENT: 'element',
      VALUE: 'value',

      GROUP_TYPE: 'group_type',
      CLASS: 'class',
      CONDITION: 'condition',
      SIMPLE_CONDITION: 'simple_condition',
      CI_COUNT: 'ci_count',
      ENCODED_QUERY: 'encoded_query',
      GROUP: 'group',

      //product config table columns
      RATING: 'rating',
      START: 'start',
      END: 'end',

      //feature category table
      MARKETING_COPY: 'marketing_copy',
      FEATURE: 'feature',
      CATEGORY: 'category',
      SUB_CATEGORY: 'sub_category',
      TITLE: 'title',

      ATTESTATION_STATUS: 'attestation_status',

      // base aggregate table columns
      CHART: 'chart',
      GROUP_BY: 'group_by',

      // cmdb data management policy execution
      EXECUTION_SUMMARY: 'execution_summary',
      END_TIME: 'end_time',

      // service graph connector
      APPLICATION_ID: 'app_id',
      SCOPE: 'scope',
      COMPANY: 'company',

      // PA job logs
      COMPLETED: 'completed',
      JOB: 'job',
  	
  	// Feature category runtime attributes
  	FEATURE_CATEGORY: 'feature_category',
  	QUERY_ALL_DATA: 'query_all_data',
  	LAST_RUN_TIME: 'last_run_time',

      // CMDB related entry
      REFERENCED_FIELD: 'referenced_field',

      // Sys Data source
      USE_BATCH_IMPORT: 'use_batch_import',

      // Scheduled import set
      DATA_SOURCE: 'data_source',
      CONCURRENT_IMPORT: 'concurrent_import',
      PARTITION_METHOD: 'partition_method',

      // CMDB Inst App Feed
      SYS_DATA_SOURCE: 'sys_data_source',

      // CMDB Integration Executions fields
      APPLICATION: 'application',

      //PA table columns
      INDICATOR: 'indicator',
      START_AT: 'start_at'
  },

  BOOLEAN: {
      TRUE: 'true',
      FALSE: 'false'
  },

  OPERATORS: {
      ISEMPTY: "ISEMPTY",
  	GREATER: '>',
      OR: "^OR",
      AND: "^",
      NOTLIKE: "NOT LIKE",
      NOTEQUAL: "!=",
      EQUAL: '=',
      STARTSWITH: 'STARTSWITH',
      LESSTHAN: '<'
  },

  SCHEDULED_JOBS: {
      CMDB_WS_AGGREGATES_MONTHLY_PA_JOB: '9a8f494c77592110ee0d0cc2fa5a99f1', //aggregates monthly PA job
      CMDB_WS_AGGREGATES_DAILY_PA_JOB: '6949143cb7312110b87e80408e11a9b0', //aggregates daily PA job
      CMDB_WS_POPULATE_AGGREGATES_DAILY: '0dcd4f777397e010960c6039faf6a799',
      CMDB_WS_POPULATE_AGGREGATES_MONTHLY: '461ca87f77d52110ee0d0cc2fa5a99bf'
  },

  SYS_PROPERTIES_NAME: {
      MULTISRC_ENABLED: 'glide.identification_engine.multisource_enabled',
      CIS_MANAGED_BY_ME: 'sn_cmdb_ws.ci_overview.managed_by_me.enabled',
      ENABLE_TOTAL_CIS: 'sn_cmdb_ws.total_cis.enabled',
      SHOULD_USE_SIMPLE_CONDITION: 'sn_cmdb_ws.ci_overview.enable_simple_condition',
      APPSTORE_BASE_URL: 'sn_appclient.repository_base_url'
  },

  PLUGINS: {
      INTEGRATION_HUB_ETL: 'com.sn_int_studio',
      DATA_FOUNDATION_DASHBOARD: 'sn_getwell',
      CMDB_APPLICATION_FOR_API_AND_CLI: 'sn_service_graph',
      ITOM_DISCOVERY_LICENSE: 'com.snc.itom.discovery.license',
      ITOM_LICENSE: 'com.snc.itom.license'
  },

  LICENSE: {
      ITOM_DISCOVERY: 'com.snc.itom.discovery.license'
  },

  ATTESTATION_STATUS: {
      NOT_YET_REVIEWED: "Not Yet Reviewed",
      ATTESTED: "Attested",
      REJECTED: "Rejected",
  },

  CMDB_WORKSPACE_ACTION_CONFIG_ID: "aa116c28b7a11110b87e80408e11a928",
  WORKSPACE_PARAM: "workspace",
  COUNT_AGGREGATE: "count",
  COUNT_DISTINCT_AGGREGATE: 'COUNT(DISTINCT',
  QUERY_INSTANCEOF: 'INSTANCEOF',
  CMDB_WORKSPACE_DB_CATEGORY: 'cmdb_workspace',
  IH_ETL_DEMODATA_PREFIX: 'IH-ETL-DemoData',

  // CIs processed via IRE
  CI_DISCOVERY_SOURCE: 'ci_discovery_source',
  BATCH_DEFAULT_SIZE: 1000,
  CIS_PROCESSED_VIA_IRE_SIMPLE_CONDITION: '',

  DISCOVERY_TYPE: {
      SGC: "sg_connector",
      SN: "discovery",
      SGC_SN: "sgc_discovery",
      OTHER: "other"
  },

  SERVICENOW_DISCOVERY_SOURCE: {
      SERVICENOW: 'ServiceNow',
      SERVICEWATCH: 'ServiceWatch',
      ACC_VISIBILITY: 'ACC-Visibility',
      AGENT_CLIENT_COLLECTOR: 'AgentClientCollector',
      CREDENTIALLESS_DISCOVERY: 'CredentiallessDiscovery'
  },

  IF_USE_IRE_GROUPBY: {
      USING_IRE_TYPE: 'using_ire',
      NOT_USING_IRE_TYPE: 'not_using_ire',
  },

  SGC_GROUP_BY_VALUE: {
      SGC_TOTAL: 'total',
      SGC_INSTALLED: 'installed'
  },

  QUALIFIER: {
      SG: 'SG-',
      SGO: 'SGO'
  },

  DATAMANAGER_POLICIES: {
      DELETE: {
          SYS_ID: "562bec900731201017b703767cd300e7",
          GROUP_BY: "policy_type_delete"
      },
      ARCHIVE: {
          SYS_ID: "b82b20d00731201017b703767cd300e1",
          GROUP_BY: "policy_type_archive"
      },
      RETIRE: {
          SYS_ID: "66306fcb7352201026f6aa114df6a77c",
          GROUP_BY: "policy_type_retire"
      },
      ATTESTATION: {
          SYS_ID: "7b80ed7753823010ee0dddeeff7b1223",
          GROUP_BY: "policy_type_attestation"
      }
  },

  QUERY_BUILDER_SOURCE: 'QB',
  INTELLIGENT_SEARCH_SOURCE: 'CMDB_WS',
  SOURCE_TYPE: "source_type",
  CMDB_QB: "cmdb_qb",

  INSIGHT_PRODUCT_CATEGORIES: {
      DATA_INGESTION: "80fd4e6853012110b87eddeeff7b121b",
      DATA_GOVERNANCE: "2f3e06a853012110b87eddeeff7b122d",
      SEARCH_AND_ANALYTICS: "3e5e46a853012110b87eddeeff7b1258"
  },

  STATES: {
      DRAFT: 1,
      READY: 2,
      RETIRED: 3
  },

  CATEGORY: {
      CLOUD_AND_NONCLOUD_CIS: "b75a75f053812110b87eddeeff7b12bf",
      REJECTED_CIS: "fd0993f4ef1b2110785294c1ed97d7d5"
  },

  SUB_CATEGORY: {
      DATA_MANAGER: "864e06a853012110b87eddeeff7b1231",
      DATA_ATTESTATION: "205e06a853012110b87eddeeff7b1235",
      QUERY_BUILDER: "c0ce8aa853012110b87eddeeff7b1284",
      CIS_PROCESSED_VIA_IRE: '350ece6853012110b87eddeeff7b12e0',
      CIS_PROCESSED_VIA_IRE_BY_SOURCE: '651e82a853012110b87eddeeff7b1245',
      SERVICE_GRAPH_CONNECTOR: '58ed4e6853012110b87eddeeff7b1218',
      INTELLIGENT_SEARCH: "16cecaa853012110b87eddeeff7b1291"
  },

  CMDB_FEATURE_ADOPTION: 'cmdb_feature_adoption',

  EXEC_SUMM_CI_COUNT_PREFIX: "CI Count:",

  QB_REPORTS_GROUPBY: {
      TOTAL_QUERIES_EXECUTED: "total_queries_executed",
      TOTAL_QUERIES_EXECUTED_REPORTS: "total_queries_executed_with_reports",
      TOTAL_CI: 'total_ci',
      TOTAL_CI_REL: 'total_ci_rel'
  },

  HREF_FOR_ROUTE_TYPE: 'javascript:void(0);',
  LIST_ROUTE: 'list',
  LINK_TYPES: {
      ROUTE: 'route',
      EXTERNAL: 'external'
  },

  SCHEDULED_JOB_RUN_TYPE: {
      AGGREGATES_DAILY_JOB: 'aggregates_daily_job',
      AGGREGATES_MONTHLY_JOB: 'aggregates_monthly_job',
  },

  PA_JOB_LOGS_STATE: {
      COLLECTED_OK: 'collected_ok'
  },

  NLQ_GROUP_BY_VALUE: {
      NLQ_NO_OF_QUERIES: 'nlq_num_of_queries'
  },

  PA_INDICATORS: {
      QB_USAGE: {
          ID: '2ac2bd18eb51211094bbb5d5d8522839',
          BREAKDOWN: {
              TOTAL_QUERY: {
                  ID: 'cdc6f11ceb51211094bbb5d5d852283e'
              }
          }
      },
      DATA_MANAGER: {
          ID: '36a86199eb55211094bbb5d5d852281a'
      },
      DATA_ATTESTATION: {
          ID: '249b6d1deb55211094bbb5d5d852287c'
      },
      INTELLIGENT_SEARCH: {
          ID: '09b0a5c4eb11211094bbb5d5d8522863'
      }
  },

  PA_SCORES_LOOKBACK_LIMIT: 90,

  type: 'CMDBWsConstants'
};

Sys ID

f18f8ebeebbc611094bbb5d5d8522840

Offical Documentation

Official Docs: