Orion Charts to Display Non-Orion Data

Question

Question:

Is there any way to feed XML or SQL Data to a custom .resource in Orion to have the Orion Charting engine diplay the custom data.

I.e., in Orion I want to display a gauge displaying the number of open work orders for a given group in one of my areas. I already have created a custom .resource that gets this data from another database and display the tabular data. Now I want to show the data in a visual format.

Any ideas?

Thanks

eskiff · Answer

I followed the steps from your original post (in the readme) and made it up to the point of editing the resource - I don't see Yahoo-NetPerfMon.Charts as a selection under the "Select a Chart" pull down.  What did I miss?  Where am I supposed to put the .Chart file when using v8?

Jemini · Answer

And I found out that the yahoo.chart has a shortcome that only suit for interfaces with same bandwidth if you want to that chart tell the total utilization.
Maybe it's so hard to tell the correct values for a range of interfaces with different bandwidth. My solution is give up utilization, choose traffic instead,here is an example  sql statement:SELECT
					Datetime,
					SUM(avginbps) as InPercentUtil,
					SUM(avgoutbps) as OutPercentUtil
				FROM 
					(
						SELECT 
							Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, 
							avg([IN_Maxbps])/1000000 as avginbps,
							avg([OUT_Maxbps])/1000000 as avgoutbps,
							interfaces.interfaceid as interfaceid,
							interfaces.outbandwidth as bandwidth
						FROM 
							InterfaceTraffic INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID
						WHERE 
							Interfaces.interfaceid in (826,895,1407,2078,1310,473)
							And interfaces.adminstatus * interfaces.OperStatus = 1 
							And interfaces.operational = 1
							And DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} 
						GROUP BY 
							Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0),
							interfaces.interfaceid,
							interfaces.outbandwidth
					)
					as avg_table INNER JOIN Interfaces ON Interfaces.Interfaceid = avg_table.interfaceid
				GROUP BY 
					Datetime

Jemini · Answer

quote:Originally posted by lucastquote:Originally posted by Jemini you may search "yahoo chart" in this forum which tells a limited way to customize the chart: the unit in x-axial and y-axial,the color of graph and titles, but the data should be queried from the database using SQL. Thanks. Unfortunately the Yahoo chart example zip URL is no longer valid so I have been unable to see those referenced examples. Thanks for the idea though. aha~it's time to share sth for you.Here comes the content of this key file :yahoo.chart(file ext is "chart") which you can rename it but keep the ext such as jemini1.chart,jemini2.chart as so on as follows: quote:readme.txt Orion NetPerfMon Chart Extensions - Yahoo Internet Consolidation SolarWinds Development October 18, 2004 These charts can be used to show traffic for a group of interfaces combined. They are typically used to show the total bytes transferred over aggregated Internet links. Unzip this file and place the Yahoo-NetPerfMon.Charts in your "Program Files\SolarWinds\Network Performance Monitor V7" directory. You will then need to add a custom property named "Service" to "Interfaces" using the Custom Property Editor. Set the "Service" property for each interface you would like included in the chart to "Internet". Now let's add a couple of charts to a Summary View. Login to your Orion web site as "Admin". Select "Admin" from the top menu and then select "Custom Views" from the Admin menu on the left. Select any view and click "edit". Add the "Custom Network Wide Chart" resource from the "Network Wide Summary Charts" group. Preview the view and scroll down to the newly added resource. Edit the resource (select the "Click Here" text or the edit icon in the upper left corner) Now select one of the new "Yahoo" charts. The chart will display data from each of the interfaces with Service=Internet combined on a single chart. quote: YahooAvgUtil Summary Yahoo - Network Wide Percent Utilization SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, Avg([In_Averagebps]/[inBandwidth]*100) AS InPercentUtil, Avg([Out_Averagebps]/[OutBandwidth]*100) AS OutPercentUtil FROM (InterfaceTraffic INNER JOIN Nodes ON InterfaceTraffic.NodeID = Nodes.NodeID) INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID WHERE (Interfaces.InBandwidth>0) AND (Interfaces.OutBandwidth>0) AND Interfaces.Service='Internet' And DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) Order By DateTime Interfaces.Service='Internet' Internet Percent Utilization Percent Utilization on Internet Interfaces ${Period} Bar % 0 0 InterfaceTraffic No Step % packet loss Both 0 102 &H000000FF& ||% Both 0 100 | ,| % Receive Utilization InPercentUtil &H00FF8080& 2 Medium Avg Receive Transmit Utilization OutPercentUtil &H00008000& 7 Medium Avg Transmit YahooTotalXmitBytes Summary Yahoo - Total Bytes Transmitted over Internet Connections Total Bytes Transmitted over Internet Connections Traffic on Internet Interfaces ${SampleSize} ${Period} SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, Sum([Out_TotalBytes]) AS TotalBytes FROM (InterfaceTraffic INNER JOIN Nodes ON InterfaceTraffic.NodeID = Nodes.NodeID) INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID Where DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} And Interfaces.Service='Internet' GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) Order By DateTime Interfaces.Service='Internet' Bar .75 Line bytes 0 0 InterfaceTraffic Yes MinMaxAverage2 % packet loss Both 0 102 &H000000FF& ||% Min 0 50 | ,| bytes Total Bytes TotalBytes &H00008000& 2 Medium Total Transmit YahooTotalRecvBytes Summary Yahoo - Total Bytes Received over Internet Connections Total Bytes Received over Internet Connections Traffic on Internet Interfaces ${SampleSize} ${Period} SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, Sum([In_TotalBytes]) AS TotalBytes FROM (InterfaceTraffic INNER JOIN Nodes ON InterfaceTraffic.NodeID = Nodes.NodeID) INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID Where DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} And Interfaces.Service='Internet' GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) Order By DateTime Interfaces.Service='Internet' Bar .75 Line bytes 0 0 InterfaceTraffic Yes MinMaxAverage2 % packet loss Both 0 102 &H000000FF& ||% Min 0 50 | ,| bytes Total Bytes TotalBytes &H00FF8080& 2 Medium Total Receive YahooTotalBytes Summary Yahoo - Total Bytes Transfered over Internet Connections Total Bytes Transfered over Internet Connections Traffic on Internet Interfaces ${SampleSize} ${Period} SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, Sum([Out_TotalBytes]) AS Out_TotalBytes, Sum([In_TotalBytes]) AS In_TotalBytes FROM (InterfaceTraffic INNER JOIN Nodes ON InterfaceTraffic.NodeID = Nodes.NodeID) INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID Where DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} And Interfaces.Service='Internet' GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) Order By DateTime Interfaces.Service='Internet' Step .75 Step bytes 0 0 InterfaceTraffic Yes MinMaxAverage2 % packet loss Both 0 102 &H000000FF& ||% Min 0 50 | ,| bytes Bytes Received In_TotalBytes &H00FF8080& 2 Thin Total Receive Bytes Transmited Out_TotalBytes &H00008000& 7 Thin Total Transmit YahooTotalBytesCombined Summary Yahoo - Total Bytes Transfered (Xmit+Recv) over Internet Connections Total Bytes Transfered (Xmit+Recv) over Internet Connections Traffic on Internet Interfaces ${SampleSize} ${Period} SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime, Sum([In_TotalBytes]+[Out_TotalBytes]) AS TotalBytes FROM (InterfaceTraffic INNER JOIN Nodes ON InterfaceTraffic.NodeID = Nodes.NodeID) INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID Where DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd} And Interfaces.Service='Internet' GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) Order By DateTime Interfaces.Service='Internet' Bar .75 Line bytes 0 0 InterfaceTraffic Yes MinMaxAverage2 % packet loss Both 0 102 &H000000FF& ||% Min 0 50 | ,| bytes Total Bytes TotalBytes &HFF0000& 2 Medium Total Receive