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'
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!
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,
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)
Unfortunately, I don't know how to add the OrionID (37). Would appreciate anyone that can show me how this is done. Thanks much!
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?
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.
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>
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.