What historical information stored in SCCM Configmgr Data Warehouse for custom reports

 

In my previous blog post, we saw how to install Data Warehouse role in Configuration manager build 1806 and also looked at the client data that is being deleted in primary site server for reporting purpose with some SQL views information.

In this blog post, we will see what information being stored in data warehouse before we start working on custom reports for users/customers to review historical data.

Central /Primary site database contains huge data about clients ,applications ,inventory ,execution data and much more. For list of SQL views in SCCM Configmgr ,please visit

with the installation of data warehouse, do we expect the entire data from Central/Primary do replicate to data warehouse database ? No ,it is not full data instead subset of data is being replicated to data warehouse for reporting purpose.

when you install Primary site ,the default size of SQL would be around 5 GB . Once the client start reporting to site ,database size will grow further .

When you install data warehouse role ,the only subset of sql information is being replicated and the initial size in my lab (my lab has only 20 devices with inventory) is about 170 MB for SQL database.

Data warehouse size:

image

Data warehouse log:

image

If you compare with Primary site SQL Views which contains 1600+ ,data warehouse contains 220 SQL views.

I have uploaded the SQL views information that are available in data warehouse to TechNet gallery  https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

Have a look at it before you start creating your custom reports .

See you next blog!

Leave a Reply