I would like to create a report that counts the number of active users per office location per month.
In the ‘nodes’ table I have custom properties for each node that includes for example ‘Region’ and ‘Location’. Using these custom properties I would like to count the number of active users per month to allow me to view the user occupancy at remote sites over time.
Something like this:
I think there would need to be a JOIN between the ‘nodes’ table and one of the UDT tables, but with very little SQL skills I haven’t been able to craft a SQL query yet.
Any SQL guru’s out there?
Perhaps the relevant database tables might be: