BBC.SHARED.VARA.LIST-AGENTS@SEC_SQLI

Summary

Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
Title
Returns a list of all agents
Archive Key 1
-
Archive Key 2
-
Created
Andreas Büsching am: 2021-01-27 08:20:10
Last Modified
Andreas Büsching am: 2021-02-02 17:10:07 13 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 JOIN HACL ON OH_Idnr = HACL_OH_Idnr WHERE OH_OType = ‘HOST’ AND HACL_Client = ? AND OH_DeleteFlag = 0 Statement (Oracle)
SELECT OH_Name AS “Agent”, HOST_HostAttrType AS “Platform” FROM OH JOIN HOST ON OH_Idnr = HOST_OH_Idnr JOIN HACL ON OH_Idnr = HACL_OH_Idnr WHERE OH_OType = ‘HOST’ AND HACL_Client = ? AND OH_DeleteFlag = 0 Result Format

Bind Parameters

Number Parameter
1 &$CLIENT#

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES