Report of every user that has logged into Windows 7

[Kupe]

My boss needs to send a message to all users of Windows 7 through one of our applications, and wants a list of users. I just bought Lansweeper and figured this would be a great first test of its usefulness. I'm looking through the forums and trying to figure out how to create a report to pull this information myself, but I would like to get the answer as quickly as possible. I figure it shouldn't be too hard to populate a list of users that have logged into a Machine with Windows 7. We only have about 100 Windows 7 computers so far. Thank you so much for any help you can provide!

[Kupe]

That's beautiful! Thank you so much. I need to take some time to really learn how to build reports like this.

[Hemoco · Accepted solution]

try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username,
  tblADusers.Displayname, tblADusers.email, tblComputers.OScode, tsysOS.OSname
From tblComputers Left Join
  tblADusers On tblADusers.Username = tblComputers.Username And
    tblADusers.Userdomain = tblComputers.Userdomain Inner Join
  tsysOS On tsysOS.OScode = tblComputers.OScode
Where tsysOS.OSname = 'Win 7'