Using Exported Client XML Data

Dashboard gives users the ability to download and export several types of data including Client data. When viewing this exported data, you may run into difficulties deciphering the time and date values as they are exported in the EPOCH time standard. The following steps explain how to export your client usage data, and convert that data into a more recognizable format:

1. Export the XML Data
   1. On Dashboard, navigate to Network-wide > Monitor > Clients and select Download as > XML.
   2. Save the file on your computer.
   3. Open the file in a Spreadsheet editor (ie. Excel, Google Docs)
2. Manipulate the Spreadsheet
   1. Add an additional column next to each of the columns that contain EPOCH time values
   2. Choose one of the following formulas into the first cell in your new column based on your time zone:

• GMT – Greenwich Mean Time: =(A1/86400)+25569
• EST – Eastern Standard Time (GMT – 5:00): =((A1-18000)/86400)+25569
• CST – Central Standard Time (GMT – 6:00): =((A1-21600)/86400)+25569
• MST – Mountain Standard Time (GMT – 7:00): =((A1-25200)/86400)+25569
• PST – Pacific Standard Time (GMT – 8:00): =((A1-28800)/86400)+25569

3. Drag the formula composed in step b so that it is copied to each of the corresponding cells below. This is done by placing your cursor on the bottom right of the cell containing the data you want to copy and then dragging it down:
   
    
4. Change the cell formatting for the column(s) so it displays in a mm/dd/yyyy tt:tt format: