Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Node Details URL in custom SQL Report

Jump to solution

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?

Tags (1)
1 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

View solution in original post

29 Replies

This helped for me as well !!

Thanks  bluefunelemental​ and all the other contributers..

0 Kudos

worked like a champ for me too for apps...specifically SSL Cert check apps...

,'/Orion/APM/ApplicationDetails.aspx?NetObject=AA:'+CAST( as varchar(32)) as 'DetailsURL'

0 Kudos

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.

0 Kudos

So where are you entering these in EOC? A report and then embedded on a page?

0 Kudos

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!

0 Kudos

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.

<!--[if IE]>

<object width = "100%" height = "400" classid="clsid:25336920-03F9-11CF-8FD0-00AA00686F13" data="">

    <p>backup content</p>



<!--[if !IE]> <-->

<iframe src="" width="100%" height="4000"></iframe>

<!--> <![endif]-->

0 Kudos

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...

0 Kudos

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. 

0 Kudos