
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2017 01:42 PM
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
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
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2017 01:50 PM
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
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
