Managing security settings in Reporting Services through the Report Manager website is usually pretty easy. However I've found that sometimes things go astray. Today I found a few reports which weren't inheriting permissions from their parent directory. Easy enough to fix, you jump into the security settings for that report and set "Revert to Parent Security". However, I have dozens of reports in each of a dozen directories; if I suspect this problem is going on in other reports, I'm not keen on a "needle in a haystack" search.
Here's the code for identifying which reports are no longer inheriting permissions from their parent:
USE ReportServer
SELECT
[Path],
[Name]
FROM
[dbo].[Catalog]
WHERE
[PolicyRoot] = 1