Forum Discussion

Andy_Domeier's avatar
Andy_Domeier
11 years ago

Standard Database SQL Variables

Hi,

Within our architecture we have a lot of important real-time information in our databases. A lot of times we are doing \'\'counts\'\' of specific processes or rows. It\'s difficult to ensure we are collecting all the data since the last run of a datapoint for a few reasons. It would be really valuable to be able to have Logic Monitor maintain a time variable on a datapoint so that we can collect data \'\'since the last run\'\'. That would give us a more accurate picture than running a query for the previous 10 minutes, and hoping it runs exactly every 10 minutes.

Thanks!!!

  • Steve_Francis's avatar
    Steve_Francis
    Former Employee
    11 years ago

    Instead of doing count(rows added in last 10 minutes), would it work to just do count(rows), and define the datapoint as a derive?rnThis will then calculate the difference in rows from last run to this run - regardless of how regular the runs are scheduled. The downside is that a derive datapoint will also convert the result to a rate per second. (Which may not be what you want - but you could convert it to Number per minute, or something)

  • Andy_Domeier's avatar
    Andy_Domeier
    11 years ago

    Hey Steve,rn I will look into that further. I dont think thats going to quite get us what we need but I will circle back with my team members that are smarter than me to see if they can make that work :)rn rnThanks for your response!