cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
FbrAbreu
Engaged Sweeper
It is possible to include in the report below the history of 7 days, not only the last login of the user.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
Max(tblCPlogoninfo.logontime) As LastLogon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID And
tblCPlogoninfo.Username = tblAssets.Username
Where tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username
Order By tblAssets.AssetName,
LastLogon Desc

the report was created in the link
http://m.lansweeper.com/Forum/yaf_postsm42004_Reports-and-User-Logon.aspx#post42004

I thank if someone will manage to help me
0 REPLIES 0