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
2 Comments
[ + ] Show comments
-
Would it be possible to just use the software catalog? - rsm11 11 years ago
-
Software catalog is what I need the software tab doesn't actually show all installed instances of Chrome. This is a bug and I'm trying to get it resolved. - petelanglois 11 years ago
-
I see that when viewing searching chrome in the software tab it doesn't give reasonable information. But the software catalog works well. Are you running 5.5? - rsm11 11 years ago
-
Yes been running 5.5 for a while, beta and now GA - petelanglois 11 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
dugullett
11 years ago
I use MACHINE.USER_LOGGED since it includes the domain since we have multiple. You can also use MACHINE.USER, MACHINE_USERFULLNAME, or MACHINE.USER_NAME.
Comments:
-
Thanks I'll try those out. - petelanglois 11 years ago
