Need help with SQL Query
I have a query to show me all the users with Google Chrome. I don't need MACHINE.MAC listed below. What I would like is last logged in username. What is the query for that?
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE LEFT join SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE on MACHINE.ID=SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MACHINE_ID WHERE ((SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.NAME like 'Google Chrome%')) GROUP BY MACHINE.ID