Hi.
I have been looking, but not found a Resource that shows me node status as a pie Chart. Is this available?
You have a nice pice chart for APM status.
BUMP!
I really would like to have a Pie chart on my status page showing all nodes online/offline/unmanaged.
Is this something that exist or could be created?
ooh, reading your post, i would like to be able to have a single page that allowed me to have what you have asked, but allow me to limit each pie chart resource by custom property, so i could have one pie chart for each customer, showing an overall management dashboard...
too funny as I was just wondering if this was possible!
I like the idea of having two Pie Charts on my Solarwinds home page, 1 for NPM and 1 for APM
This may be obvious... but how do you show node status in a pie chart? Usually pie charts display various parts of some whole. Do you mean if half your nodes are down then half the pie will be red and half green or ????
Not to devalue the feature request but one suggestion is that, if I recall correctly, you can build pie charts via Crystal Reports which then could be exported to *.htm or even linked directly to via the Orion toolbar or a custom link in a resource on the page. This could help you get the view you are looking for right now rather than waiting. I just checked and if you don't have a copy, a license for Crystal Reports 2008 is running $495 (list price on their website). Thanks, Jason HensonLoop1 Systemshttp://www.loop1systems.com/
I would like all nodes as 100% and then show %down, up and unmanaged.
But, with the actual count as labels.
CR or other charting software is a possible way, but since the pie-chart allready is made for APM I would hope that this was an easy task to do.
I might take a look at that component and see if I can change the source.
This has to be live against Orion.
Hi -
Did you ever accomplish this? If so, it would be nice to see your code. I would love to be able to do Node Status or even overall NPM status piecharts.
-mike
I got in touch with support and it seems that they only have 2 pie charts in the whole system.
1. Hardware Health Overview
2. Application Health Overview
Other than this its nearly impossible to create a pie chart. They said they will look into having the feature as an improvement in future versions.
yes I think so.. we need improvent to make easier life
Definitely possible, havnt got to the bottom of it yet but I like the idea. Check here
Steps look to be:
Add custom HTML element
Add HTML+Javascript padding
Create a SWQL format query against your own server
Put the data into a query to Google Charts
Have a look at this Integrate Google Charts with Solarwinds reports/view, A Pie chart example
I reckon that this is what you are looking to achieve, however I couldn't quite get it working in my environment, but didn't really have the time to figure out why.
dunky2kefosshaug
This does it, stick it in a customhtml element:
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<div>
<script>
var swql="SELECT SI.StatusName AS Status, COUNT(Status) AS Total FROM Orion.Nodes N INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status GROUP BY SI.StatusName ORDER BY Total DESC"
var params = JSON.stringify({
query: swql,
parameters: {
}
});
$.ajax({
type: 'POST',
url: '/Orion/Services/Information.asmx/QueryWithParameters',
data: params,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(response) {
var i;
google.charts.load("current", {packages:["corechart"]});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var dataTable = new google.visualization.DataTable();
dataTable.addColumn({ type: 'string', id: 'Status'});
dataTable.addColumn({ type: 'number', id: 'Count' });
for(var i=0; i < response.d.Rows.length; i++){
var row = [response.d.Rows[i][0],response.d.Rows[i][1]];
dataTable.addRow(row);
var chart = new google.visualization.PieChart(document.getElementById('PieStatus'));
var options = {
"title": 'Nodes by Status',
"legend": {position: 'right'},
"tooltip": {trigger: 'selection'},
"chartArea":{left:0,top:0,width:500,height:500},
"colors": ['#77bd2d', '#e61929', '#b4b1b2', '#fcd928']
};
chart.draw(dataTable, options);
})
</script>
<div id="PieStatus" style="width: 500px; height 250px;"></div>
</div>
Perfect !
I"m not trying to sound like a jerk, but, I would spend less time creating a pie chart dashboard and more time getting the devices that are down...up?
