cancel
Showing results for 
Search instead for 
Did you mean: 
njoylif
Level 17

Re: Node Details URL in custom SQL Report

Jump to solution

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'

0 Kudos
rsprim
Level 12

Re: Node Details URL in custom SQL Report

Jump to solution

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
njoylif
Level 17

Re: Node Details URL in custom SQL Report

Jump to solution

you can also use concat...basically you just add the HTML code into the SQL query code

CONCAT('<a href="https://thwack.solarwinds.com/Orion/View.aspx?NetObject=N:',n.nodeid,'">',n.caption,'</a>') as Caption,

rsprim
Level 12

Re: Node Details URL in custom SQL Report

Jump to solution

njoylif,

I'm hoping you can answer this question.  Do you know how to create a DetailsURL for EOC Nodes and Interfaces in SQL or SWQL?  I can't seem to figure it out.

Orion allows you to Cast the NodeID onto the end of the URL but EOC requires the Orion ID in the URL (see below)

Nodes - https://eoc.xxxxxx.com/Orion/37/Orion/View.aspx?NetObject=N:174

Interfaces - https://eoc.xxxxx.com/Orion/37/Orion/View.aspx?NetObject=I:16193

Unfortunately, I don't know how to add the OrionID (37).  Would appreciate anyone that can show me how this is done.  Thanks much!

0 Kudos
njoylif
Level 17

Re: Node Details URL in custom SQL Report

Jump to solution

I think, basically, you'd use concat...see below

CONCAT('https://[your URL]/Orion/',${NodeID},'/Orion/View.aspx?NetObject=N:',${[objectID macro]}) as DetailsURL

0 Kudos
rsprim
Level 12

Re: Node Details URL in custom SQL Report

Jump to solution

Hey njoylif,

I tried that on an EOC SWQL window and it's not working.

0 Kudos

Re: Node Details URL in custom SQL Report

Jump to solution

SWQL does not handle concat but if they are the type of object then a simple + will work.

Example- constructing a SWQL field for node url or such

,'http://yourserverip/Orion/whatever.aspx?N:' + ToString(NodeID) AS

The ToString function will allow the integer node ID to be concatenated with the string you type in, this case the beginning of a URL

Work for you?

0 Kudos
Highlighted
rsprim
Level 12

Re: Node Details URL in custom SQL Report

Jump to solution


bluefunelemental - Thanks for the response but unfortunately EOC SWQL doesn't support ToString functions.  I wish SolarWinds would advise exactly what functions it does support though.  It sure would make things easier.

0 Kudos

Re: Node Details URL in custom SQL Report

Jump to solution
0 Kudos
Detroiter
Level 12

Re: Node Details URL in custom SQL Report

Jump to solution

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="https://OrionInstance.com/Orion/Report.aspx?ReportID=340&Printable=TRUE">

    <p>backup content</p>

</object>

<![endif]-->

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

<iframe src="https://OrionInstance.com/Orion/Report.aspx?ReportID=340&Printable=TRUE" width="100%" height="4000"></iframe>

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

0 Kudos