<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!-- saved from url=(0014)about:internet -->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <meta name="GENERATOR" content="Quadralay WebWorks AutoMap 2003 Platinum Edition Client for FrameMaker 8.6.6597.0" />
    <meta name="TEMPLATEBASE" content="emwebh8-1-17" />
    <meta name="LASTUPDATED" content="08/01/13 14:48:24" />
    <title>Exporting Data Collections in Readable Format </title>
    <!-- Copyright 2010-2013, Cisco Systems, Inc. All rights reserved. -->

    <link rel="StyleSheet" href="document.css" type="text/css" />
    <link rel="StyleSheet" href="catalog.css" type="text/css" />


<script> 
    var is_chrome = navigator.userAgent.toLowerCase().indexOf('chrome') > -1; 
   
    if(is_chrome){document.domain=document.domain}
   </script>
    <script type="text/javascript" language="JavaScript1.2" src="expand.js"></script>
    <script type="text/javascript" language="JavaScript1.2" src="page.js"></script>

    <script type="text/javascript" language="JavaScript1.2">
     <!--
      function  WWNoOp() {}
      function  WWNoValue() { return ""; }

      var  VarDropDown;

      if (typeof(HTMLHelp_Object) != "undefined")
      {
        VarDropDown = new WWDropDown_Object();
      }
      else
      {
        VarDropDown = new Object();
        VarDropDown.fAnchorOpen  = WWNoOp;
        VarDropDown.fAnchorClose = WWNoOp;
        VarDropDown.fDIVOpen  = WWNoOp;
        VarDropDown.fDIVClose = WWNoOp;
      }
     // -->
    </script>

  
<SCRIPT language="javascript">
<!--
  self.document.write("<link href='"+top.relPath+"shared/style.css' rel='stylesheet' type='text/css'>");
  myid=2276;
  self.document.write("<script type='text/javascript' language='JavaScript' src='"+top.relPath+"shared/con_utils.js'></scr"+"ipt>");
//-->
</SCRIPT>
</head>

  <body onload="highlightSearchTerms();" bgcolor="#ffffff">

    
    <blockquote>
    <a name="top"></a>

    
    


<a name="wp1307550"> </a><h1 class="pTitle">
Exporting Data Collections in Readable Format

</h1>
<a name="wp1307551"> </a><p class="pBody">
You can export the RRD files used by Performance Manager to a freeware tool called rrdtool and export 
the collection to an XML file. Cisco MDS SAN-OS Release 2.1(1a) introduces the inability to export 
data collections in comma-separated format (CSV). This format can be imported to various tools, 
including Microsoft Excel. You can export these readable data collections either from the DCNM-SAN 
Web Services menus or in batch mode from the command line on Windows or UNIX. Using 
DCNM-SAN Web Services, you can export one file. Using batch mode, you can export all collections in 
the pm.xml file.

</p>
<a name="wp1307555"> </a><p class="pBodyAutonumNoRule">
<strong>Note	&nbsp;&nbsp;&nbsp;</strong> DCNM-SAN Web Server must be running for this to work. 

</p>
<a name="wp1308108"> </a><p class="pBody">
You can export data collections to Microsoft Excel using DCNM-SAN Web Server.

</p>
<a name="wp1312130"> </a><h2 class="pHeading2">
DETAILED STEPS
</h2>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp1307558"> </a><li class="pSmartList1">Click the <span style="font-weight: bold">Performance</span> tab on the main page. 
</li>
<a name="wp1307559"> </a><p class="pListBodyLevel1">
You see the overview table.

</p>
<a name="wp1307560"> </a><li class="pSmartList1">Click the <b class="cBold">Flows</b> sub-tab.
</li>
<a name="wp1307561"> </a><li class="pSmartList1">Right-click the name of the entity you want to export and select <b class="cBold">Export to Microsoft Excel</b>. 
</li>
<a name="wp1307562"> </a><p class="pListBodyLevel1">
You see the Excel chart for that entity in a pop-up window.

</p>
</ol></div>
<a name="wp1307564"> </a><p class="pBody">
You can export data collections using command-line batch mode.

</p>
<a name="wp1312157"> </a><h2 class="pHeading2">
DETAILED STEPS
</h2>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp1307565"> </a><li class="pSmartList1">Go to the installation directory on your workstation and then go to the bin directory.
</li>
<a name="wp1307566"> </a><li class="pSmartList1">On Windows, enter <span style="font-weight: bold">.\pm.bat export C:\Program Files\Cisco Systems\MDS 9000\pm\pm.xml </span>&lt;<span style="font-style: italic">export 
directory</span>&gt;<span style="font-weight: bold">.</span> This creates the csv file (export.csv) in the <span style="font-style: italic">export directory</span> on your workstation.
</li>
<a name="wp1307567"> </a><li class="pSmartList1">On UNIX, enter <span style="font-weight: bold">./pm.sh export /usr/local/cisco_mds9000/pm/pm.xml </span>&lt;<span style="font-style: italic">export directory</span>&gt;. This 
creates the csv file (export.csv) in the <span style="font-style: italic">export directory</span> on your workstation.
</li>
</ol></div>
<a name="wp1307569"> </a><p class="pBody">
When you open this exported file in Microsoft Excel, the following information displays:

</p>
<div class="pSmartList1"><ul class="pSmartList1">
<a name="wp1307570"> </a><li class="pSmartList1">Title of the entity you exported and the address of the switch the information came from.
</li>
<a name="wp1307571"> </a><li class="pSmartList1">The maximum speed seen on the link to or from this entity.
</li>
<a name="wp1307572"> </a><li class="pSmartList1">The VSAN ID and maximum speed.
</li>
<a name="wp1307573"> </a><li class="pSmartList1">The timestamp, followed by the receive and transmit data rates in bytes per second.
</li>
</ul></div>
<hr /><br><p class="pBody">Copyright 2010-2013, Cisco Systems, Inc. All rights reserved.</p> 

    </blockquote>

  </body>
</html>
