Clients not backed up in 7 days report

[MatthewN]

Hello

Im currently using the 'clients not backed up' template set to look at 7 days but it is reporting on deactivated as well as active policies so the report is huge and not suitable for what I need it for.

Does anyone have an idea or solution to get a report looking at all clients not backed up in 7 days ignoring deactivated policies?

Ive tried to find a sql version of the 'clients not backed up' report template so I could add a filter to not include deactivated policies myself but I cant find one and my sql knowledge is fairly low so I cant create a full script myself.

Im using OpsCenter with analytics version 7.6.0.2

Thanks

[RiaanBadenhorst]

There is usually a link at the bottom of the screen that says "Show query", if there isn't such a link then its using a stored procedure.