I make a lot of custom SQL reports now that the Web Report Designer allows me to publish them with more style than before. However, I am not able to get the nice automatic Node Details links to appear for each returned Node. I looked at several .OrionReport files and these all appear to have some complex XML formatting to handle the URL. Thing is, the Custom Table editor has a "Display Setting" for "Display Page Link", but I keep getting the following error...
URL - 'Details Page Link' data presenter requires 'db|DetailsUrl' field(s) to be present within the datasource
What should I query and how should I format it to get this column to do what was available in the original Report Writer?
Solved! Go to Solution.
getting warmer - I was able to get yours to work with
,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) as 'DetailsURL'
Then when you select columns skip the detailsurl or you can hide it - add Details Page Link display setting to your caption column and it should no longer complain since it finds a detailsURL column to pull from. LMK
worked like a champ for me too for apps...specifically SSL Cert check apps...
,'/Orion/APM/ApplicationDetails.aspx?NetObject=AA:'+CAST(a.id as varchar(32)) as 'DetailsURL'
That got it. So i was close with my concatenated URL string, i just included the HTTPS which was unneeded.
So now i have basically rewritten the EOC Alerts page to include all relevant custom properties and alert ages.
Correct. I have all three of my Orion NPM/SAM instances connected as Linked Servers to my main instance. From there i can use UNION ALL to query all of them at once for the same alert age/custom properties information and display it in a single report which I then embed on a custom view on the EOC page.
Here is a pic of the final report. Each of the Contact column are pulling from the specific custom property table for the affected object (based on its ObjectType listing in the AlertStatus table).
Detroiter - Please share how you are embedding these reports so they fill out the Custom HTML resource. I'm using <iframe src="https://website name></iframe> and it doesn't come close to filling the resource. I also get the website banner etc. Anyway to remove this so I only see the report contents? Thanks!
rsprism, I just spotted this reply, sorry for the delay.
I use iFrames inside of custom HTML resources. Here is what i have that works for IE and other browsers since they handle iFrames differently. Gives it a nice big window to work with.
<object width = "100%" height = "400" classid="clsid:25336920-03F9-11CF-8FD0-00AA00686F13" data="https://OrionInstance.com/Orion/Report.aspx?ReportID=340&Printable=TRUE">
<!--[if !IE]> <-->
<iframe src="https://OrionInstance.com/Orion/Report.aspx?ReportID=340&Printable=TRUE" width="100%" height="4000"></iframe>
Excellent - what about adding the instance name? , 'SolarwindsServerA' AS [Instance] …etc
Then you could group by instance if needed.
I just wish my version of EOC supported full SWQL custom resource...
Well the more tables that are drawn from, the longer the report takes to generate. Since i cannot create indexes on linked servers, there is not much I can do to optimize the query. But since time is the driving factor, presorting on "Trigger Time Stamp" makes the most since.
I fully agree that the EOC is lagging behind the other products. I previously had 4 nice reports that were separated out in nodes, Volumes, Application and hardware alerts, but because SAM custom properties are still unavailable in the EOC database, i had to come up with something else. hence the rewriting of the alert page.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.