→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kupe
Engaged Sweeper
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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'

View solution in original post

2 REPLIES 2
Kupe
Engaged Sweeper
That's beautiful! Thank you so much. I need to take some time to really learn how to build reports like this.
Hemoco
Lansweeper Alumni
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'