TechNet
Export (0) Print
Expand All

syscollector_collector_types (Transact-SQL)

 

Updated: June 10, 2016

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 nameData typeDescription
collector_type_uiduniqueidentiferThe GUID for a collection type. Is not nullable.
namesysnameThe name of the collection type. Is not nullable.
parameter_schemaxmlThe 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_formatterxmlDetermines the template to use to transform the XML for use in the collection set property page. Is nullable.
collection_package_iduniqueidentiferThe GUID for a collection package. Is not nullable.
collection_package_pathnvarchar(4000)Provides the path to the collection package. Is nullable.
collection_package_namesysnameThe name of the collection package. Is not nullable.
upload_package_iduniqueidentiferThe GUID for the upload package. Is not nullable.
upload_package_pathnvarchar(4000)Provides the path to the upload package. Is nullable.
upload_package_namesysnameThe name of the upload package. Is not nullable.
is_systembitTurned 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.

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

Community Additions

ADD
Show:
© 2016 Microsoft