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.

Need to create a "Status Page" on Companies intranet showing Server Status/Availability grouped by Application

The issue im running into is that I keep getting duplication in the report instead of something simple

pastedImage_0.png

  • Is this a custom query that you've written or are you just using the query builder? It seems like if you only want the latest status you can select max(timestamp) or just removing that field should get you the single rows.

    Either way, knowing more about how you built the report and what you're trying to display will help us help you.