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
Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • Would it be possible to just use the software catalog?
    • 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.
      • 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?
  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
  • Yes been running 5.5 for a while, beta and now GA
Please log in to comment

Answers

2

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.

Answered 10/01/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity