• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 25 subscribers
  • Views 305 views
  • Users 0 members are here
Options
Related
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.

Custom Report - How to Add Report to Quick Query Option

darichar

# To add commands to the Drop-down list in Ignite > Options > Database Query Tool

#

# Edit the quickquery.properties file located in the directory below:

#

# -- C:\Program Files\Confio\Ignite PI\iwc\tomcat\webapps\iwc\WEB-INF\classes\resources

#

# Add one or more of the custom stored procedures listed below to the quickquery.properties file

#

# Stop and Start the Ignite PI Serivce

#

#---- List of Custom Stored Procedure commands ------

Rpt_TopNewSQL=EXEC TopNewSQL '2008-12-28 00:00',WT10A_DEMO'

Rpt_AvgWaitPerExec=EXEC AvgWaitPerExec '2008-12-23 00:00','2008-12-30 00:00','WT10A_DEMO','JGREPO'

Rpt_TopSQLAllDatabases=EXEC TopSQLAllDatabases '2008-12-29 00:00','2008-12-31 00:00'

Rpt_TopSQLByExecs=EXEC TopSQLByExecs '2008-12-23 00:00','2008-12-30 23:59','WT10A_DEMO'

Rpt_TopSQLforDBUser=EXEC TopSQLforDBUser '2008-12-23 00:00','2008-12-30 00:00','custdb','jgrepo2'

Rpt_TopSQLforProgram=EXEC TopSQLforProgram '2008-12-13 12:00', '2008-12-24 12:00', 'WT10A_DEMO', 'sqlplus.exe'

  • 0

    Hi !

    I need to add new report type into drop-down list in Ignite  Report>Report Type.

    My guess is that a need to do several steps:

    1) create stored procedure in ms-sql

    2) update quickquery.properties file and add new report types there ( like in your example)

    Should it work that way?

    And one more question:

    My quickquery.properties doesn't have any Custom Stored Procedure commands , where the the system reports are stored then?

    Thank you for your time

  • 0

    This won't actually add the report to the drop down options under reports. This will only add to to the Database Query Tool under options -> Support tab...

    There's no way to add a report to the drop down under reports as that's referenced in source code. Sorry about that.

    My recommendation is to submit a feature request to get your report added to the product.

    Custom reports are really just queries directly against the repository.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.