Microsoft Storage Reporting: Splunk Dashboard

Overview:

The Microsoft storage dashboard in Splunk lets you see how much storage your college or division is using across different tools - SharePoint, OneDrive, and Exchange (Outlook) - and what is taking up the most space.

How to Access:

Please note: You must be connected to the Campus VPN or VDI to access the dashboard.

• View instructions for connecting to Campus VPN.

• View Instructions for connecting to VDI.

• Access the Splunk dashboard.

  • Access is limited to OHIO IT and key points of contact across the University. Please reach out to your college’s point of contact if you have questions. 

Using the Dashboard:

Note: Dashboard data refreshes monthly. Microsoft data will be pulled the 1st of the month and the Splunk dashboard will update the following business day.  

1. Select the appropriate Division using the upper left drop-down menu.

2. Viewing Overview Information: 

   • Total Usage: How much data (in GB) your unit is using across OneDrive, SharePoint, and Exchange. 

   • Yearly Cost: How much your division’s storage consumption will cost the University based on current Microsoft’s new pricing model.  

     • Microsoft charges $360 annually per terabyte of storage (subject to change).  

   • Details and Graph: 

     • How many GB of storage your college is using, broken down by tool: SharePoint, Exchange, and OneDrive.  

3. Viewing Drilldowns:

   • The SharePoint, OneDrive, and Exchange drilldown charts help you target what is taking up the most space in each tool. 

   • Select any column header to sort the data in a chart. You can also export a CSV to see all items (see next step). 

4. Exporting a Drilldown: 

   • Hover over the panel. 

   • A toolbar will appear at the bottom right of the panel. Select the export button (down arrow). 

   • In the Export Results pop-up window, select your preferred file format. 

   • Select the Export button, and the file will be downloaded to your computer. 

5. Viewing Change Over Time:

   • Navigate to the bottom of the report. 

   • Under Total Change Since Previous Report, you’ll see a figure showing how your total storage usage has changed since the report last ran.