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:
Did anyone have any luck to creating the SQL or SWQL query?
I am looking at reporting on something very similar, but instead of reporting on user's I am reporting on interface ports active in the last 30 days.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.