Appendix: Certified Application Objects

This appendix describes the tables, endpoints, and roles that were created in ServiceNow as part of the "ScienceLogic SL1: CMDB & Incident Automation" application. This application is also known as the "Certified Application" or the "Scoped Application".

Roles

Two Roles were added with the ScienceLogic update set, Admin (x_sclo_scilogic.Admin) and User (x_sclo_scilogic.User). Both give access to SL1.

Role Inherited Roles Other Inherited Roles Role Definition

x_sclo_scilogic.Admin

Role for ScienceLogic Service Accounts.

itil

Can perform standard actions for an ITIL help desk technician. This is the default ''Technician'' role.

Can open, update, close incidents, problems, changes, config management items. By default, only users with the itil role can have tasks assigned to them

Dependency_view

A special role to be applied both on the $ngbsm UI page and on the BSMProcessor. This role is required to access the dependency views module. By default, ITIL includes this role to avoid regressions.

cmdb_query_builder Can access the CMDB Query Builder application to create, run, and save queries on the CMDB.
template_editor
view_changer Can switch active views.

app_service_user

Can view and retrieve information using API from application service maps (cmdb_ci_service_discovered).

certification Can work on Certification tasks.

import_transformer

Can manage Import Set Transform Maps and run transforms.

x_sclo_scilogic.User

General user account that allows read-only access to SL1.

Tables

Name

Label

Extends

Comments

x_sclo_scilogic_catalog_item_templates

Catalog item Templates

 

Templates use to fill out catalog items

x_sclo_scilogic_discovery_dependents

Discovery Dependent

 

Discovery Dependent Information

x_sclo_scilogic_event

Event

 

Event information

x_sclo_scilogic_catalog_event_severity

Event Severity Look Rules

Data Lookup Matcher Rules

Lookup table for event Severity

x_sclo_scilogic_organizations

Organizations

 

Table to track Organizations between different ScienceLogic platforms

x_sclo_scilogic_import_discovery_dependent

Import Discovery Dependent

Import Set Row

Import / staging events before transform to Discovery Dependent table

x_sclo_scilogic_discovery_sessions

Import Discovery Sessions

Import Set Row

Import / staging events before transform to Event and Incident

x_sclo_scilogic_incident

Import Incident

Import Set Row

Import / staging events before transform to Event and Incident

x_sclo_scilogic_catalog_event_severity

     

x_sclo_scilogic_import_installed_software

Import Installed Software

Import Set Row

Import / staging events before transform to Software Instance

x_sclo_scilogic_org_ven_mfg

Import ORG VEN MFG

Import Set Row

Import / staging events before transform to core_company

Table Columns (cmdb_ci)

Name

Label

Type

Comments

x_sclo_scilogic_id

SL1 ID

Integer

Unique ID

x_sclo_scilogic_region

SL1 Region

String

Unique String of SL1 Platform

x_sclo_scilogic_url

SL1 URL

URL

URL to SL1 Platform

x_sclo_scilogic_monitored

SL1 Monitored

True/False

Device currently synced with SL1 Platform

Table Columns (core_company)

Name

Label

Type

Comments

x_sclo_scilogic_id

SL1 ID

String

Unique ID

x_sclo_scilogic_region

SL1 Region

String

Unique String of SL1 Platform

x_sclo_scilogic_monitored

SL1 Monitored

True/False

Organization currently synced with SL1 Platform

Table Columns (cmdb_group)

Name

Label

Type

Comments

x_sclo_scilogic_id

SL1 ID

String

Unique ID

x_sclo_scilogic_region

SL1 Region

String

Unique String of SL1 Platform

Script Includes

Name

API Name

Comments

CatalogUtils

x_sclo_scilogic.CatalogUtils

Catalog Script include scripts

ChangeUtils

x_sclo_scilogic.ChangeUtils

 

DeviceUtils

x_sclo_scilogic.DeviceUtils

 

EventUtils

x_sclo_scilogic.EventUtils

 

GeneralUtils

x_sclo_scilogic.GeneralUtils

 

IntgSvcUtils

x_sclo_scilogic.IntgSvcUtils

 

Event Registry

Suffix

Event name

Table

device_maintenance

x_sclo_scilogic.device_maintenance

Change Request [change_request]

device_maintenance_skd

x_sclo_scilogic.device_maintenance_skd

Change Request [change_request]

remove_monitoring

x_sclo_scilogic.remove_monitoring

Configuration Item [cmdb_ci]

Scripted Actions

Name

Event name

Device Maintenance

x_sclo_scilogic.device_maintenance

Device Monitoring Catalog item

x_sclo_scilogic.device_monitoring

Device Removal Catalog item

x_sclo_scilogic.remove_monitoring

Device Schedule Maintenance

x_sclo_scilogic.device_maintenance_skd

Data Lookup Definitions

Name

Source Table

Matcher Table

Comments

Event Severity

Import Incident [x_sclo_scilogic_incident]

Event Severity Lookup Rules [x_sclo_scilogic_event_severity]

Lookup for ScienceLogic Severity to Impact and Urgency

System Properties

Suffix

Name

CatalogItemDiscovery

x_sclo_scilogic.CatalogItemDiscovery

CatalogItemRemove

x_sclo_scilogic.CatalogItemRemove

closeCode

x_sclo_scilogic.closeCode

Contact type

x_sclo_scilogic.Contact Type

discoverySource

x_sclo_scilogic.discoverySource

IdentificationEngineAPI

x_sclo_scilogic.IdentificationEngineAPI

IS_log_level

x_sclo_scilogic.IS_log_level

notResolved

x_sclo_scilogic.notResolved

SN_log_level

x_sclo_scilogic.SN_log_level

stateNew

x_sclo_scilogic.stateNew

StateResolved

x_sclo_scilogic.stateResolved

Catalog Item

Name

Comments

Device Discovery

Role for ScienceLogic Service Accounts.

Monitoring Removal

General user account that allows read only access to ScienceLogic Application.

Catalog UI Policies

Catalog item

Short description

Comments

Device Discovery

Catalog Template

Updates form based on Select template

Device Discovery

Create Virtual Device

Updates form based on Request type

Device Discovery

Create Virtual Device (Retired)

Device Discovery

Device Discovery

Updates form based on Request type

Device Discovery

Device Discovery (Retired)

Monitoring Removal

Hide Overview variables not required

Hide variables not required for the Monitoring Removal request

Device Discovery

Port Scan

Hide scan ports that are not default

Device Discovery

Port Scan (Retired)

Device Discovery

Region

Updates form based on Organization

Device Discovery

Region (Retired)

Monitoring Removal

Region via Organization

Updates form based on Organization

Device Discovery

Save as Template

Updates form based on Save as template

Variable Sets

Title

Internal name

Comments

Create_virtual_device

create_virtual_device

Discovery Overview

discovery_overview

Discovery Sesion - Basic Settings

discovery_sesion_basic_settings

Discovery Session - Detection and Scanning

discovery_session_detection_and_scanning

Discovery Session - IP & Credentials

discovery_session_ip_credentials

Monitoring Removal

monitoring _removal

Service Catalog item Template

service_catalog_item_template

Catalog Client Scripts

Name

Catalog item

Type

Comments

Hide Request Type Options

Monitoring Removal

onLoad

Shared variable hide options that don’t apply

Hide Request Type Options

Device Discovery

onLoad

Shared variable hide options that don’t apply

Region

Monitoring Removal

onChange

Update Region field based on Company Region

Region

Monitoring Removal

onChange

Update Region field based on Company Region

Workflows

Name

Table

Comments

SL1 Monitoring Removal

Requested Item [sc_req_item]

Workflow for Removal of devices from SL1 process

SL1 Discovery Session

Requested Item [sc_req_item]

Workflow for Discovery session process

Scripted REST Resources

Name

Comments

Business Services

/api/x_sclo_scilogic/v1/sciencelogic/business_service

GET

This GET api will pull all ScienceLogic monitored Configuration items specific to Business Services class from the CMDB.  It will be ordered via the sys_id field to ensure the same order every time.

Change Requests

/api/x_sclo_scilogic/v1/sciencelogic/change_requests

GET

This GET api will pull Active Change Requests or Change Tasks based on the record_type supplied that have ScienceLogic monitored CI attached.  It will be ordered via the sys_id field to ensure the same order every time.

Classification

/api/x_sclo_scilogic/v1/sciencelogic/classification

GET

This GET api will pull all required CMDB information to build JSON payloads.

CMDB Group

/api/x_sclo_scilogic/v1/sciencelogic/cmdb_group

POST

Use this API to create cmdb_groups & add a CI to them.

Companies

/api/x_sclo_scilogic/v1/sciencelogic/companies

GET

This GET api will pull all Active Companies that are ScienceLogic monitored.  It will be ordered via the sys_id field to ensure the same order every time.

Configuration Items

/api/x_sclo_scilogic/v1/sciencelogic/configuration_Items

GET

This GET api will pull all ScienceLogic monitored Configuration items from the CMDB.  It will be ordered via the sys_id field to ensure the same order every time.

Device IdentificationEngine

/api/x_sclo_scilogic/v1/sciencelogic/IdentificationEngine

POST

Use this API to create or update configuration items within the CMDB via ScienceLogic. 

Discovery Dependent

/api/x_sclo_scilogic/v1/sciencelogic/discovery_dependent

GET

 

File Systems

/api/x_sclo_scilogic/v1/sciencelogic/file_systems

GET

This GET api will pull all ScienceLogic monitored Configuration items specific to File systems class from the CMDB.  It will be ordered via the sys_id field to ensure the same order every time.

Import Set

/api/x_sclo_scilogic/v1/sciencelogic/import_set

POST

This POST API will post to the target import set table and create a record for each cmdb_ci.

Incidents

/api/x_sclo_scilogic/v1/sciencelogic/incidents

GET

This GET api will pull all incidents.  It will be ordered via the sys_id field to ensure the same order every time.

Installed Software

/api/x_sclo_scilogic/v1/sciencelogic/installed_software

GET

This GET api will pull all Servicenow Software packages and installed instances from the CMDB.  It will be ordered via the sys_id field to ensure the same order every time.

Manufacture and Model

/api/x_sclo_scilogic/v1/sciencelogic/ManufactureAndModel

POST

This POST API will pull all Manufacturers and Models.

Network Adapters

/api/x_sclo_scilogic/v1/sciencelogic/network_adapters

GET

This GET api will pull all ScienceLogic monitored Configuration items specific to Network Adapter class from the CMDB.  It will be ordered via the sys_id field to ensure the same order every time.

Service Request

/api/x_sclo_scilogic/v1/sciencelogic/service_request

GET

This GET api will pull all ServiceRequest items from the CMDB associated with Device Discovery Catalog item.  It will be ordered via the sys_id field to ensure the same order every time.

Transform Maps

Name

Source Table

Target Table

Comments

ScienceLogic Catalog Item Templates

Import Discovery Sessions []

Catalog item Templates []

 

ScienceLogic Change Request

Import Service Request []

Change Request []

 

ScienceLogic Discovery Dependent

Import Discovery Dependent

Discovery Dependent

Import / staging table for Catalog Dependents

ScienceLogic Event

Import Incident

Event
[x_sclo_scilogic_event]

Import / staging table for Events.

ScienceLogic Installed Software

Import Installed Software []

Software Instance

 

ScienceLogic Organization

Import ORG VEN MFG []

Company
[core_company]

Import / staging table for Organization

ScienceLogic Service Request

Import Service Request []

Request Item [sc_req_item]

Import / staging table for Request item

ScienceLogic Source Organization

Import ORG VEN MFG []

Organizations []