The BSASeries table contains all series information related to configured profiles. Each profile has separate entries for the various profile/subject(DName)/expression combination.
Table 3-21 BSASeries Table
Name |
Type |
P |
M |
F |
Description |
---|---|---|---|---|---|
SeriesID |
$ID$ |
Y |
Y |
N |
A unique random number generated at performance series creation time. |
Subject |
$IDX_STRING$ |
N |
Y |
N |
The subject of the current profile record. This is usually the DName of the element for which performance data is collected. |
SubjectHash |
NUMBER |
N |
Y |
N |
A 32‑bit CRC hash of the Subject field; used for faster searches. |
Profile |
$IDX_STRING$ |
N |
Y |
N |
The performance series profile name. This name is assigned by the user at profile creation time. |
Expression |
$IDX_STRING$ |
N |
Y |
N |
The expression name associated with the current performance series. |
CollectionBegan |
$DATETIME$ |
N |
Y |
N |
Date and time when the profile began collecting data. |
Status |
CHAR(1) |
N |
Y |
N |
Performance series status. Current values include A=Active, D=Deleted. If the series record is in a deleted state, all data associated with the current series is purged from the database at the next scheduled purge cycle (configured by using the Customizer). |
DataType |
NUMBER |
N |
Y |
Y |
Foreign key reference to the BSADataTypes table. |
DaysToRetain |
INTEGER |
N |
N |
N |
Number of days to retain data for the current performance or alarm series. |
HostID |
$ID$ |
N |
N |
Y |
Foreign key reference to the BSAHosts table. |