Ok so I'm sure this question has been posed over and over, but I can't find any information for what I'm trying to do. I am trying to customize the grouping so that when you go into NPM and the web user interface, you can sort based on node names.
Screen shot of what I'm talking about:

So all our citrix servers have "ctx" in their name, our email servers have "email" in their name, etc etc.
I can query the nodes table and get the results I wanted, but I have no idea how to add a "grouping" with these sql statements. Is this possible? If not, how can I accomplish the same thing, doing it differently?
Thanks in advance!