Sybase Topology by SQL job
This section includes details about the job.
Trigger TQL
| Node Name | Condition |
|---|---|
| Node | None |
| IpAddress | NOT IP Probe Name Is null |
| Sybase | NOT Application Username Is null AND NOT Reference to the credentials dictionary entry Is null |
Adapter
This job uses the Sybase Topology by SQL adapter.
- Adapter Type
-
Jython
-
Input CIT
Sybase ACE
-
Input TQL
-
Triggered CI Data
Name Value credentialsId ${SOURCE.credentials_id} hostId ${HOST.root_id} ip_address ${SOURCE.application_ip} port ${SOURCE.application_port:NA} -
Used Scripts
sybase_dis_physical.py
-
Required Permissions
Permission Operation Usage Description Objects and Parameters SQL select Getting existing schema names master..spt_values
master..sysdatabases
master.dbo.sysusages
SQL select Getting opened db sessions info master..sysdatabases
master..syslogins
master..sysprocesses
SQL select Getting tablespaces info sybsystemprocs..sp_helpdevice SQL select sid information master..sysservers -
Discovered CITs
- Composition
- Containment
- DB Client
- DB Data File
- DB Tablespace
- DB User
- IpAddress
- Node
- Process
- Resource
-
SAP ASE Database
-
SAP ASE Server