In case anyone else runs into this.
Depending on what version you are running, I was wondering why only 7 reports were showing up from the select from the xml column.
As I removed and added reports, figuring it had to be the way I named stuff, it came down to the xmlnamespace.
;WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition') -- setup namespace
I don't know if Jon mentioned it in the article use the latest namespace, then you should see the rest of your reports.
Great article, very useful, thank you. 🙂