Number of devices per group

Question

Hi, 
 How to create report of how many devices are in each group? 
 I have created group for each site, sites are different sizes (different number of devices). And now I'd like to have a report showing how many devices is in each group. 
 
 Thanks 
 Kris

krdep@arlafoods.com · Answer

Done, 
 SWQL 
 SELECT c.Name AS [GroupName], c.DetailsUrl, cm.Name AS [GroupMemberName] FROM Orion.ContainerMembers AS cm JOIN Orion.Groups AS c ON c.ContainerID = cm.ContainerID ORDER BY c.Name, cm.Name