syscollector_collector_types (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Permissions

Requires SELECT for dc_operator, dc_proxy.

Change History

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.

See Also

Data Collector Stored Procedures (Transact-SQL)
Data Collector Views (Transact-SQL)
Data Collection