This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

how to count total number of devices by location

hi all 

how to divide by location . i have created a  custom property call (locations) and i wan to divide all devices by locations and total number of device by location

. example :   London , 100 

                    England   110 

            total  devices   210    

select count(1) as kpi_number from orion.nodes

Parents Reply Children
No Data