→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kcrum
Engaged Sweeper
I need help making a report that shows Assetname, Domain, shows that it has Google Chrome installed, and the username of the last known login.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try this report. LastSeen = Last scan date, so is the last login date of the user too.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Google Chrome%' And
tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1

View solution in original post

2 REPLIES 2
kcrum
Engaged Sweeper
Thanks! it worked
Hemoco
Lansweeper Alumni
Please try this report. LastSeen = Last scan date, so is the last login date of the user too.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Google Chrome%' And
tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1