‎06-22-2016 02:32 PM
Solved! Go to Solution.
‎07-04-2016 02:51 PM
Select Top 1000000 tblCPlogoninfo.Domain,
tblCPlogoninfo.Username,
Max(tblCPlogoninfo.logontime) As [Logon Date\Time],
tblAssets.AssetName
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Group By tblCPlogoninfo.Domain,
tblCPlogoninfo.Username,
tblAssets.AssetName
Order By tblCPlogoninfo.Domain,
[Logon Date\Time],
tblAssets.AssetName
‎07-04-2016 02:51 PM
Select Top 1000000 tblCPlogoninfo.Domain,
tblCPlogoninfo.Username,
Max(tblCPlogoninfo.logontime) As [Logon Date\Time],
tblAssets.AssetName
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Group By tblCPlogoninfo.Domain,
tblCPlogoninfo.Username,
tblAssets.AssetName
Order By tblCPlogoninfo.Domain,
[Logon Date\Time],
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now