janis.griffin

Comments

  • This will be a great feature to have. But for now, there are several ways to filter certain sql statements out of your view. When drilling into a day on the trend screen of DPA, you can select the 'interval' drop down box and select a 1 day interval so you have one 24 hour bar. After you have rolled it up to the day…
    in Allow users the ability to filter queries from main trend view Comment by janis.griffin October 2014
  • To run the query listed, you will need to log in as the DPA monitoring user. If you have admin rights in the DPA application, you should be able to connect to that account via Options > Support > Database Query Tool. If you don't know the password, you'll need to ask the DBA (who knows it) to run the query under this user.…
    in stats collection stopped Comment by janis.griffin June 2016
  • A couple of things to check after the upgrade... 1. Make sure the monitoring tables are still there and accessible. If not, you may need to drop / recreate them. 2. Make sure DPA has access to them by manually running the following query: SELECT auth_id igniteex , stmt_start , stmt_type , CAST(stmt_text AS BLOB)…
    in stats collection stopped Comment by janis.griffin June 2016
  • Hey Dustin, I'm so glad to hear you are back in the family! Here's wishing you the best at your new position... Janis
    in Mission Accomplished! Comment by janis.griffin June 2015
  • It sounds like you are trying to use the DB2 template for SAM. Unfortunately, that template uses only the ODBC driver. However, there is nothing stopping you from creating a custom template that would allow you to issue that query using DBD::DB2 using perl. 
    in Solarwinds ODBC Comment by janis.griffin May 2017
Avatar