Hello i need to create a custom widget that contains a query that must retrieve a table with all the alerts filtered by department
Thanks in advance
I would put the department into a custom property, maybe on the node, and use that to filter. (+) THWACK Tuesday Tip :: How to Use Custom Properties to Filter a Widget - Community Announcements - Resources - THWACK (solarwinds.com)
how are you identifying the department?
Some great starting points for your source SWQL query in the modern dashboards content exchange. Below is a link to a great on that has a good alert SWQL query for use in a modern dash.
Assuming you track your Department in a custom property you could filter all of it with said custom property. The source SWQL (since its SWQL) can be used in a custom query widget with minor adjustments for asthetics.
thwack.solarwinds.com/.../2884