‎02-23-2015 01:50 PM
Select Top 1000000 tblSoftwareUni.softwareName,
tNotInstalled.AssetID,
tNotInstalled.AssetName
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Left Join (Select tblSoftwareUni.SoftID,
tblAssets.AssetID,
tblAssets.AssetName
From tblSoftwareUni,
tblAssets
Inner Join tblComputersystem
On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
Not Exists(Select tblSoftware.softID,
tblSoftware.AssetID From tblSoftware
Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
tNotInstalled.AssetName
‎02-23-2021 01:16 PM
Daniel.B wrote:
This report will list all software installations on a reference computer called "Reference" (i.e. lab computer) in the example below. Next to each software a list of workstations will be displayed not having this software installed.
Select Top 1000000 tblSoftwareUni.softwareName,
tNotInstalled.AssetID,
tNotInstalled.AssetName
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Left Join (Select tblSoftwareUni.SoftID,
tblAssets.AssetID,
tblAssets.AssetName
From tblSoftwareUni,
tblAssets
Inner Join tblComputersystem
On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
Not Exists(Select tblSoftware.softID,
tblSoftware.AssetID From tblSoftware
Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
tNotInstalled.AssetName
‎02-23-2021 01:02 PM
‎07-12-2017 09:04 AM
‎07-05-2017 03:59 PM
‎03-10-2015 02:44 PM
‎03-09-2015 05:16 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now