‎06-01-2017 06:30 PM
Where tblAssets.IPAddress Not Like '10.2.%'
Where tblAssets.IPAddress Like '10.2.%'
Where tblAssets.IPAddress = 'not like ''10.2.%'
Where tblAssets.IPAddress = 'like ''10.2.%'
‎06-13-2017 05:13 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Custom1 As asset_tag
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Where
tsysIPLocations.IPLocation = 'MJct Subnet All' And
tblAssets.IPAddress Not Like '10.2.%' And
tblAssetCustom.State = 1 And
tblAssetCustom.Model <> 'Virtual Machine'
‎06-13-2017 03:55 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Custom1 As asset_tag
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where tsysIPLocations.IPLocation = 'MJct Subnet All' And tblAssetCustom.State =
1 And tblAssetCustom.Model <> 'Virtual Machine'
‎06-13-2017 01:48 PM
where IPAddress not like '10.2%'
Not Like '10.2.%'
‎06-12-2017 04:24 PM
Where tblAssets.IPAddress Not Like '10.2.%'
Where tblAssets.IPAddress = 'Not Like ''10.2.%'
‎06-09-2017 11:48 PM
‎06-09-2017 11:39 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now