Table of Contents

Class DataCollectorSchema.CollectionItem

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

syscollector_collection_items (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns information about an item in a collection set.


See dbo.syscollector_collection_items.

[Table(Database = "msdb", Schema = "dbo", Name = "syscollector_collection_items", IsView = true)]
public class DataCollectorSchema.CollectionItem
Inheritance
DataCollectorSchema.CollectionItem
Extension Methods

Properties

CollectionItemID

Identifies an item in the collection set. Is not nullable.

[Column("collection_item_id")]
[NotNull]
public int CollectionItemID { get; set; }

Property Value

int

CollectionSetID

Identifies the collection set. Is not nullable.

[Column("collection_set_id")]
[NotNull]
public int CollectionSetID { get; set; }

Property Value

int

CollectorTypeUID

The GUID used to identify the collector type. Is not nullable.

[Column("collector_type_uid")]
[NotNull]
public Guid CollectorTypeUID { get; set; }

Property Value

Guid

Frequency

The frequency that data is collected by a collection item. Is not nullable.

[Column("frequency")]
[NotNull]
public int Frequency { get; set; }

Property Value

int

Name

The name of the collection set. Is nullable.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Parameters

Describes the parameterization for the collector type associated with the collection item. The XML schema for this collection item is validated with the XML Schema (XSD) stored in the parameter_schema for a particular collector type. Is nullable. For more information, see syscollector_collector_types (Transact-SQL).

[Column("parameters")]
[NotNull]
public object Parameters { get; set; }

Property Value

object