DX Infrastructure Manager

Expand all | Collapse all

Scripting performance report designer layouts

  • 1.  Scripting performance report designer layouts

    Posted 10-15-2012 03:06 PM

    Hi all,

     

    I am hoping to save some poor soul from dragging and dropping thousands of QOS objects onto graphs in the PRD. It seems that it will take about 20 minutes manual effort per device, just to get basic interface, CPU, session and memory info set up.

     

    Having a look at the XML created on export, it would appear fairly easy to create these on the fly and import them in.

     

    <State ver="200">
      <title>Device title</title>
      <TimeStart>1345209973610</TimeStart>
      <TimeStop>1350302052210</TimeStop>
      <liveData>true</liveData>
      <lastPeriod>NaN</lastPeriod>
      <TimeSliders>2,15,0,13</TimeSliders>
      <GraphMaximized>-1</GraphMaximized>
      <groups>
        <group>
          <groupName></groupName>
          <filterId>f1345213573629</filterId>
          <rowSelectors>
            <rowSelector>
              <logical>and</logical>
              <not>false</not>
              <attribute>source</attribute>
              <operator>is</operator>
              <value></value>
            </rowSelector>
          </rowSelectors>
        </group>
      </groups>
      <selectedPage>0</selectedPage>
      <page>
        <row>
          <chart>
            <stacked>false</stacked>
            <showLegend>true</showLegend>
            <legend>
              <last>true</last>
              <max>true</max>
              <average>true</average>
              <percentile>true</percentile>
              <stdDev>false</stdDev>
            </legend>
            <title>HA</title>
            <infoText/>
            <series>
              <r_table>RN_QOS_DATA_0125</r_table>
              <table_id>117889</table_id>
              <unit>B/s</unit>
              <unit_short>B/s</unit_short>
              <displayName>172.23.205.36|QOS_INTERFACE_TRAFFIC|IN-ethernet0/0</displayName>
              <graphColor>32768</graphColor>
              <style>line</style>
              <scale>1</scale>
              <pLine>
                <active>false</active>
                <percentile>95</percentile>
              </pLine>
            </series>
            <series>
              <r_table>RN_QOS_DATA_0125</r_table>
              <table_id>117890</table_id>
              <unit>B/s</unit>
              <unit_short>B/s</unit_short>
              <displayName>172.23.205.36|QOS_INTERFACE_TRAFFIC|OUT-ethernet0/0</displayName>
              <graphColor>8388608</graphColor>
              <style>line</style>
              <scale>1</scale>
              <pLine>
                <active>false</active>
                <percentile>95</percentile>
              </pLine>
            </series>
          </chart>

     

    Each row and chart looks to just have a reference to a table_ID which shouldn't be too hard to pick out, give a name and write to a file.

     

    The only fields that concern me, because they may be unique are

    <TimeStart>1345209973610</TimeStart>
      <TimeStop>1350302052210</TimeStop>

    <filterId>f1345213573629</filterId>


    Does anyone know what these mean? Am I likely to break everything by starting to import malformed XML? Should I approach it from the database side instead?

     

    thanks

    Paul



  • 2.  Re: Scripting performance report designer layouts

    Posted 10-15-2012 06:39 PM

    I tried modiying the DisplayName on some of my PRD's from within the DB and it loads it but throws an error and changing displayname breaks all the hover info in the graph. Those time values almost seemed like UNIX Time stamps but i looked them up and it couldn't be as they show for year 2396! I have been wanting more configurations for these PRD's for some time. We need the ability to bulk load stuff, changes display names, make containers of QOS and drill ins etc..



  • 3.  Re: Scripting performance report designer layouts

    Posted 10-23-2012 06:38 PM

    the time start and end I am going to assume by looking at it is the epoch time best way to determine is check the value you have against it and see what comes back from it.  I just ran it at this site and it shows the date as august 17th to oct 15th.  The site I used was 

    http://www.esqsoft.com/javascript_examples/date-to-epoch.htm