→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-11-2018 03:46 AM
‎06-13-2018 03:30 PM
‎06-13-2018 10:38 AM
‎06-11-2018 03:02 PM
Select Top 1000000 tblCPlogoninfo.Username,
tblCPlogoninfo.logontime,
tblAssets.AssetID,
tblAssets.AssetName
From tblAssets
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblAssets.AssetName Like '%YourAssetName %'
Order By tblCPlogoninfo.Username,
tblCPlogoninfo.logontime
Select Top 1000000 tblCPlogoninfo.Username,
tblCPlogoninfo.logontime,
tblAssets.AssetID,
tblAssets.AssetName
From tblAssets
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime Between '05/01/2018 ' And '06/01/2018 '
Order By tblCPlogoninfo.Username,
tblCPlogoninfo.logontime
‎06-11-2018 11:57 AM
‎06-11-2018 09:57 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now