Request new or enhanced Patterns on the ServiceNow® Store

Visit the ServiceNow Store to view all the available updates and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

To learn about the SAP components and their versions that you can discover, refer to Detailed information on products discovered by ITOM Visibility.

Prerequisites

Verify that the applications are up to date

Discovery and Service Mapping Patterns

Visibility Content

CMDB CI Class Models

Verify the configuration of the credentials

• (If hosted on a UNIX server) On the ServiceNow AI Platform, configure applicative credentials and SSH credentials. The SSH credentials are used to create connections from SAP Central Instance (CI) to other applications and devices. In addition, provide the user elevated rights to be able to run commands requiring a privileged user: Service Mapping commands requiring a privileged user.
• (If hosted on a Windows server) On the ServiceNow AI Platform, configure Windows credentials to create connections from SAP CI to other applications and devices.
• (Optional) For discovering using the WinRM protocol, see Configure WinRM trusted hosts on MID Server.
• (Optional for top-down discovery by Service Mapping) Provide a user with permissions to run SOAP on RFC read table function.
• (Optional for top-down discovery by Service Mapping) If your organization deploys SAP Digital Business Services using web services and you want to map all connected services, perform the following actions:
  • Configure applicative credentials for a user with permissions to access the following tables: CVERS, DBCONS, and RFCDES.
  • Ensure that you have the web service URL. For information on how to create web services, see https://blogs.sap.com/2012/10/24/how-to-create-web-services-abap-based/.

SAP HANA 2.0 DB Catalog on UNIX

Verify that the Applicative Credentials for SAP HANA DB App Creds are configured with SAP Hana Db [cmdb_ci_appl_sap_hana_db] as CI type.

Verify the permissions to run Service Mapping commands

Service Mapping commands not requiring a privileged user

Verify the user has the permissions to run the Patterns queries

The following commands are executed when running the SAP HANA DB and SAP HANA DB Catalog Patterns.

• select * from schemas;
• select * from M_HOST_INFORMATION where upper(KEY) like '%TIMEZONE%';
• select SCHEMA_NAME, round(sum(TABLE_SIZE) /1024/1024) from M_TABLES GROUP BY SCHEMA_NAME

The query type	Fallback commands executed in order
Schemas Info	$hdbsql_path + " -n " + $entry_point.ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from schemas;\"" $hdbsql_path + " -n " + $ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from schemas;\"" $hdbsql_path + " -n " + $server_name + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from schemas;\"" $hdbsql_path + " -n localhost -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from schemas;\""
Time Zone:	$hdbsql_path + " -n " + $entry_point.ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from M_HOST_INFORMATION where upper(KEY) like '%TIMEZONE%';\"" $hdbsql_path + " -n " + $ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from M_HOST_INFORMATION where upper(KEY) like '%TIMEZONE%';\"" $hdbsql_path + " -n " + $server_name + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from M_HOST_INFORMATION where upper(KEY) like '%TIMEZONE%';\"" $hdbsql_path + " -n localhost -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select * from M_HOST_INFORMATION where upper(KEY) like '%TIMEZONE%';\""
Disk Size	$hdbsql_path + " -n " + $entry_point.ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select SCHEMA_NAME, round(sum(TABLE_SIZE) /1024/1024) from M_TABLES GROUP BY SCHEMA_NAME;\"" $hdbsql_path + " -n " + $ip_address + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select SCHEMA_NAME, round(sum(TABLE_SIZE) /1024/1024) from M_TABLES GROUP BY SCHEMA_NAME;\"" $hdbsql_path + " -n " + $server_name + ":" + $query_port + " -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select SCHEMA_NAME, round(sum(TABLE_SIZE) /1024/1024) from M_TABLES GROUP BY SCHEMA_NAME;\"" $hdbsql_path + " -n localhost -i " + $digits + " -u '$$username$$' -p '$$password$$' \"select SCHEMA_NAME, round(sum(TABLE_SIZE) /1024/1024) from M_TABLES GROUP BY SCHEMA_NAME;\""

Verify the configuration of the Discovery schedule

For more information, see Running discoveries in your network

Data collected by Discovery during horizontal discovery

Data collected by the SAP HANA DB Catalog on UNIX pattern during horizontal discovery

CI Relationships

SAP HANA DB Catalog on UNIX CI relationships

CI	Relationship	CI
SAP HANA DB [cmdb_ci_appl_sap_hana_db]	Contains::Contained by	SAP HANA DB Catalog [cmdb_ci_db_hana_catalog]

Limitations

Service Mapping can map only one instance of ASCS per deployment.

The SAP HANA DB Catalog pattern can only run on UNIX.