cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
francisswest
Champion Sweeper
Im in need of a report that lists all of the 'Dell Latitude XXXX'(where XXXX is the model number) without a certain piece of software. In this case, the software that lansweeper detects it as is called "BIG-IP Edge Client"
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
This report should work for you:
Select tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.Model Like 'Latitude%' And tblAssetCustom.State = 1 And
Not Exists(Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftware.AssetID = tblAssets.AssetID And
tblSoftwareUni.softwareName Like '%BIG-IP Edge Client%')
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
This report should work for you:
Select tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.Model Like 'Latitude%' And tblAssetCustom.State = 1 And
Not Exists(Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftware.AssetID = tblAssets.AssetID And
tblSoftwareUni.softwareName Like '%BIG-IP Edge Client%')
Order By tblAssets.AssetName