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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share