Systems Management

I am looking to create a custom report in KACE that lists all devices and the detection status of all patches that are in a particular patch label. For example, I have a patch label called "Approved OS Patches" which contains all of the patches that are currently approved for deployment. I want a report whose output looks similar to the following: Device Name, Patch Name, Detection Status Computer1, KB1234567 Patch one, PATCHED Computer1, KB2345678 Patch two, NOT PATCHED Computer2, KB1234567 Patch one, PATCHED Computer2, KB2345678 Patch two, PATCHED ...and so on. I have spend quite a lot of time with the wizard trying to come up with something and I am not able to create what I am looking for. Unfortunately, my SQL skills are not ideal, either. If anyone has had success creating something like this with the wizard or a SQL query, please share.