Splunk Search

Why is this search returning the wrong result?

Lavani
Observer

The search query it showing only the roles for currently logged-in user. But this is not what we are looking for, we need list of users with logmon_app* roles.

| rest /services/authorization/roles/ 
| search title="logmon_app*" | table title 
| rename title as roles
| join type=left role max=0 
    [| rest /services/authentication/users 
    | table roles title 
    | rename title as userName 
    | mvexpand roles | search roles="logmon_app*" ] 
| stats values(userName) as username by roles |eval rolepresent="yes"

 

Labels (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You could try with

| rest /servicesNS/-/-/authorization/roles/ 

| rest /servicesNS/-/-/authentication/users 

although I can't guarantee it will work

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

this could be a little bit tricky when user/role have some inherited roles which could also contains some other inherited roles etc...

One way to solve this is use e.g. this app https://splunkbase.splunk.com/app/4111 and then modify those queries to solve your issues, if that didn't already solved it.

r. Ismo

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...