KACE Product Support

Hello.  I am trying to get a report to list the users on our inventory report.  Here is what I have so far:  I am using smart labels to list the different buildings subnets

SELECT DISTINCT M.NAME AS NAME, M.CHASSIS_TYPE AS MAKE, M.CS_MODEL AS MODEL, M.BIOS_SERIAL_NUMBER AS SERVICE_TAG, L.NAME AS LOCATION, DA.SHIP_DATE
FROM MACHINE M
LEFT JOIN KBSYS.DELL_ASSET DA ON (DA.SERVICE_TAG = M.BIOS_SERIAL_NUMBER)
JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)
JOIN LABEL L ON (ML.LABEL_ID = L.ID) 
WHERE (L.NAME rlike')
ORDER BY LOCATION