Hello! I am working on creating a PowerBI report - one of the requirements is to show total number of devices that initially needed to install the patch - then split them into those that did and those that didn’t.
Please help me, I can’t get the number right.
I took content_results table and filtered that on one fixlet I was checking (filter on column: datasource_content_id). There is only one site for this fixlet.
I counted (distinct) all datasource_device_id rows that have first_relevant date. I also joined to datasource_devices table and checked if device is deleted or not. The number I get is lower than what Big Fix admins get in their portal. They get applicable 2, remediated 2065 (so 2067 in total) and I get 2117 for total devices (2245 if I count also deleted devices, but that shouldn’t be counted).
Where did I go wrong?
Thank you in advance for help!