Azure workbook question

AdamBudzinskiAZA-0329 91 Reputation points
2024-06-10T15:02:04.0033333+00:00

hi,

I've created a KQL query to basically provide means to audit group membership changes. Exported to a csv the name of each security group and its managedBy attributes and using it inside the query as external data. Then joining with SecurityEvent table, so that I get a view like this:

User's image

Added the query to a Azure Workbook, but now wondering how can I have a picker/dropdown menu of some sorts, that for example would allow me to pick any given user name from the  ManagedBy column so that responsible for any of their groups could review the changes. Is this duable, so that Azure somehow magically ingest the data and provide as a selectable option?

 

Thanks !

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,960 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 20,475 Reputation points
    2024-06-30T04:49:37.5733333+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    You can make it static or dynamic based on following article

    https://video2.skills-academy.com/en-us/azure/azure-monitor/visualize/workbooks-dropdowns

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

    0 comments