$hist_service_n
The $hist_service_n table records the CLI usage from the localhost or remote client. It logs the command name and the timestamp of the command issue. This information is collected in the history when COLLECT SERVICE is enabled in the history configuration.
For more information, see the IBM® Netezza® Advanced Security Administrator's Guide.
Name | Type | Description |
---|---|---|
npsid | integer | This value along with the npsInstanceId and opid form the foreign key into the operation table. |
npsinstanceid | integer | Instance ID of the source system |
logentryid | bigint | This ID and the NPS ID (npsid) and instance ID (npsinstanceid)
form:
|
sessionid | bigint | Session ID. This ID is a foreign key into session_n and is generated by the source Netezza Performance Server system. This ID and the NPS ID (npsid) form the foreign key into session_n. |
servicetype | bigint | The code for the command, which is one of the following integer
values:
|
service | varchar(512) | The text string of the servicetype value |