Query to count devices in KACE Organizations
I need create a sql report to count all devices in each organization, but not in SMA Systems, in another sql tool(HeidiSQL).
We have 30 organization and this view need get the ID, Name, Description and Computer Count.
Please see what I got so far:
(select distinct count(ID) FROM ORG1.MACHINE)as 'Computer Count'
I believe it is necessary to create a loop, but I haven't got it yet.