Created
March 7, 2017 12:55
-
-
Save Hugoberry/a5b48d0a8070f8d5ad76077c4634e48e to your computer and use it in GitHub Desktop.
Hidden Tabular SSAS specific DMVs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <Batch Transaction="false" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_MODEL</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_DATA_SOURCES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_TABLES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_COLUMNS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_ATTRIBUTE_HIERARCHIES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PARTITIONS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_RELATIONSHIPS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_MEASURES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_HIERARCHIES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_LEVELS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_ANNOTATIONS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_KPIS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_CULTURES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_OBJECT_TRANSLATIONS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_LINGUISTIC_METADATA</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PERSPECTIVES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PERSPECTIVE_TABLES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PERSPECTIVE_COLUMNS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PERSPECTIVE_HIERARCHIES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_PERSPECTIVE_MEASURES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_ROLES</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_ROLE_MEMBERSHIPS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_TABLE_PERMISSIONS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> | |
| <RequestType>TMSCHEMA_EXPRESSIONS</RequestType> | |
| <Restrictions> | |
| <RestrictionList> | |
| <DatabaseName>b7b2993d-570b-4c92-9e5d-d5e8f72c935d</DatabaseName> | |
| </RestrictionList> | |
| </Restrictions> | |
| <Properties> | |
| <PropertyList/> | |
| </Properties> | |
| </Discover> | |
| </Batch> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment