→ 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: 
jfitz0
Engaged Sweeper
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!
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
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.