Display the application mapping for a database.
Service | app-mapping |
Permission | Object XML API |
Version | 4.6.4 or later |
Parameter | Definition |
|---|---|
HH$Id | The database ID |
HH$Name | The database name |
HH$Columns | Comma separated list of columns for output Valid values are: TERMINAL, HOST, IP, APPLICATION, MODULE, OSUSER, and USER. This parameter is optional and the default value is the list of all the valid value |
HH$Schema | If this parameter is present (value is ignored) then the SCHEMA column is added to the output |
HH$pageSize | Long The maximum number of results per call |
HH$pageNum | Long The number of the page to return. The default value is 0 |
Note
Specify the database ID or name and not both the fields.
The XML output of the column names is mapped.
Column name | XML output name |
TERMINAL | terminal |
HOST | soutceHost |
IP | sourceIP |
APPLICATION | execProgram |
MODULE | module |
OSUSER | osUser |
USER | execUser |
SCHEMA | scheams.name |
For example, to list the application mapping for a database name with all available columns, use:
https://127.0.0.1:8443/xmlapi.svc?service=app-mapping&HH$Name=SalesDB&HH$Schema