Open for Voting

Need Custom SQL Chart on Node Details view

Hello,

Can We have custom chart on Node Details view with Use  current Network Object as Data Source.

I have created some custom chart with SQL queries, which show CPU utilization for production hours(08.00am to 08.00pm), for After hours utilization(08.00pm to 08.00am).

similar for Memory Utilization, Network Utilization.

I want to show this graph in Node Details view for every Node. But there is no option to select custom chart with sql.

These graphs are very useful for Big organisations for capacity study.

Please add this option or if already available please let me know.

Capture.JPG

Capture.JPG

  • Hey folks, I found a method that works to show the Time Column option when using a SWQL query within the Custom Chart resource on a Node Details View.

    The process is a little arcane, but it works for me reliably. YMMV. I am on Orion 2015.1.3

    Here are the steps:

    • Create a new Custom Chart resource. Edit the resource.
    • Uncheck  the option to Use current network object as Data Source. Click submit.
    • Edit the Custom Chart resource again.
    • Click Select Datasource, Select the dropdown menu, Advanced Database Query, and past in your SWQL/SQL query. I have only tested this with a SWQL query.
    • Click Preview Resource, then close out of the preview pane.
    • Assign the Object ID and Caption columns
    • Click Submit
    • Click to edit the Custom Chart resource again.
    • Add the Data Series
    • You should now be able to select a Time Column for the data series.

    Hope this helps.

  • I don't think you can do "SELECT ${fromtimeutc}".  I've only seen the ${fromtimeutc} macro used in the WHERE clause, never in a SELECT statement.  I wouldn't think it matters, but it probably does.  Plus, it doesn't really make sense to select the ${fromtimeutc} variable, since what the Custom Chart is looking for as a time column is the Timestamp/Datetime field from whatever stats table you are pulling data from. 

    In your example you are pulling data from the APM_CurrentComponentStatus table, so you would want to do: "SELECT TimeStamp" instead of "SELECT ${fromtimeutc}.  Then, in your WHERE clause you would put "WHERE TimeStamp >= ${fromtime} AND TimeStamp <= {totime} (if you really want to do UTC then you would need to convert your TimeStamp to UTC because unless your server is in UTC time the SQL data is in whatever the local time for your SQL server is set to.  Then use the ${fromtimeutc} and ${totimeutc} macros.).

    Finally, I don't know if capatilization matters, but I know in many of their macros it does, so maybe you need to do ${fromtimeutc} instead, as I have never used it with capital letters.

  • I've tried countless options.  I cannot get this to pull a time column when doing a custom SQL chart.  Even adding the macros does no good.  This same report pulls in a custom table...

    Select  ${FromTimeUTC} AS Time,

    APM_Component.Name,

    SUM(APM_CurrentComponentStatus.InstanceCount) AS 'Count'

    FROM APM_ComponentTemplate

    FULL JOIN APM_Component

    ON APM_ComponentTemplate.ID = APM_Component.TemplateID

    INNER JOIN APM_CurrentComponentStatus

    ON APM_Component.ID = APM_CurrentComponentStatus.ComponentID

    Where APM_ComponentTemplate.ApplicationTemplateID = '285'

    Group By APM_Component.Name

    Any help would be appreciated on how you managed to stop getting the Time column missing bug.

  • I'm trying to get a historical count of processes underneath a head Citrix Application Monitor.  My Query is:

    Select APM_ComponentTemplate.Name, SUM(APM_CurrentComponentStatus.InstanceCount) AS 'Count',

    MAX(APM_CurrentComponentStatus.TimeStamp) as 'datetime'

    FROM APM_ComponentTemplate

    FULL JOIN APM_Component

    ON APM_ComponentTemplate.ID = APM_Component.TemplateID

    INNER JOIN APM_CurrentComponentStatus

    ON APM_Component.ID = APM_CurrentComponentStatus.ComponentID

    Where APM_ComponentTemplate.ApplicationTemplateID = '285'

    Group By APM_ComponentTemplate.Name

    Even though I use a time field from a current table, I have no option to select my Time column when creating a custom chart.  Any help?  Did you guys figure out how to fix this?