Device Last Logon Report

[j0ngreen]

Hi

I am currently trying to get a report which lists each asset (in this case, laptop), the users that have logged onto it with dates and also IP addresses they have connected from but really struggling

When I say users that have logged on, I need it in the format the same as when you click on "config" on an asset, then "user info" and the "last logon" to list hsitorical access, not just the last user of the device

Can it be done?

J

[j0ngreen]

Brilliant, its working I have made a couple of changes as the IP's were coming through all the same so I changed the IP pickup from Assets to logoninfo and also sorted the dates. Now I can track the pesky users 🙂

Select Top 1000000 tblassets.AssetName,
tblassets.AssetID,
tsysassettypes.AssetTypeIcon10 As icon,
tblCPlogoninfo.Username,
tblCPlogoninfo.logontime,
tblassetcustom.Model,
tblCPlogoninfo.Ipaddress
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblCPlogoninfo On tblassets.AssetID =
tblCPlogoninfo.AssetID
Where tblassetcustom.State = 1
Order By tblCPlogoninfo.logontime

Thankyou so much!!!