1 Reply Latest reply on Jan 5, 2018 7:49 AM by jdw_uk

    UDT custom report for number of users per site

    jdw_uk

      Hi all,

       

      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:

       

      Region

      Location

      Active users

      AMER

      Office 1

      10

      EMEA

      Office 2

      100

      EMEA

      Office 3

      90

      APAC

      Office 4

      36

       

      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?

       

      Thanks!