Hello, I’m using graphite with grafana and I’ve created some metrics that store data in graphite in the form of:
ADStatus.ADDefault.USERNAMES.LockedOut (data will be a 0 if not locked out or 1 if locked out) TIMESTAMP
I have a script that queries our AD and checks each user and their locked out status.
I want to have a table that will show locked out users (if their value is 1).
I’m not sure how to build this query though…so far I have:
“aliasByNode(highestCurrent(ADStatus.ADDefault.*.LockOutStatus, 5), 2)”
But this just displays the ‘top 5’ regardless of their value…(all are 0 except 1 for testing).
How would I do a query like…
ADstatus | ADDefault | * | LockOutStatus | WHERE VALUE = 1 | aliasByNode(2)
Is this possible?