SAP Sybase ASE discovery

Discovery and Service Mapping uses the Sybase pattern to find SAP Sybase Adaptive Server Enterprise (ASE) databases and catalogs in your infrastructure. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

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.

Prerequisites

Verify that the applications are up to date.

Discovery and Service Mapping Patterns

CMDB CI Class Models

Visibility Content

For details on the product discovered see Detailed information on products discovered by ITOM Visibility

注:

Discovery finds Sybase Catalog that run on Linux only.

Verify the configuration of OS server credentials.

Verify the configuration of the Applicative Credentials

When configuring the Applicative Credentials, make sure you specify Sybase Instance [cmdb_ci_db_syb_instance] as the CI type.

For more information on Applicative Credentials, see Applicative credentials

Verify that the user have permission to run the following commands

Execute the isql command.

Have the Sybase environment run one of the commands:

• "echo -ne 'set nocount on select name from sysdatabases\ngo\n' | " + $isql_path + " -U $$username$$ -P '$$password$$' -S " + $instance + " -w 999 -b -y " + $process.environmentVariables.SYBASE.value
• "export SYBASE=" + $process.environmentVariables.SYBASE.value + " && . " + $process.environmentVariables.SYBASE.value + "/SYBASE.sh && echo -ne 'set nocount on select name from sysdatabases\ngo\n' | " + $isql_path + " -U $$username$$ -P '$$password$$' -S " + $instance + " -w 999 -b -y " + $process.environmentVariables.SYBASE.value

Verify the configuration of a Discovery schedule

For detailed information, see Running discoveries in your network

Data collected during Horizontal discovery

Discovery populates the following data in the CMDB when running the Sybase pattern.

Sybase instance [cmdb_ci_db_syb_instance]
Label	Field Name
Name	name
Version	version
Installation directory	install_directory
Instance name	Instance
Configuration file	config_file

Sybase Catalog [cmdb_ci_db_syb_catalog]
Label	Field Name
Name	name

CI relationships

These relationships are created to support the Sybase ASE discovery.

CI	Relationship	CI
[cmdb_ci_db_syb_instance]	Contains::Contained by	[cmdb_ci_db_syb_catalog]