Meta Query
The 
Meta Query application tab in MetaMiner Client is the most powerful tool for direct access to your MetaMiner Database (MMDB).
With this tool, you can answer merely any question and mine any data by running existing SQL scripts (queries) to MMDB or by writing your own scripts:
What is it? |
Meta Query is an embedded SQL workbench similar to existing SQL query tools that connects directly to the MetaMiner Database for quick, deep analysis of BI assets, limited only by the imagination of SQL. Meta Query has significant advantages over standard SQL tools like Toad or Mircosoft SQL Server Management Studio. |
Why would I use it? |
To query and report on complex platform metadata relationships that are not provided by any other application tabs, for example: "Show me the total file space consumed by all CMS folders" |
Of course, you need to know SQL and have experience with direct access to databases, in order to get desired results with Meta Query.
Warning
You can perform read-only actions with your data in MetaMiner Database with Meta Query. All SQL commands like ALTER, DELETE, TRUNCATE, UPDATE, EXEC, CREATE, DROP, INSERT and so on are blocked in order to keep your data consistent.
The Meta Query UI
The Meta Query tab consists of the following areas (see numbers in the picture above):
Each of them is described in a dedicated topic, in detail.
See also