‎01-27-2010 11:13 AM
‎01-28-2010 04:07 PM
‎01-28-2010 02:58 PM
‎01-28-2010 10:59 AM
‎01-28-2010 02:41 PM
sisman wrote:
export is working now, but Total number is confusing me, for some users it reports over 500, and it is not possible that user was logged on 500 different computers
‎01-28-2010 10:48 AM
Select Top 1000000 tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
IsNull(tblADusers.Displayname, '') As Fullname,
Count(tblCPlogoninfo.Computername) As total
From tblCPlogoninfo Left Join
tblADusers On tblADusers.Username = tblCPlogoninfo.Username And
tblADusers.Userdomain = tblCPlogoninfo.Domain
Where tblCPlogoninfo.logontime > GetDate() - 30
Group By tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
IsNull(tblADusers.Displayname, '')
Order By Count(tblCPlogoninfo.Computername) Desc
‎01-28-2010 10:34 AM
‎01-27-2010 02:37 PM
‎01-27-2010 02:01 PM
‎01-27-2010 12:34 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now