As an example of what is possible with the ASSP.DiscoverXmlMetadata() function the following is a sample report that is included with the reports project.
Cube Status Report
Lists the Cube status and the estimated size of the partitions, measure groups and cubes.
Discover Roles Report
Note: This report is not part of the lastest release, you will need to download the latest change set from the Source Code tab
Lists the Role members and permissions of all the roles for the selected database.