→ 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: 
voncollr
Engaged Sweeper
I need to run a report like this on but add AVG and Atempo, so the computers displayed must have both pieces of software.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblSoftwareUni.softwareName Like '%Avg%'
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
Karel_DS
Champion Sweeper III
You could display things in separate columns like with this query:

Select DISTINCT Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni_2.softwareName,
tblSoftware_2.softwareVersion
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSoftware AS tblSoftware_2 On tblAssets.AssetID = tblSoftware_2.AssetID
Inner Join tblSoftwareUni AS tblSoftwareUni_2 On tblSoftwareUni_2.softID = tblSoftwareUni_2.SoftID
Where tblSoftwareUni_2.softwareName Like '%Avg%'
AND tblSoftwareUni.softwareName Like '%Lansweeper%'
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
Karel_DS
Champion Sweeper III
You could display things in separate columns like with this query:

Select DISTINCT Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni_2.softwareName,
tblSoftware_2.softwareVersion
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSoftware AS tblSoftware_2 On tblAssets.AssetID = tblSoftware_2.AssetID
Inner Join tblSoftwareUni AS tblSoftwareUni_2 On tblSoftwareUni_2.softID = tblSoftwareUni_2.SoftID
Where tblSoftwareUni_2.softwareName Like '%Avg%'
AND tblSoftwareUni.softwareName Like '%Lansweeper%'
Order By tblAssets.AssetName

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now