This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Variable to Enabled of disabled a report

Hi Solarwind

I'm pretty new to Solarwind and I'm french so I'll do my best :)

Is it possible to add a variable (Enabled/Disabled) to list all Active Dashbaord in the same page.

For now we need to create an html page with the link of all the reports but nothing's dynamic.

It could also be an hidden field if we HAVE to

Parents
  • Thanks for joining and asking a question!   Are you trying to build a dashboard?  Or are you trying to enable/disable reports?

    It would be helpful if you included a screenshot with any edits you'd like.  We can probably help.  Also, if it's easier to write in French, you might want to ask the question in the EMEA Group.  There may be other native French speakers there who can assist.

  • Hi

    Thanks for getting back at me Slight smile

    We have a Dashboard with a list of all of our Dashboard.

    If a report became obsolete we need to edit this report and take out the html link.

    What we need is a way to disable a dashboard so the list can be update dynamically instead of manually.

    So I need to add a variable or an hidden field to indicate if the report or dashboard is still use or enable.

    Thanks for the EMEA Group. I'll go check it out!

    Have a nice day

  • I would do it this way:

    Define a custom property for reports called IsDisabled (or something that makes sense in your environment).

    Then I chose a report at random and flipped this value to true so I could test.

    Then you can update your dashboard with a custom query widget and use the below to show only those where IsDisabled is false.

    SELECT [Reports].Category
         , [Reports].Name
         , CONCAT('/Orion/Report.aspx?ReportID=', [Reports].ReportID) AS [_LinkFor_Name]
         , CASE
             WHEN [Reports].LastRenderDuration IS NULL THEN 'Not executed'
             WHEN [Reports].LastRenderDuration = 1 THEN '1 second'
             ELSE CONCAT([Reports].LastRenderDuration, ' seconds')
           END AS [Execution Time] -- this is just for fun
    FROM Orion.Report AS [Reports]
    WHERE [Reports].CustomProperties.IsDisabled = 'FALSE' -- This is your custom property
    ORDER BY [Reports].Category, [Reports].Name

    This is an example:

    You can filter or sort any way or add a search to the Custom Query widget if you like.  This is just a simple example with some fields I think are important.

  • Wow!

    Great Thinking Slight smile

    It's working like I want but only for a report. I'll go further on my investigation but for now it's perfect.

    Thanks for your time, really appreciated

Reply Children
No Data