cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
phcosta
Engaged Sweeper II
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 ???
0 REPLIES 0