1 Reply Latest reply on Aug 14, 2018 12:53 PM by cmblackburn

    Widget Filters

    cmblackburn

      Hey Thwacksters

       

      Where does the widget filter info live in the database?  I'm trying to find any widgets that I'm using a custom property to filter on or maybe there is some kinda of report to run? 

       

      Here is a pic just in case I didn't explain well:

       

       

      Thanks all for the help!!!

        • Re: Widget Filters
          cmblackburn

          To anyone else who'd like to know this info:

           

          SELECT c.ViewGroup,c.ViewTitle,a.[ResourceID]

                ,[PropertyName]

                ,[PropertyValue]

            FROM [SolarWindsOrion].[dbo].[ResourceProperties] a

            join SolarWindsOrion.dbo.Resources b on a.resourceid = b.resourceid

            join SolarWindsOrion.dbo.Views c on b.viewid = c.viewid

            where PropertyValue like 'Nodes.Custom%'