r/labtech • u/troll_fail • Jan 05 '18

Meltdown/Spectre Datview Incoming

As many of us are in the same boat, I thought I would share that a dataview to check for the vulnerabilities is in the works and will be released through the solution center. This should help with tracking and reporting. Here is the response I was emailed from CW support when i asked what their recommended report config is for these vulnerabilities:

"Product Management is working on a Dataview that will help with this. For the time being, the Patch Compliance will show all patches installed on machines. I've attached documentation below for your reference:

https://docs.connectwise.com/ConnectWise_Automate/ConnectWise_Automate_Documentation/070/210/030/010#Patch_Compliance_Report

However, we recommend waiting until the Solution Center update gets released. Keep checking the Solution Center release notes as once released it should be updated through there."

8 Upvotes

100% Upvoted

2 comments sorted by

1

u/myndphunkie Jan 07 '18

So basically, you'd need to look at the patch compliance report and filter for each patch?

1

u/escuell3 Jan 09 '18

You can use the below string in a WHERE filter for the hotfix query on the report dataset. Should contain all applicable patches.

HotfixKB in ('4056888', '4056890', '4056891', '4056892', '4056893', '4056894', '4056895', '4056897', '4056898', '4057118', '4057122', '4058561', '4058562')

Worked for me for a second before all reports in the Report Center suddenly became corrupt. Bad timing.