Sending notification emails to members (WIP)
For maintenance emails and other notifications to members, being able to retrieve all the members for a certain node is a useful tool.
Getting the List of NN's:
There are a few ways to retrieve the list of NN's that need to be notified of an outage.
In some situations only one NN will be affected, like it you are taking one building offline. That's easy, one NN to notify.
Otherwise you can use tools like Outage Simulator and Node Explorer to determine which nodes will be affected by an outage.
Generally, it's better to over-notify than under-notify, so we are usually pretty liberal with our notification emails.
Retrieving the emails from MeshDB:
Using MeshDB allows you to retrieve all the emails for individual members with a few simple steps.
Access the SQL Explorer tool located at https://db.nycmesh.net/explorer/.
You'll need a login to Mesh DB, so either request one in #meshdb on slack or grab a friend who has one.
Select the "email from NN" query and click the Play button.