The issue im running into is that I keep getting duplication in the report instead of something simple
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.
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.