Export (0) Print
Expand All

syscollector_collector_types (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Provides information about a collector type for a collection item.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

collector_type_uid

uniqueidentifer

The GUID for a collection type. Is not nullable.

name

sysname

The name of the collection type. Is not nullable.

parameter_schema

xml

The XML schema that describes what the configuration for the specified collector type looks like. This XML schema is used to validate the actual XML configuration associated with a particular collection item instance. Is nullable.

parameter_formatter

xml

Determines the template to use to transform the XML for use in the collection set property page. Is nullable.

collection_package_id

uniqueidentifer

The GUID for a collection package. Is not nullable.

collection_package_path

nvarchar(4000)

Provides the path to the collection package. Is nullable.

collection_package_name

sysname

The name of the collection package. Is not nullable.

upload_package_id

uniqueidentifer

The GUID for the upload package. Is not nullable.

upload_package_path

nvarchar(4000)

Provides the path to the upload package. Is nullable.

upload_package_name

sysname

The name of the upload package. Is not nullable.

is_system

bit

Turned on (1) or off (0) to indicate if the collector type was shipped with the data collector or if it was added later by the dc_admin. This could be a custom type developed in-house or by a third party. Is not nullable.

Requires SELECT for dc_operator, dc_proxy.

Updated content

Updated collection_type_uid column name to collector_type_uid.

Corrected the description for the parameter_schema column to indicate that the value is nullable.

Added the parameter_formatter column.

Corrected the data type for the collection_package_path column, and updated the description to indicate that the value is nullable.

Corrected the data type for the upload_package_path column, and updated the description to indicate that the value is nullable.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft