Report by IP with wildcard

[jperryman]

Hello all.
Is there a way to get a report that will list all devices within a certain range using wildcards for the 2nd and 4th octet of an IP4 address?
For example:
10.*.1.*
where the asterisks are wildcards

I have little to no sql experience.
Thanks in advance.

[jperryman]

Thanks! Much appreciated!

[mateusz]

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssets.IPAddress Like '10.%.1.%'
Order By tblAssets.IPNumeric