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.

Idea for a report - if you are interested in helping me!

 , (or anyone for that matter),

I'm looking for a good way to create a high level availability report BUT also have a link to a lower level report on that same line. Any ideas on ways to do that? If you look at my below (crude) example, what I want is similar. I just want a link to a very detailed report that breaks the higher level report down to its subgroup components. More info: so, if you had a group representing an entire business area (Testme), but that group had 15 applications under it, I'd want to have a report I could click on to show me which apps, if any, were the reason for a lower than acceptable availability percentage.

daveb7114_0-1590076860596.png

Any help would be appreciated. Cant believe there's not a way to put a configurable (and clickable) link in here thats not the details URL!!!

Dave Burton

Eli Lilly and Company

  • Hi!

    You should be able to pop the html in there. I borrowed a SQL example from our friend  that was written for SQL and converted to SWQL. You are definitely going to need to play around with the logic of your query to get the different reports pulled in (maybe a custom property with the report urls?) but it should be possible.

    This works: 

    Select Nodes.MachineType, CONCAT('<img src="/NetPerfMon/Images/Vendors/',Nodes.VendorIcon,'"></>','<a href="',Nodes.Vendor ,'">thwack.solarwinds.com/.../View.aspx - ',Nodes.MachineType,'</>') AS v from Orion.Nodes

    borrowed from this post: https://thwack.solarwinds.com/t5/NPM-Documents/Node-Details-SQL/ta-p/512112

    Hope this helps in some way! If you provide more details, I am sure someone in this wonderful community can help out.

    **Reply was edited because I ended up having to break the hyperlink here to show you the full text in the query.

  • May I just clarify/reply if I understood it correctly:

    1. You have a group
    2. This group has member nodes (say 100 nodes)
    3. You want availability report overall (across all 100 nodes)
    4. You want to be able to easily access break-down to see exactly which of those 100 has screwed your availability

    Is this right?