Northcraft Analytics provides business intelligence applications for IT. ServiceNow, SolarWinds, BMC Remedy ITSM, IBM Netcool and more.

E-Mail: info@northcraftanalytics.com Phone: (800) 565-1375

How to Build a SolarWinds Dashboard for Errors and Discard with Power BI

Last modified: November 26, 2019
You are here:
Estimated reading time: 2 min


How to Build a SolarWinds Dashboard for Errors and Discard with Power BI


In this article, we will be examining the errors and discards using a SolarWinds database. Using a matrix in Power BI, we can observe the data using drill-down techniques as we nest some of the fields.

To learn more about Northcraft, take a look at our Resources page.

Step 1: To begin, select a multidimensional database (MDB)

Step 2: Select a cube. We’ll use ‘NPM’

Step 3: Select the ‘OK’ button

Matrix

Step 4: Select the ‘Matrix’ option from under ‘Visualizations’

Step 5: Drag the edges if the matrix to resize it and make it easier to see

Step 6: Select the search bar to start building out analysis. Type in ‘hierarchy – machine’

Step 7: Select the ‘Hierarchy – Machine’ field

Step 8: Select the search field, delete the last query, and type in ‘IF Name’

Step 9: Click and hold on the ‘IF Name’ option

Step 10: Drag it over to the ‘Rows’ section, under the hierarchy

Step 11: Select the search bar, delete the last query, and type in ‘interface type description’

Step 12: Click and hold on the ‘Interface Type Description’ field

Step 13: Drag it down into the ‘Filters’ section

Step 14: Open up the ‘Interface Type Description’ by selecting the dropdown button on it in the ‘Filters’ section

Step 15: Select the ‘PPP’ option to filter

Step 16: Select the ‘PPP Multilink Bundle’ filter

Step 17: Also select the ‘Serial’ option

Step 18: Select the search bar, delete the last query, and type in ‘inbound errors’

Step 19: Select the ‘Inbound Errors’ option

Step 20: Select the search field, delete the last query, and type in ‘outbound discards’

Step 21: Select the ‘Outbound Discards’ field to add it to the matrix

Step 22: Right click on the ‘Vendor’ option so we can expand the matrix and see more of the data

Step 23: Select the ‘Expand to next level’

Step 24: Select the search bar, delete the last query, and type in ‘percentage of interface discards overall’

Step 25: Select the ‘Percentage of Interface Discards Overall’ field

Step 26: Now we can see all the data neatly laid out. By right-clicking on the ‘Vendor’ side, we can expand up or down if needed.

 


Support Information


Support by website

You can obtain technical support from Northcraft Analytics 24 hours a day, 7 days a week at https://northcraftanalytics.desk.com. From this website, you can:

  • Find the most current information regarding Northcraft Analytics products.
  • Manage your account information
  • Upload documents for content sharing exchange.
  • View shared documents from other users.
  • Order or download product documentation.
  • Download products and maintenance releases.
  • Report an issue or ask a question.

Support by telephone or email If you need technical support either by phone or email:

Call (+1) 800 565 1375

or by email using:

support@northcraftanalytics.com

 

Every effort has been made to make this as complete and as accurate as possible, but no warranty or fitness is implied.

The information is provided on an “as is” basis. The author and Northcraft Analytics, LLC, shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this manual or from the use of the discs or programs that may accompany it.

Copyright © 2010 Northcraft Analytics LLC. All Rights Reserved.

Was this article helpful?
Dislike 0
Views: 28