‎08-11-2016 08:27 PM
‎01-11-2017 05:50 PM
‎08-16-2016 10:32 PM
Select Top 1000000 T1.IPLocation,
T1.softwareName As Software,
T1.softwareVersion As Version,
Count(T1.IPLocation) As SoftwareCount
From (Select Top 1000000 (Case
When tsysIPLocations.IPLocation Is Not Null Then
tsysIPLocations.IPLocation Else 'Undefined' End) As IPLocation,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Adobe%' And tblAssetCustom.State =
1) T1
Group By T1.IPLocation,
T1.softwareName,
T1.softwareVersion
Order By T1.IPLocation,
Software,
Version
‎08-15-2016 01:34 PM
‎08-12-2016 09:56 PM
Select Top 1000000 T1.IPLocation,
Count(T1.IPLocation) As SoftwareCount
From (Select Top 1000000 (Case
When tsysIPLocations.IPLocation Is Not Null Then
tsysIPLocations.IPLocation Else 'Undefined' End) As IPLocation
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssetCustom.State = 1 And tblSoftwareUni.softwareName Like '%Acrobat%')
T1
Group By T1.IPLocation
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now