KACE Product Support Question
Can anyone whos good with SQL help with a custom report please?
So I have a report I found on here that tells me the age of a computer by telling me the ship date. I have all my machines tagged with a location (about 10 Labels) in a Group Label called "Location / Jobsite" Is there a way to have my warranty report group the resaults together by the Labels inside the group label of "Location / Jobsite"?
SELECT M.NAME AS Computer_Name, D.SHIP_DATE
FROM MACHINE M
JOIN DELL_ASSET D ON D.SERVICE_TAG = M.BIOS_SERIAL_NUMBER
ORDER BY NAME
Any info would help, thanks all.