3.1.4.2.2.1 Discover

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.