Discovery > Discovery Modules > Database > Sybase Discovery > Sybase Topology by SQL job

Sybase Topology by SQL job

This section includes details about the job.

ClosedTrigger 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
ClosedAdapter

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