New Dashboards and Custom Fields

Pro Tips #62

Taking Custom Fields to the Next Level with BI Dashboards

In previous Pro-Tips, I discussed the importance of custom fields in Lansweeper and how they provide the foundation for effective asset classification, as well as explored a method to automate/populate the fields from a local CSV. By categorizing your assets based on custom criteria—like environments, applications, or monitoring status—you can ensure your IT inventory is organized in a way that works for you, your team, and your entire organization.

With Lansweeper’s new BI Dashboards currently in Beta (Sign up at https://www.lansweeper.com/product/beta if you don’t have the feature), you have the flexibility to move past the traditional dashboards that you see everywhere – and put those custom fields into action to really create something special.

In this walkthrough, I’ll show you how to create a quick and easy custom dashboard using the BI Dashboards feature, integrating a few of the custom fields that I have written about along the way. Remember: it’s not just about categorizing assets — it’s also about using classification to achieve better IT Asset Management (ITAM), more efficient IT Service Management (ITSM), Smoother IT Operations Management (ITOM), and a stronger posture for Information Security (InfoSec)… and, most importantly for being a proper SysAdmin, seeming more intelligent by your peers by saying all of those acronyms out loud and pretending that making these custom dashboards is really difficult.

An Example of a new BI-Dashboard, using Custom Fields

The Custom Fields

The custom fields in this demonstration are: Environment (Production, Development, QA, etc.), Application (Lansweeper Database, Veeam Backup and Replication Manager, etc.), Application Family (Lansweeper, Veeam, etc.), Monitored by PRTG (yes/no), Backed up by Veeam (yes/no) – but this walkthrough works for any custom fields you prefer to use.

Step 1: Access the New Dashboarding Interface

To begin, you need to enable Lansweeper’s BI Dashboards. This updated feature offers advanced visualization options to help you analyze your asset data.

• Navigate to the General Overview section in Lansweeper.
• In the left-hand menu, click the “TRY NEW DASHBOARD” button under “Create new board.”

Step 2: Create a New Dashboard

Once you’ve entered the new dashboard interface, the first thing you’ll do is create a blank dashboard to start customizing.

• Click “Create dashboard” and name it “Active Windows Servers” (or your preferred name).
• Confirm the creation to open a blank dashboard canvas.

Step 3: Add and Configure the “Asset Count” Widget

The Asset Count widget provides a quick summary of the total number of assets matching your criteria. Here’s how to set it up:

Add the Widget:

• Click “+ Add item” and select the “Number with Evolution” widget from the dropdown menu.

Configure the Data Source:

• Click the “Data” icon on the widget.

Open the Inventory dataset and locate the Asset Key field.

Drag the Asset Key field into the Measure slot to count the total number of assets. (Rename as appropriate – example ‘Asset Count’)

Step 4: Apply a Filter to the Entire Dashboard

For this step, we want to put a filter on the overall dashboard to limit any data to Active Windows Servers:

• Add a filter to narrow the widget to Active Windows Servers.
• Use the Inventory > State field and set it Equals Active.
• Use the Inventory > OS Version field and set it to Starts With 'Windows 2'.

Step 5: Verify the Asset Count for the Widget

The widget should now display the total count of active assets. For example, if there are 13 active servers, the widget will display “13.”

Step 6: Add a Horizontal Slicer Filter for Server Environments

Slicers allow you to dynamically filter your data based on custom fields like environments.

Add the Slicer:

• Click “+ Add item” and select the Horizontal Slicer Filter widget from the dropdown.

Configure the Data Source:

• Open the Data configuration and search for the Environment field in the Inventory dataset.
• Drag the Environment field into the dimension slot of the slicer.

Verify the Slicer:

• Ensure that categories such as Production, QA, Staging, and Development appear in the slicer (or the appropriate custom field data that you use)

Step 7: Add and Configure the “Application Family” Chart

A semi-circle donut chart provides a visual breakdown of application families.

Add the Chart:

• Click “+ Add item” and select the Semi-circle Donut Chart from the Pie & Donut section.

Configure the Data Source:

• Open the Data configuration and search for the Application Family field in the Inventory dataset.
• Drag the Application Family field into the Category slot of the widget.

Enable Cross-Filtering:

• Click the Filter icon on the chart and confirm the prompt to enable filtering across widgets.

Edit the Chart Settings to suit your needs (Title, Legend, Labels, Values, etc.)

Add Other Widgets/Items to Complete the Dashboard

Now that you are familiar with the basics of placing charts and adding data, you can recreate the entire dashboard by using the following reference images (Tip: Just duplicate a widget for similar charts to speed things up even more)

Conclusion

And there you have it – A dashboard that instantly shows how many servers you have, the environment and general purpose of them, and monitoring and backup compliance – all at a single glance. And, with the new BI-Dashboard beta, you can interactively click data points to see correlated data across the page – saving time with investigations, or gathering further details on various scenarios/combinations of asset data (with more features to come!)

There’s still much more that you can do with this strategy coupled with the power and flexibility of Lansweeper – and I’ll be sharing some more ideas, scripts and tips on this in future Pro-Tips.

Sweep On, Everybody!

-Jacob