Number of devices per group

krdep@arlafoods.com

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

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