Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

spotlight_stat_names

spotlight_stat_names contains data about the columns belonging to collections. There is one row in this column for each column/table/data source combination.

Column Description

statistic_name_id

Generated ID.

statistic_class_id

The statistic_class (collection) this column belongs to.

datasource_id

The data source of the collection that this column belongs to.

statistic_name

The name of the column.

datatype_guide

This column provides a broad guide to the type of data that can be expected in facts for this named statistic. Values can be “string”, “numeric” or “date”.

derived

Whether this is a derived column or not.

using_wide_string Whether the value for this data source is stored in the wide_string column in the spotlight_perdata table or not. If not it is stored in the raw_value column.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating