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