Remediaiton Activiity Impact SQL Queries


I am working with one of our support teams to understand the impact of remediaiton work they are doing across an estate of about 1000 servers. Ideally I want to produce a query which gives them the solution and the impact of the solution being applied on the servers to be better proritise the work they are doing.

I am trying to query the table fact_remediation_impact for the data, but the table doesn’t seem to be found. Does this table exist? Has anyone else produced a sql query which does this sort of thing which they could share?


1 Like

Hi Bruce,
Have you tried the stock Top Remediations with Details report? We use it a fair amount to prioritize remediations.
Top description
Top Example

You can vary some of the report parameters to expand of hone down their focus.