Can NPM poll the NPM SQL database to return the value of a field?

Question

Maybe some of you SQL guys out there will know how to do this.  Is there a way to have NPM poll a specific field within a table in the SQL database and return the value that can then be put into a historical chart?

I'd like to have the polling completion values charted so I can see trends.  I check it every once and a while and usually it is ~99.3.  But occasionally it is under 98 so I'd like to find out if there is some type of commonality on this, how often it happens, and when it does, how long it is lasting.  If I could poll the DB every minute and return the value, I could see this pretty readily.

Thanks,

Michael

michael248363 · Answer

But I don't have APM.  That is why I was wondering if NPM could do it.

Does anybody know of a way to do it with only NPM?

Michael

lag · Answer

It can if you have the APM module. You would need to add a SQL UX, then write the query to select polling completion from engines...