Creating SQL Server Queries in the AD RMS Logging Database
About This Video
In the sixth video of the AD RMS Logging series Peter Gilson demonstrates how to create an advanced query in SQL Server for the AD RMS Logging Database. In this video he writes a query that will return the number of unique pieces of content that are protected by AD RMS in a given time frame.
For more information on AD RMS logging, watch the next video in series
Creating Reports from the AD RMS Logging Database or start at the beginning of this series with Introducing the AD RMS Logging Database (
Also, you can read the TechNet article
AD RMS Performance and Logging Best Practices.
Published Date: April 01, 2010