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>
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'
Use the DetailsURL as sugested in this thread I can generate the column with the URL without issue, however, when I actually apply the detail link to done of the columns I recieve and error. The details of the error are as follows.
Anyone have any ideas on how to get this working for me?
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.
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.