BBC.SHARED.VARA@SEC_SQLI.LIST-ALL-OS-AGENTS
Details
| Property | Value |
|---|---|
| Type | VARA |
| Folder | PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING |
| Title | Returns a list of all operating system agents |
| Archive Key 1 | - |
| Archive Key 2 | - |
| Created | Andreas Büsching am: 2022-05-25 12:39:46 |
| Last Modified | WRITER/B4A am: 2022-06-13 18:34:21 2 x |
| Last Used | - |
SQL
- Statement (MS SQL)
- SELECT OH_Name AS "Agent", HOST_HostAttrType AS "Platform"FROM OHJOIN HOST ON OH_Idnr = HOST_OH_IdnrWHERE OH_OType = 'HOST'AND OH_DeleteFlag = 0AND HOST_HostAttrType in ( 'WINDOWS', 'UNIX', 'BS2000', 'OS400', 'OS390' )AND HOST_Active = 1
- Statement (Oracle)
- SELECT OH_Name AS "Agent", HOST_HostAttrType AS "Platform"FROM OHJOIN HOST ON OH_Idnr = HOST_OH_IdnrWHERE OH_OType = 'HOST'AND OH_DeleteFlag = 0AND 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