Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Filtering only canned reports

Hello All

is there any way we can filter only canned reports ,

we have bunch of old and unwanted reports in our env and we need to tweak them and delete everything apart from canned reports

Find more posts tagged with

Accepted answers

All comments

neomatrix1217

I'm sure someone smarter than me can come up with a better way but you could run a SQL query and anything that has an owner would be a custom report and any report that the owner field equals NULL is out of the box.

SELECT [Name],[Owner],[Type] FROM [dbo].[ReportDefinitions] WHERE [Owner] <> 'Custom'

rehan.mudassir

Hi neomatrix1217 thanks for reply

Yes we can able to segregate canned report the way u suggested

But I have different issue , recently we have build new environment of Orion and we have brought more than 100 reports from old server

now we does not have the owners of those Old reports in New server and it shows owner as Null for custom reports :-)