Select Top 1000000 tblAssets.Domain,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Mac,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate,
tblSoftware.Lastchanged
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Order By tblAssets.Domain,
tblAssets.AssetName
^ That should do the trick for most of it... Not sure if "Lastchanged" is last 'updated' or last used however. I can't really see anything particular to 'last used'.