Implemented

https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-proportional-widgets.htm

Create Custom Pie Charts

We would like to be able to display custom pie charts. For example, show the status of all my servers with custom property of 'critical' in a pie chart with a standard red/yellow/green code. Or all equipment with custom property 'exchange', etc.

  • also changed the 1,2 .39 to 1,2,3,9 still no joy.

  • Hi!, I am a bit late to the game but I have a custom property called CloudTeamDevices with the value of Yes, I've  tried to add this in with the AND with and without brackets including using the code you have placed above but I never get any results on the widgets. 

    var swql = "Select Count (n.status) AS Cnt, s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON (n.Status = s.StatusID AND Node.CustomProperties.CloudTeamDevices = 'Yes' ) WHERE or s.StatusID IN (1,2 , 3.9) GROUP By n.Status, s.StatusName, s.StatusId ORDER By s.statusID ASC "

    That is what I have currently and have tried the below.

    var swql = "Select Count (n.status) AS Cnt, s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON (n.Status = s.StatusID AND n.CloudTeamDevices = 'Yes' ) WHERE or s.StatusID IN (1,2 , 3.9) GROUP By n.Status, s.StatusName, s.StatusId ORDER By s.statusID ASC "

    and also tried the below variant.

    var swql = "Select Count (n.status) AS Cnt, s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON (n.Status = s.StatusID AND nodes.CloudTeamDevices = 'Yes' ) WHERE or s.StatusID IN (1,2 , 3.9) GROUP By n.Status, s.StatusName, s.StatusId ORDER By s.statusID ASC "

    Any idea where I am going wrong?

  • Can you give step by step guide??

  • Hello

    Can any one share script for capacity planning in pie chart. in which i want to show how many machine are in warning state, Critical and at capacity. and at bottom total no of machine

    thanks

    Sumit Goel