Skip to main content

BBC.SHARED.VARA@SEC_SQLI.LIST-AGENTS

Details​

PropertyValue
TypeVARA
FolderPACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
TitleReturns a list of all agents
Archive Key 1-
Archive Key 2-
CreatedAndreas Büsching am: 2021-01-27 08:20:10
Last ModifiedTimon Schnakenberg am: 2024-10-15 11:42:55 22 x
Last Used-

SQL​

Statement (MS SQL)
SELECT OH_Name AS "Agent", HOST_HostAttrType AS "Platform", OHG_HostAttrType AS "Platform"FROM OHJOIN HOST ON OH_Idnr = HOST_OH_IdnrJOIN HACL ON OH_Idnr = HACL_OH_IdnrWHERE OH_OType = 'HOST'AND HACL_Client = ?AND OH_DeleteFlag = 0
Statement (Oracle)
SELECT OH_Name AS "Agent", HOST_HostAttrType AS "Platform", HOST_HostAttrType AS "Platform"FROM OHJOIN HOST ON OH_Idnr = HOST_OH_IdnrJOIN HACL ON OH_Idnr = HACL_OH_IdnrWHERE OH_OType = 'HOST'AND HACL_Client = ?AND OH_DeleteFlag = 0

Result Format :

Bind Parameters​

NumberParameter
1&$CLIENT#

Attributes​

Data & Formatting​

Data Type
TEXT
Force Upper Case
❌

Script Access​

If key not found
INITIAL_VALUES