Is it possible to make a report like the Last Seen Users dashboard

[steve_huon]

Hey,

Is it possible to make a report where the output looks like the Last Seen Users dashboard?

Regards,

Steve

[Hemoco]

Please try the report below. It lists user logons that occurred in the last 7 days. Replace the number marked in bold to change the time frame.

Select Top 1000000 tblCPlogoninfo.Username,
tblCPlogoninfo.Domain As Userdomain,
tblCPlogoninfo.logontime,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.AssetID
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime > GetDate() - 7
Order By tblCPlogoninfo.logontime Desc