• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 25 subscribers
  • Views 455 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.

How to combine two reports into one?

mark_s

We have a report that tracks waits for a particular stored procedure. We made some improvement to this procedure, after that DPA changed it hash number, that's obvious. But I had to build another report for it. How can I combine these two reports into one, because it is essentially the same stored procedure?

Thanks

  • 0

    When you say you have a report are you talking some customer SQL ? Care to post what  you are using or some code ? We can help is we can see an example better.

  • 0 in reply to jaminsql

    Yes, this is custom report. Actually two reports.

    Report 1. SQL name: index_physical_stats. Procedure: XXXXXX.MaintainIndexes. Hash: 6072615178. But hash number does not tell you anything, unless you can convert it back to an actual statement. We built a report for largest waits from Jun 1 to Jul 31. But the last bar displayed at Jul 27. That's right. Because about at that day we made some changes.

    Report 2. Does not have an assigned name. Procedure: XXXXXX.MaintainIndexes. Hash: 6094779685. If I build a custom report on it, it shows bars starting from Jul 27.

    Now, these two reports have different vertical scale (Hours, minutes), and I need to open two windows to compare them, to estimate the difference of wait times before and after the change (as well as to email it to my teammates).

    It would be nice if I can create just one report for them.

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.