Devices inventory per manufacturer

[ksantosh]

Hi,

My requirement is pretty straight-forward but I am having a hard time creating the conditions in Edit Report for this output. I have a network that has Cisco Routers and Switches and Switches from different vendors like Juniper, D-link, Cisco and RiverBed Devices (Which show up like switches in LanSweeper).

I have put in the filters as '%Router%' and '%Switch%' Expression tsysAssetTypes.AssetTypename and similarly, Cisco systems, Riverbed, Juniper and D-link for the Manufacturer expression. The output isn't what I expect it to be.

Any help on this topic would be highly appreciated.

Thanks,
Santosh Kotla

[Tom_P]

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