# August 18, 2022 – MySQL Server Monitoring, Pre-Configured SNMP templates for Network Interfaces

August is here and with the heat we bring you all the latest features available on Domotz including MySQL Server Monitoring and pre-configured SNMP sensors for switches.

- You can now group your Sites into **Organizations**
- We've got pre-configured SNMP sensors for **network interfaces and switches**
- There's a New **Sites Explorer**section and left-side menu
- More improvements to the **Inventory**section
- **MySQL** **Server**Monitoring
- You can now configure **SAML/SSO for multiple teams**
- **Pagination for Kaseya BMS**account list

## What’s new

### Organizations

You can now organize your Sites (Domotz Agents) into Organizations which means better multi-tenant management.

Managing Organizations in Inventory Dashboard

1. At the top of the dashboard, select between "Organizations," "Sites," or "Devices" to view different categories.
2. Below the categories, view summary statistics for "Organizations": total organizations, those with offline sites, and without organization.
3. Use the search bar to find specific organizations by name.
4. The table lists organizations with columns for Organization Name, Total Sites, Offline Sites, Contacts, and Organization ID.
5. For each organization, see an option to "Add" contacts.
6. Review the number of offline sites directly in the respective column. For example, "John's Restaurants" and "Rady Children's Hospital" show as having 1 offline site each.

This new feature is available in the Inventory section. From the Inventory section you can create one or more Organizations, and afterwards choose which organizations your Sites belong to.

For each Organization, you can also create one or more Contacts.

Additionally, the new tab will give you a high level overview of the Organizations that have Sites requiring your attention.

Clicking on the number of Sites under each Organization lets you quickly review all the Sites belonging to an Organization as well as their status.

### MySQL Server Monitoring

We now include MySQL Server Monitoring. Through our Custom Integration Drivers framework you can now monitor MySQL Server status.

Monitor your MySQL database including status and metrics. MySQL server monitoring is available for databases you host on Linux servers.

_[Image: MySQL Server Monitoring]_

Here's what you can do with this new integration:

- Monitor the service status and version
- Keep track of the memory the service is using
- Record key metrics, such as average queries per second, slow queries, uptime and more.

For more information, please visit [Monitoring MySQL server through Domotz](https://www.domotz.com/integrations/software/productivity-tools/mysql-integration.php).

## Improvements

### Pre-configured SNMP templates for Network Interfaces

We’ve added a new set of pre-configured SNMP sensors for Network Interfaces.

Adding Pre-configured SNMP Sensors

1. At the top of the interface is a search bar labeled "Search for a property," allowing you to filter available SNMP sensors by property.
2. Below the search bar, there's a section titled "Available Pre-configured SNMP Sensors."
3. The "Network Interfaces" option is listed, showing selectable properties such as Interface, Operational Status, Inbound Traffic, and several others.
4. To the right of "Network Interfaces," there is a checkbox to select this option.
5. There is also a "Select All" checkbox at the far right of the search bar to select all listed sensors.
6. Click "Show less" to collapse detailed information under "Network Interfaces" if expanded.

Firstly, you can use this new templates for monitoring every Network Switch that's out there. Moreover, for network interfaces you can automatically extract all kinds of information. Monitor operational and admin status, inbound and outbound traffic, package discards, errors, MTU, speed status, as well as the Physical MAC address for each port.

The Monitoring Tables (in the Monitoring Dashboard section) also reports this information so that you can compare traffic statistics across multiple ports, managed network switches, and different sites.

Network Interfaces Dashboard Overview

1. The table lists network interfaces, displaying details such as Agent, Device Name, Interface, and Type.
2. The Operational Status column indicates whether interfaces are "up" or not, highlighted by a green label.
3. Inbound and Outbound Traffic columns show data rates, such as 16.81 MB/s and 2.12 MB/s.
4. Columns for Inbound and Outbound Discards and Errors provide additional performance metrics.
5. Use the filter options at the top of each column to refine the data based on specific criteria like Interface Type or Operational Status.

Lastly, this new features includes reporting in graph format. The reports include both historical data and statistical information.

Network Traffic Analysis for Switch Port

1. The image displays a monitoring dashboard for network interfaces, focusing on Switch 1, Port 11, and its inbound traffic.
2. A line graph shows traffic data over a selected time frame, from August 8 to August 15, 2022, measured in kilobytes per second (KB/s).
3. The graph peaks and troughs indicate varying traffic levels, with highlighted data showing a specific reading on August 14, 2022: 7.79 KB/s.
4. Options to adjust the data view for different timeframes (1 day, 7 days, 1 month) are available on the right.
5. A table on the right provides additional details such as inbound and outbound traffic and error rates per second.
6. Use this visualization to assess network performance and identify any significant changes or patterns in traffic over time.

### SAML / SSO for multiple teams

If you are configured with an Enterprise level multi-team structure (basically multiple Domotz Team Leader accounts reporting to the same hierarchy), you can now configure all the teams with the same IdP to allow a smooth SSO via SAML 2.0.

Domotz is compatible with any SAML 2.0 Identity Provider. In particular the system has been tested (and instructions to configure them provided) with the following IdP:

- Okta
- Azure AD
- JumpCloud
- Evo Security

If you are willing to use a different Identity Provider supporting SAML 2.0, please contact our [Support](mailto: support@domotz.com).

### Pre-configured SNMP templates for Cisco

We’ve added two new pre-configured SNMP sensors for Cisco devices. These new sensors automatically enable monitoring for:

- Fan Status
- Power Supply Status

SNMP Monitoring Dashboard Overview

1. Verify the device status is online and connected at IP address 192.168.5.1 in the header section, confirming network connection.

2. Access relevant device information using the tabs: Info, Connect, Alerts, History, SNMP, TCP, Interfaces, Config. Click "SNMP" for monitoring features.

3. Check SNMP monitoring status: current status shows "READ," using Authentication V2, with the agent's sample time set to 2 minutes.

4. Add new SNMP sensors by selecting "Add Pre-configured SNMP Sensors" or "Add sensor to specific OIDs." The system has detected 98 MIBs.

5. Review "Fan Status" and "Power Supply Status" sections, showing index, status, and source type information. All current statuses are marked as "normal."

6. Download status information using the "Download CSV" option for both Fan Status and Power Supply Status.

These steps allow for continued SNMP monitoring of the network device's health and operational status.

### Sites Explorer

At Domotz we** strongly value** your feedback. After receiving input from several of you, we chose to restore the “All Agents” legacy view in the WebApp and Desktop App .

Additionally, the Legacy view has a new name, "Site Explorer", which you can see on the top of the left sidebar menu.

Network Monitoring Dashboard Overview

1. The left panel shows navigation options: "Sites Explorer," "Inventory," "Monitoring Dashboards," and under "Setup," there are "Alerts Settings," "Integrations," and "Account."

2. The main panel titled "My Agents (11)" lists network agents, each with a status. The status categories include "Healthy," "Issues," and "Down," with respective counts: 2 healthy, 6 issues, 3 down.

3. Each agent entry details the name, email, and status. Colors indicate status: green for healthy, yellow for issues, and red for devices offline.

4. Key examples include:
   - "AWS - Class /16 discovery Agent" has been offline for 1 year.
   - "Draper Office - Agent on Router" lists 43 important devices, 23 offline.
   - "Technology Win - 30812" notes one security issue found.

5. The right side features a geographical map showing a highlighted location near Los Angeles, marked with a cluster number "7," indicating monitored agents' locations.

The "Manage" menu tab has a new name, which is "Inventory". You can continue using the "Inventory" tab to access all of your data (Organizations, Sites, Devices, etc.)

With the new "Site Explorer" view, we plan to continuously work on improvements in terms of usability and overall navigation experience.

### Improvements on the Inventory section

The right-menu in the Tags section now lets you focus in to review the tags applied to specific devices.

Device Inventory and Details Interface

1. The main panel displays a list of devices, sorted in columns: Site, Device Name, Location/Zone, Tags, and Insights. Each row represents a device with options to "Add" or view details.

2. Selecting a device opens the "Device Details" panel on the right. The panel shows device information like Name, Type, Make, Model, Location, Zone, Tags, IP Address, NetBIOS Name, MAC Address, and First Seen date. Editable fields include Name, Model, Location, and Zone.

3. The "Device Details" panel also provides service information with protocols like NetBIOS, SMB, and WMI listed.

4. Use this interface to manage device properties, categorize them with tags, and monitor their status and configuration in your network.

Moreover, the number of Sites with Important "Offline" devices no longer includes Sites which are completely offline. We've done this in order to avoid confusion on the total number of Sites with devices offline. Similarly, the number of Sites with "Security Issue" highlights only the Sites which are currently online.

Inventory Dashboard Overview

1. Navigate to the "Inventory" section on the left sidebar to manage site and device data.
2. The "Sites" tab displays metrics:
   - "11 Sites" allows you to view all site details. Use "Add Site" to include a new site.
   - "3 Offline" indicates sites currently offline. Use "Filter for this value" to refine results.
   - "6 With Important Offline Devices" highlights sites with critical offline devices.
   - "1 With Security Issues" marks sites needing security attention. Use the corresponding filter options to narrow your focus.
3. The map on the right visualizes site locations:
   - Numbers within colored circles represent the number of sites per region.
   - Interacting with these markers can give specific geographic breakdowns.

### Enabled Pagination on Kaseya BMS list of Accounts

When mapping Domotz Agents to your Kaseya BMS account, we can now retrieve a long list of PSA Accounts:

Mapping Domotz Agents to Kaseya BMS Accounts

1. On the left panel, find the "Domotz Agents List" where various agents like "Atanas Test Lab (GNS3)," "Draper Agent (Testing)," and others are listed.
2. On the right panel, locate the "Kaseya BMS Account" column to map each Domotz agent to a BMS account, such as "AccountWithOneContract," "Another 1," and "Domotz."
3. Use the search bar at the top of each panel to filter the agents or accounts by name.
4. There is a pagination control at the bottom, indicating page 1 of 2, with an option to navigate to the next page.
5. To complete mapping, ensure that each Domotz agent is linked to the appropriate Kaseya BMS account; if no account is selected, the agent will not be delivered to Kaseya BMS.
6. Click "Close" at the bottom to save and exit the mapping process.

What’s more, is that you can now map Domotz to Kaseya BMS even if you have tens of thousands of Accounts on your list. Additionally, you can map your accounts by searching for the Account name, or by scrolling down the list across multiple pages.

### Added support for TCP protocol within Custom Integration Drivers

Using our Custom Integration driver framework we now include the capability to add support for TCP connections.

For more information, please refer to the [Driver API Documentation](https://portal.domotz.com/custom-driver/D.device.html) under the _D.device.sendTCPCommand_.

### Additional MIBs available in the Domotz Database

Additional MIB files are available for the following devices. Additionally, you can search for their OIDs from Domotz:

- ASUSTOR
- Stormshield Firewalls

## Fix

We’ve fixed the following issues:

- The Configuration Management backup was not executing properly in some cases.
- The Pre-Configured SNMP sensor template not working on some printers.
- Issue logging into the WebApp with an Area Member account.
- Configuration Management: the issue causing a mixing up device configuration for same agent at the same time has been fixed.
- Configuration Management: SonicWall https calls timeout too low to fetch config in some cases.
- Fix for SNMP Counter64 variables within Custom Integration Drivers.
- Some Agents configured on Synology NAS were restarting continuously every 2 minutes.
- Fix for Sporadic Errors in retrieving configuration files for Juniper OS systems.
- Fix for Errors in identifying Virtual Machine details
- Topology Map: a fix for an issue that was preventing the export of an XLS file (for the Visio import).
- An issue preventing the correct mapping in some situation between Domotz Agents and HaloPSA Accounts have been fixed.

## **Known limitations**

- Monitoring Dashboards are currently limited to Monitoring Tables as Widgets. Furthermore, they do not report some variables (e.g. the ones created by the Custom Drivers) within the Monitoring Tables.
- Luxul Router-based Agents do not support VPN on demand. To elaborate, we’ll add this capability as soon as Luxul’s team provides us with the required API resources.
- Devices with multiple network interfaces (multiple MAC addresses) can’t be merged into a single device. This affects some types of switches that appear as multiple instances on Domotz when VLANs are configured.
- The static IP address on the Domotz Box cannot be configured before configuring the Agent.
- DHCP cannot be leveraged on additional VLANs on the Domotz Box.

To conclude, these release notes cover the changes in the Domotz Pro service since the previous one. Furthermore, these changes include Domotz Pro cloud, Domotz Agent, and Domotz Pro App.

Lastly, to learn more about check out our [network monitoring software](https://www.domotz.com/) or check out our [Know Your Networks Blog](https://blog.domotz.com/).
