Installed Software Report & Version

[jfitz0]

Hi, I'd like to make a report to list of all assets that meet a certain criteria as selected by this report below:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Memory,
  tblAssets.Processor,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Where tblAssets.AssetID != 2 And tblAssets.AssetID != 123 And
  tblAssets.AssetID != 6 And tblComputersystem.Domainrole < 2
Order By tblAssets.AssetName

Along side that list the version of a specific piece of installed software selected by tblSoftware.softID:

Select Top 1000000 
  tblAssets.AssetName,
  tblAssets.Username,
  tblSoftware.softwareVersion
From tblSoftware
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Where (tblSoftware.softID = 248 Or tblSoftware.softID = 826)

Each works fine individually, but I'd like to show all assets in the initial list and their software version of this particular program, even if its not installed at all.

Thank you!

[Esben_D]

To make sure that you show all the assets even if they do not have the software installed you will have to use a case or subquery which mentioned if they specific software has been installed or not.