Unable to sort Cisco device models to IOS version and Device description on Orion Summary page

9/23/2021 11:23 PM

9/23/2021 11:23 PM

This article describes how to sort only the unique Cisco device models and the corresponding device description and IOS version installed on the Cisco devices. Then display on Orion Summary page via Report table widget. 

 

The selection methods Dynamic Query Builder and Specific Objects (static selection) has a limitation which cannot filter unique values but will show repeating data of the same device model even if Sort results by or Group results by are used.

 

See sample result below when using Dynamic Query Builder and Specific Objects (static selection) in report table:

Same Cisco device model, IOS version and Description

When Group results by or Sort results by is used on table the results are the same as shown on the image below:

Network Performance Monitor

Due to the limitation of Dynamic Query Builder and Specific Objects (static selection) which cannot filter unique values instead redundant data are being displayed.

Follow the steps below:

1. On Summary page >Select Pen button >Customize Page > Add Widgets
2. Under Group By> Select Reports > Select Custom Table and drag and place in Summary Page
3. Select Done Adding Widgets> Done Editing> Select the added table > Edit
4. Change Title of table> Select Datasource> Selection Method> Advanced Database Query (SQL, SWQL) > Query Type> Select SQL
5. Enter the following SQL script : 

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   SELECT DISTINCT MachineType, IOSVersion, Description FROM Nodes
   Where Vendor = 'Cisco'

6. Update Datasource> Add Column> Select the checkboxes of MachineType, IOSVersion, Description > Add Column
7. (Optional) Under Group results by: > Select Column > Machine Type
8. Preview resource > OK > Save

Step 7 is only optional. By using Group results by the report table will have a more organized look. Proceed to step 8 if you are good with the table without using Group results by.