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?