Try this query
APM_AlertsAndReportsData.NodeId, APM_AlertsAndReportsData.ApplicationID, APM_AlertsAndReportsData.ComponentID,
Nodes.OwnerGroup, nodes.statusled, APM_AlertsAndReportsData.NodeName,
APM_AlertsAndReportsData.ComponentStatus, APM_AlertsAndReportsData.ComponentName, APM_AlertsAndReportsData.DisplayType
join Nodes on APM_AlertsAndReportsData.NodeId = Nodes.NodeID
order by Nodes.OwnerGroup, APM_AlertsAndReportsData.ApplicationName, APM_AlertsAndReportsData.ComponentName
I can't take the credit for it though. This is the handiwork of Leon Adato from when he worked here.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.