DX Infrastructure Manager

Expand all | Collapse all

Show result of SQL query in UMP Dashboard?

Jump to Best Answer
  • 1.  Show result of SQL query in UMP Dashboard?

    Posted 09-16-2015 07:15 AM

    Hi everybody,

     

    I like to show results of some SQL queries in one dashboard. The SQL query fetches one row with one value (e.g. select count(*) from TABLE where-clause).

    Can I push the result in the Text widget? If I add the SQL query to Text widget the Text widget remains empty, only a tooltip hover up "Last Value: <result> with DateTimeStamp".

    I'd like to see it like this: "Number of dead sessions: <Result-of-SQL-query>".

     

    Is this possible - maybe using of a variable/parameter?

     

    -Olaf



  • 2.  Re: Show result of SQL query in UMP Dashboard?
    Best Answer

    Posted 09-16-2015 12:06 PM

    What version of UIM are you using? I think it was 8.1 that introduced a SQL Table Widget that will display the results of your query. If you assign the SQL Query Data Source to the Text Widget, you will need to type $VAR into the text box of the text widget. That will display the value. Or you can enter in the text box "Number of dead sessions: $VAR." and that will work to.



  • 3.  Re: Show result of SQL query in UMP Dashboard?

    Posted 09-16-2015 03:13 PM

    I'm using UIM 8.2.

    And yes, that's exactly what I need.

    I read the dashboard docs on wiki more than once but I never found a hint. But just when I have read again (after your reply) I found the hint for $VAR.

     

    Thanks a lot