Hi team, I have created 3 reports, each report contain information about SQL patching, one report is for SQL2106, other SQL2019 and SQL2022. I want to generate just one 3 report that include the 3 actions. Is there a way to join the 3 reports?
If you can share the details (session relevance query) from your report, someone might be able to assist you more effectively.
1 Like
Hi , thanks for your reply
I’ve configured three baselines to install SQL patches—one for each version: SQL 2016, 2019, and 2022. Additionally, I set up three corresponding reports, each linked to a specific action, I generated these reports from the ‘Actions’ section, referencing the same actions used in the baselines. On the administration tap I had created an schedule for each report, and they are sending on CVS format. the problem is that I need to join the 3 actions reports (CVS) files on just one report and fiel
Try this in a custom report:
<?Relevance
(
item 0 of it & "," &
item 1 of it & "," &
item 2 of it & "," &
item 3 of it
) of
(
(name of computer of it),
(status of it as string),
(detailed status of it as string),
(name of action of it)
) of
results of
bes actions whose
(
(
(type of it = "Baseline") and
(name of it is contained by "gdba_vuln_oct-nov_sql2016 | gdba_vuln_oct-nov_sql2019 | gdba_vuln_oct-nov2025_sql2022")
)
of source fixlet of it
)
?>
1 Like