Report help

[Lance]

Hi,

I have this report but I want to add assettype, firstname of user, last name of user after AssetID. Can you assist? Also, is there field that I can add which version of MS Office it's running? If so, can you add it after OSname? Below is report that I have now.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tblAssets.AssetName

[Hemoco · Accepted solution]

Please use the report below:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
  tblAssets.AssetID,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssetCustom.Model,
  tblAssets.Domain,
  tsysOS.OSname,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblAssets.Description,
  tblAssets.Username,
  tblAssetCustom.Serialnumber,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Warrantydate
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
    And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%'
Order By tblAssets.AssetName