Fiz algo assim :
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblAssetCustom.State = tblState.State
Where tblAssets.IPAddress Like '10.111.9.%' And tsysAssetTypes.AssetTypename =
'Windows' And tsysAssetTypes.AssetTypename <> 'location' And
tblState.Statename = 'active'
Order By tblAssets.AssetName Desc
Será que consigo pegar no range : 10.111.8.1 - 10.111.10.255 ???