SQL patch reporting - action status and patch level

Reporting
1

Hi all,

I created an analysis to retrieve the SQL Server patch level, and it’s working as expected, I can see the column populated on the computer objects. I was also able to include this column in a report listing all SQL Servers.

However, when I run an action using a baseline and generate a report to view the status, I’m unable to include the patch level column in the action report.

Do you know if there’s a way to add that column to the baseline action report?

2

If your report uses session relevance, you can retrieve the specified property results along with the action status by using below relevance expression:

value of results from (bes property "Name of Sub Analysis RP") of computer of it as string

However, neither the Console’s Action Status view nor the standard Web Report action‑status template provides an option to include Analysis columns.

1 Like