Hi,
For the filter on the asset type, you can make use of the following filter:
Like '%Router%' Or Like '%switch%'
For the filter on the manufacturer you can set it like this:
Like '%Cisco systems%' Or Like '%Riverbed%' Or Like '%Juniper%' Or Like '%D-link%'
Code-wise, it would be like this:
Select Top 1000000 tblAssets.AssetID,
tblAssetCustom.Manufacturer,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.Manufacturer Like '%Cisco systems%' Or
tblAssetCustom.Manufacturer Like '%Riverbed%' Or
tblAssetCustom.Manufacturer Like '%Juniper%' Or
tblAssetCustom.Manufacturer Like '%D-link%') And
(tsysAssetTypes.AssetTypename = 'Router' Or tsysAssetTypes.AssetTypename = 'Switch') And tblAssetCustom.State = 1
Order By tblAssetCustom.Manufacturer