→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎03-07-2013 09:25 PM
‎03-08-2013 03:35 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblCPlogoninfo.Username,
tblCPlogoninfo.Domain As Userdomain,
tblCPlogoninfo.logontime,
tsysOS.Image As icon
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblCPlogoninfo.logontime > GetDate() - 7
Order By tblAssets.Domain,
tblAssets.AssetName,
tblCPlogoninfo.logontime Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now