Update Broadbox BDR

Getting the BDR data

We are going to fetch the data from the Bandwidth dashboard.

Download the relevent months - this will be a csv format.

Prepare PPNSystem_BwBdr

Change the plan on the PPNSystem_BwBdr Azure SQL database. We will need 500 DTU+ to perform this work. Remember to reduce the size when you are done.

Choose the relevant table (By year)

e.g. BwCallDetailRecords_2022.

If a table does not exist for this current year you will need to create it (using create to); remember to add the relevant indexes.

Import BDR data into DB

Import the csv file into the relevant table.

All done