Systems Management Question
Not getting results for custom SQL query in Smart Labels, but get them in MySQL Workbench.
I'm trying to create a custom label that will tell me machines that had an error 8151 while patching. I've written the following query:
SELECT DISTINCT M.NAME AS MACHINE, LAST_INVENTORY
FROM PATCH_MACHINE_STATUS MS
JOIN MACHINE M ON (M.ID = MS.MACHINE_ID)
WHERE DETECT_ERROR_CODE = 8151;
Getting results back in MySQL workbench, but when adding the SQL to a Smart Label (tried to create as both Device and Patching), I get no results.
I've contacted KACE Support, but have not heard anything back other than the initial tech support call where I demonstrated it wasn't working.