Provider wants to know how long Office 365 subscriptions take to provision on Microsoft side.
Use the Python script to extract data about provisioned subscriptions. It takes the audit log file (or part of it) from the Office 365 Gateway as input (the file with the name 'audit' inside the 'App_Data' folder), and creates CSV file with the following data:
Subscription ID; Offer ID; Time when subscription was ordered with Microsoft; Time when callback about successful provisioning was received
The example of the script output:
subId; offer; ordered; provisioned aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee; 1017D7F3-6D7F-4bfa-BDD8-79BC8F104E0C; 2013-03-22 16:15:54; 2013-03-22 16:36:56
This data can be imported into Excel or any other tool and be used for generating statistics. For instance, the following code in R language reads the script's output and generates a plot for E3 subscriptions provisioning times in April 2013:
provtimes <- read.csv2(file="/Users/admin/Documents/audit/provtimes.csv", sep=";", dec=".") provtimes$ordered <- strptime(provtimes$ordered, "%Y-%m-%d %H:%M:%S") provtimes$provisioned <- strptime(provtimes$provisioned, "%Y-%m-%d %H:%M:%S") provtimes$diff = provtimes$provisioned - provtimes$ordered provtimes_E3_May <- provtimes[ which(provtimes$offer=='1017D7F3-6D7F-4bfa-BDD8-79BC8F104E0C' & provtimes$ordered > as.POSIXct('2013-04-01') & provtimes$ordered < as.POSIXct('2013-05-01')),] provtimes_E3_May <- provtimes_E3_May[order(provtimes_E3_May$ordered),] plot(provtimes_E3_May$ordered,provtimes_E3_May$diff, main = 'Provisioning times for E3 subscriptions in April 2013', xlab = 'Time when subscription was ordered', ylab = 'Time till provisioned')
See the example of the generated plot: