spotlight_perdata is the fact table into which all of the data is stored. Each fact is effectively matrixed by the hierarchy of attributes that denote which Spotlight Diagnostic Server, monitored object, collection and collection column the datum originally came from.
|
Column |
Description |
|---|---|
|
perfdata_id |
Generated ID. |
|
monitored_object_id |
The monitored object that this fact came from. |
|
statistic_class_id |
The collection that this fact came from. |
|
statistic_name_id |
The column in the collection that this fact came from. |
|
statistic_key_id |
The key column of the collection that this fact came from. |
|
timecollected |
The time this fact was collected from the monitored object. |
|
raw_value |
The raw value returned by the collection for that column. |
|
num_observations |
Internal use only. |
|
sum_of_values |
Internal use only. |
|
max_value |
Internal use only. |
|
min_value |
Internal use only. |
|
sum_of_squares |
Internal use only. |
| wide_string |
An alternative to raw_value that is used where the width of the data collected is too large for a variant data type. Either wide_string will contain a value or raw_value but never both. The using_wide_string column in the spotlight_stat_names table shows whether a statistic name is using the wide_string column or not. |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy
