Need help with Google Chrome report

[kcrum]

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.

[kcrum]

Thanks! it worked

[Hemoco · Accepted solution]

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