Just to help supercharge anyone else trying to get this information…
Some instructions for Linux users:
SSH into your Linux box
Connect to mysql: mysql -h localhost -u YOUR_LIBRENMS_SQL_USER -p librenms
Get a list of column names for devices: desc devices;
Select some data to check what the columns match to: select hostname,sysname,display from devices;
You can then match the correct filter when filtering alerts/services etc based on what you’re seeing in the database.