BBC.SHARED.VARA@SEC_SQLI.LIST-ALL-OS-AGENTS

Summary

Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
Title
Returns a list of all operating system agents
Archive Key 1
-
Archive Key 2
-
Created
WRITER/B4A am: 2022-06-30 13:11:43
Last Modified
WRITER/B4A am: 2024-01-09 09:57:41 9 x
Last Used
-

SQL

Statement (MS SQL)
SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform” FROM OH JOIN HOST ON OH_Idnr = HOST_OH_Idnr WHERE OH_OType = ‘HOST’ AND OH_DeleteFlag = 0 AND HOST_HostAttrType in ( ‘WINDOWS’, ‘UNIX’, ‘BS2000’, ‘OS400’, ‘OS390’ ) AND HOST_Active = 1
Statement (Oracle)
SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform” FROM OH JOIN HOST ON OH_Idnr = HOST_OH_Idnr WHERE OH_OType = ‘HOST’ AND OH_DeleteFlag = 0 AND HOST_HostAttrType in ( ‘WINDOWS’, ‘UNIX’, ‘BS2000’, ‘OS400’, ‘OS390’ ) AND HOST_Active = 1
Result Format

Bind Parameters

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES