$hist_nps_n
The $hist_nps_n table describes each source system for which history is captured in the target database. When a Netezza Performance Server system connects to a history database for the first time, a record is added to this table.
| Name | Type | Description |
|---|---|---|
| npsid | integer | A unique ID for the Netezza Performance Server system, and the primary key for this table (This value is generated as a sequence on the target database where this table is defined.) |
| uuid | char(36) | UUID of the Netezza Performance Server system, which is a unique ID (generated on the source Netezza Performance Server system) |
| serverhost | varchar(256) | Host name of the source Netezza Performance Server system |
| serverip | char(16) | IP address of the source Netezza Performance Server system |
| npsinstanceid | integer | Instance ID of the source Netezza Performance Server system when this record was inserted |