Do you have any of the other Orion products, like APM/SAM or NPM? If so, you can build a custom SQL report using the Report Writer built into NPM. I have tried to use the custom report writer that is in the Patch Manager console, and the OSQL (I think that is what the Orion SQL language is referred to) is very confusing, and I have rarely gotten any results, much less the results I was hoping for. I have built reports for machines in a Pending Reboot state, machines still needing updates, etc., and could easily post the SQL for machines needing updates older than 30 days, but if you don't have access to the Orion SQL report writer that won't be very useful to you. Let me know.