I don't know how to do that, but you could create a custom SQL Node alert with this condition: "where not Caption in (SELECT distinct [FullName] FROM [NetPerfMon].[dbo].[ContainerMemberSnapshots] where [EntityDisplayName] = 'Node')"
An alternative would be to go back to the All Nodes list and implement custom properties.
- Create two custom properties: Region and Site.
- Fill in the region/site information for each node (the custom property editor can be used to import a csv to make this quicker).
- On the view with the All Nodes resource, edit that resource and for Level 1 group use Region, and Level 2 group use Site.
- There is a radio button to place all nodes with null values for the groups into an Unknown group.
You will have a heirarchy of region -> site -> node and all new devices will appear in Unknown. Unfortunately, you will not get the additional functionality provided by groups.
Yeah...I have done something similar in the past. However, we prefer a dynamic solution instead of something static. We know device names are deployed correctly with site codes and it would be nice to automatically sort them as we add new devices.
Maybe if Solarwinds developed a default group option where if the group field is null, place in x group.