SQL queries used for the discovery of Sybase Adaptive Server Enterprise (ASE)

Last published : Jun 19, 2026
The InfoScale Operations Manager agentlet uses the following SQL queries to discover Sybase Adaptive Server Enterprise (ASE):
  • sp_helpdb
  • sp_helpdevice
  • sp_helpsegment
  • select @@pagesize
  • use <database_name>
  • sp_helpdb <database_name>
  • select count(*) from sysobjects where type = 'U' or type = 'S'
  • select name from syssegments
  • sp_helpsegment <segment_name>
More Information
Application setup requirements for Sybase Adaptive Server Enterprise (ASE) discovery