Site Usage Report SharePoint 2013 Javascript

Dear all,

Below post describes how to get Site Storage report using JavaScript in SharePoint 2013.

In SharePoint 2010 we use to get the Usage report by
http://sitename/_layouts/15/Usage.aspx

We can still retrieve the data we require in the same way in SharePoint 2013 although the web analytic options from Site administration is missing.

REST call to get Usage Report in 2013:
https://<siteUrl>/_api/site/usage

Below was my purpose to create the Usage report Program:
1. To get usage report for 85 sites
2. To understand the Used storage and Max store for each site

Hence instead of hitting all sites manually I had to write a program.

Process:

1. Create a List called "All Site Usage Tracker"
    Columns: Title  -> (Single line of text)  -> Site name 
                       URL  -> (multi line of text)-> Site Url
   Columns: This are populated after my program runs
                       Current Storage (GB) -> (number)
                       Currently Used Storage (MB) -> (Single line of text) 
                       Storage Percentage Used -> (Single line of text) 

                       Max Storage (MB)  -> (Single line of text) 
  Columns: Calculated column. This was for my own purpose to segregate the sites into <10 GB, <20 GB and so on.
                       Usage -> (calculated column) -> Based on Current Storage (GB)

2. Program
As I had to call all the sites from the "All Site Usage Tracker" I had to use Sp services thrice:
1. To retrieve the names of sites
2. To get the usage report for each site
3. To update the list with storage data

I have used an array to store the data for all my sites.
/* Start of Program*/
//Empty Array
var SitesData = new Array();

// Get all sites from List and store in array
function GetSites() {
    $().SPServices({
        debug: true,
        operation: "GetListItems",
        async: false,
        listName: "All Site Usage Tracker",
        completefunc: function (xData, Status) {
            $(xData.responseXML).SPFilterNode("z:row").each(function () {
                // UsageReport($(this).attr("ows_URL"));
                SitesData.push({
                    Id: $(this).attr("ows_ID"),
                    URL: $(this).attr("ows_URL"),
                    Storage: null,
                    PercentStorage: null,
                    MaxStorage: null,
                    UsedStorageinMB: null,
                });
            });
        }
    });
    UsageServices();
    UpdateItems();
    SitesData.length = 0;
    alert("End of Usage Update");
}


// Get the Storage report of all sites and update the array
function UsageServices() {
    for (var i = 0; i < SitesData.length; i++) {
        var SiteURL = SitesData[i].URL;
        var call = $.ajax({
            url: SiteURL + "/_api/site/usage",
            type: "GET",
            dataType: "json",
            async: false,
            headers: {
                Accept: "application/json;odata=verbose"
            }
        });

        call.done(function (data, textStatus, jqXHR) {
            try {

                SitesData[i].Storage = Math.round(data.d.Usage.Storage / 1024 / 1024 * 10 / 1024) / 10; //Used Storage in GB
                SitesData[i].PercentStorage = Math.round(data.d.Usage.StoragePercentageUsed * 1000) / 10 + ' %';  //Percentage of storage used 
                SitesData[i].MaxStorage = Math.round(data.d.Usage.Storage / data.d.Usage.StoragePercentageUsed / 1024 / 1024 * 10) / 10; //Maximum storage for site in MB
                SitesData[i].UsedStorageinMB = Math.round(data.d.Usage.Storage / 1024 / 1024 * 10) / 10;  //Used Storage in MB
                console.log("Sites Data " + [i] + "SiteUrl: " + SitesData[i].URL);
                console.log("Sites Data " + [i] + "Storage: " + SitesData[i].Storage);
                console.log("Sites Data " + [i] + "MaxStorage: " + SitesData[i].MaxStorage);
            }
            catch (e) {
                //alert(e);
            }
        });

        call.fail(function (jqXHR, textStatus, errorThrown) {
            console.log("Error generating Report: " + jqXHR.responseText);
        });
    }
}

//Update List with Storage data
function UpdateItems() {
    for (var i = 0; i < SitesData.length; i++) {
        $().SPServices({
            operation: "UpdateListItems",
            async: false,
            batchCmd: "Update",
            listName: "All Site Usage Tracker",
            ID: SitesData[i].Id,
            valuepairs: [["Current_x0020_Storage", SitesData[i].Storage], ["Storage_x0020_Percentage_x0020_U", SitesData[i].PercentStorage], ["Max_x0020_Storage", SitesData[i].MaxStorage], ["Currently_x0020_Used_x0020_Stora", SitesData[i].UsedStorageinMB]],
            completefunc: function (xData, Status) {
                if (Status != "success") {
                    console.log("Error in Connection: " + xData.responseXML);
                }
            }
        });
    }
}
/* End of Program*/ 3. I had appended a button and html code in the allitems.aspx page of above list.
Below is the code:

<script type="text/javascript" src="path for jquery-1.11.1.min.js"></script>
    <script type="text/javascript" src="path for jquery.SPServices-2013.01.js"></script>
    <script type="text/javascript" src="path for Usage.js"></script>  //Your program file


<input id='btnSend' type='button' class='btnClass' value='Click to Update above List' onclick='GetSites();'/>