I request help for setting up logged in User’s username as a filter condition Grafana Dashboard.
In my case there are different Member users in the system. And when a Member user logged in,
he should be able to view his data only. For this I want to get the user name in my panels and
add this user name as a filter condition. I am using SQL server Database.
There are Member1 and Member2, when Member1 logged into the system he should be able to view the Dashboard with his data only. I have one column in my database table with user name data (eg. firstname.lastname@example.org). Here ‘email@example.com’ is the user name of Member1 to log into the Dashboard.
How can I get the user name(firstname.lastname@example.org) and apply the same as a filter condition in my query.
Suggesting work around also would be great help.
Thanks in advance,