The Extract, Transform and Load (ETL) process refreshes the data in the warehouse. This is logically a sequential flow of data:
The Extract job acquires data from registered management servers
The Transform job optimizes the data for reporting needs and shapes the data according to the defined business rules
The Load job populates the data mart for long-term retention and access
Our problem is that there will be no data in our reports until the ETL process has done its job. If you would like to speed up that process, you can save and run the following PowerShell script on your FIM Service server:
if (@(get-pssnapin | where-object {$_.Name -eq "SMCmdletSnapIn"} ).count -eq 0)
{
Add-PSSnapin SMCmdletSnapIn
}
$dwMachine = "SCSM-DW"
Function WaitForId($id)
{
Write-Host ("Waiting on the job " + $id)
do
{
$job = Get-SCDWJob -ComputerName $dwMachine -JobBatchId $id
...