Partager via

3.1.4.2.2.1 Discover

  • Article

The Discover message is used to request information from the server.

The server MUST support each of the enumerated RequestTypes.

The schema rowset has the following definition.

   <xsd:element name="Discover">
     <xsd:complexType>
       <xsd:sequence>
         <xsd:element name="RequestType" minOccurs="1" maxOccurs="1" >
           <xsd:simpleType>
             <xsd:restriction base="xsd:string" >
               <xsd:enumeration value="DBSCHEMA_CATALOGS" />
               <xsd:enumeration value="MDSCHEMA_CUBES" />
               <xsd:enumeration value="MDSCHEMA_DIMENSIONS" />
               <xsd:enumeration value="MDSCHEMA_HIERARCHIES" />
               <xsd:enumeration value="MDSCHEMA_LEVELS" />
               <xsd:enumeration value="MDSCHEMA_MEASURES" />
               <xsd:enumeration value="MDSCHEMA_PROPERTIES" />
               <xsd:enumeration value="MDSCHEMA_MEMBERS" />
               <xsd:enumeration value="MDSCHEMA_ACTIONS" />
               <xsd:enumeration value="MDSCHEMA_SETS" />
               <xsd:enumeration value="DISCOVER_INSTANCES" />
               <xsd:enumeration value="MDSCHEMA_KPIS" />
               <xsd:enumeration value="MDSCHEMA_MEASUREGROUPS" />
               <xsd:enumeration value="MDSCHEMA_MEASUREGROUP_DIMENSIONS" />
               <xsd:enumeration value="DISCOVER_PROPERTIES" />
               <xsd:enumeration value="DISCOVER_LITERALS" />
               <xsd:enumeration value="DISCOVER_SCHEMA_ROWSETS" />
               <xsd:enumeration value="DISCOVER_KEYWORDS" />
               <xsd:enumeration value="DBSCHEMA_TABLES" />
               <xsd:enumeration value="DBSCHEMA_COLUMNS" />
               <xsd:enumeration value="DBSCHEMA_PROVIDER_TYPES" />
               <xsd:enumeration value="MDSCHEMA_INPUT_DATASOURCES" />
               <xsd:enumeration value="DMSCHEMA_MINING_SERVICES" />
               <xsd:enumeration value="DMSCHEMA_MINING_SERVICE_PARAMETERS" />
               <xsd:enumeration value="DMSCHEMA_MINING_FUNCTIONS" />
               <xsd:enumeration value="DMSCHEMA_MINING_MODEL_CONTENT" />
               <xsd:enumeration value="DMSCHEMA_MINING_MODEL_XML" />
               <xsd:enumeration value="DMSCHEMA_MINING_MODEL_CONTENT_PMML" />
               <xsd:enumeration value="DMSCHEMA_MINING_MODELS" />
               <xsd:enumeration value="DMSCHEMA_MINING_COLUMNS" />
               <xsd:enumeration value="DMSCHEMA_MINING_STRUCTURES" />
               <xsd:enumeration value="DMSCHEMA_MINING_STRUCTURE_COLUMNS" />
               <xsd:enumeration value="DISCOVER_DATASOURCES" />
               <xsd:enumeration value="DISCOVER_ENUMERATORS" />
               <xsd:enumeration value="DISCOVER_XML_METADATA" />
               <xsd:enumeration value="DISCOVER_TRACES" />
               <xsd:enumeration value="DISCOVER_TRACE_DEFINITION_PROVIDERINFO" />
               <xsd:enumeration value="DISCOVER_TRACE_COLUMNS" />
               <xsd:enumeration value="DISCOVER_TRACE_EVENT_CATEGORIES" />
               <xsd:enumeration value="DISCOVER_MEMORYUSAGE" />
               <xsd:enumeration value="DISCOVER_MEMORYGRANT" />
               <xsd:enumeration value="DISCOVER_LOCKS" />
               <xsd:enumeration value="DISCOVER_CONNECTIONS" />
               <xsd:enumeration value="DISCOVER_SESSIONS" />
               <xsd:enumeration value="DISCOVER_JOBS" />
               <xsd:enumeration value="DISCOVER_TRANSACTIONS" />
               <xsd:enumeration value="DISCOVER_DB_CONNECTIONS" />
               <xsd:enumeration value="DISCOVER_MASTER_KEY" />
               <xsd:enumeration value="DISCOVER_PERFORMANCE_COUNTERS" />
               <xsd:enumeration value="DISCOVER_LOCATIONS" />
               <xsd:enumeration value="DISCOVER_PARTITION_DIMENSION_STAT" />
               <xsd:enumeration value="DISCOVER_PARTITION_STAT" />
               <xsd:enumeration value="DISCOVER_DIMENSION_STAT" />
               <xsd:enumeration value="DISCOVER_COMMANDS" />
               <xsd:enumeration value="DISCOVER_COMMAND_OBJECTS" />
               <xsd:enumeration value="DISCOVER_OBJECT_ACTIVITY" />
               <xsd:enumeration value="DISCOVER_OBJECT_MEMORY_USAGE" />
               <xsd:enumeration value="DISCOVER_STORAGE_TABLES" />
               <xsd:enumeration value="DISCOVER_STORAGE_TABLE_COLUMNS" />
               <xsd:enumeration value="DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS" />
               <xsd:enumeration value="DISCOVER_CSDL_METADATA" />
               <xsd:enumeration value="DISCOVER_CALC_DEPENDENCY" />
               <xsd:enumeration value="MDSCHEMA_FUNCTIONS" />
               <xsd:enumeration value="DISCOVER_RING_BUFFERS" />
               <xsd:enumeration value="DISCOVER_XEVENT_TRACE_DEFINITION" />
               <xsd:enumeration value="DISCOVER_XEVENT_PACKAGES" />
               <xsd:enumeration value="DISCOVER_XEVENT_OBJECTS" />
               <xsd:enumeration value="DISCOVER_XEVENT_OBJECT_COLUMNS" />
               <xsd:enumeration value="DISCOVER_XEVENT_SESSIONS" />
               <xsd:enumeration value="DISCOVER_XEVENT_SESSION_TARGETS" />
               <xsd:enumeration value="DISCOVER_MEM_STATS" />
               <xsd:enumeration value="DISCOVER_DB_MEM_STATS" />
               <xsd:enumeration value="DISCOVER_OBJECT_COUNTERS" />
             </xsd:restriction>
           </xsd:simpleType>
         </xsd:element>
         <xsd:element name="Restrictions" minOccurs="1" maxOccurs="1">
           <xsd:complexType>
             <xsd:sequence>
               <xsd:element name="RestrictionList" minOccurs="0" maxOccurs="1" 
                            nillable="true" >
                 <xsd:complexType>
                   <xsd:sequence>
                     <xsd:any minOccurs="0" maxOccurs="unbounded" />
                   </xsd:sequence>
                 </xsd:complexType>
               </xsd:element>
             </xsd:sequence>
           </xsd:complexType>
         </xsd:element>
         <xsd:element name="Properties" type="Properties" />
       </xsd:sequence>
     </xsd:complexType>
   </xsd:element>

In addition to the RequestTypes defined in the enumeration above, the [MS-SSAS-T] specification extends the set of RequestTypes to support Discover operations on databases in Tabular mode that have a compatibility level greater than or equal to 1200.

Element

Read-Only

Default value

Description

RequestType

[Required]

This enumeration value specifies which of the schema rowsets is being requested.

Restrictions

Empty

This element contains a single RestrictionList element, in which the restrictions on the number of rows to be returned are specified.

Properties

Empty

The Properties type is common to the Discover and Execute methods. It is described in section 3.1.4.2.2.1.2.