The SCSM ETL process is broken into several steps, which we will outline here. To understand this, we will first start with the MIM service. As we have discussed previously in this chapter, we executed the initial job and watched this job get created in the portal. Now, we will explain what is happening under the hood so that it can help you troubleshoot and manage the reporting system.
The steps to move the data are defined as follows:
When you first kick off reporting the Initial job, this job extracts data from the [fim].[Objects]
table. So, if you're just turning on Reporting but you have had MIM up for a while and have a large set of data, your initial sync could take a bit...