{"id":1831,"date":"2012-01-08T05:11:13","date_gmt":"2012-01-08T05:11:13","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?p=1831"},"modified":"2012-01-11T23:04:06","modified_gmt":"2012-01-11T23:04:06","slug":"installing-reporting-for-fim-r2","status":"publish","type":"post","link":"https:\/\/www.wapshere.com\/missmiis\/installing-reporting-for-fim-r2","title":{"rendered":"Installing Reporting for FIM R2 RC"},"content":{"rendered":"<p>I have just installed the reporting for FIM R2 RC\u00c2\u00a0and generated my first reports. Though when I say &#8220;just&#8221; read that as &#8220;spent two days on it and reinstalled twice&#8221;. However it is now working (yay! Was it worth it? Not sure yet!) and here&#8217;s my write-up.<\/p>\n<p>You should also refer to the following documents from the FIM R2 media:<\/p>\n<ul>\n<li>Test Lab Guide: Demonstrating Forefront Identity Manager 2010 R2 Beta Reporting<\/li>\n<li>Test Lab Guide: Installing Forefront Identity Manager 2010 R2 Release Candidate<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<h3>Servers<\/h3>\n<p>Here&#8217;s what I&#8217;ve installed into my lab:<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td><strong>Server<\/strong><\/td>\n<td><strong>Software<\/strong><\/td>\n<td><strong>Comments<\/strong><\/td>\n<\/tr>\n<tr>\n<td>DC<\/td>\n<td>\n<ul>\n<li>Windows Server 2008r2 Standard<\/li>\n<li>Exchange 2010<\/li>\n<\/ul>\n<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>FIM<\/td>\n<td>\n<ul>\n<li>Windows Server 2008r2 Standard<\/li>\n<li>SQL 2008r2<\/li>\n<li>Sharepoint 2010 Foundation<\/li>\n<li>FIM 2010 R2 &#8211; Sync and Portal<\/li>\n<li>System Center Service Manager<\/li>\n<\/ul>\n<\/td>\n<td>Two named instances of SQL:- FIM (Database)- SCDW (Database, Reporting)<\/td>\n<\/tr>\n<tr>\n<td>Data Warehouse<\/td>\n<td>\n<ul>\n<li>Windows Server 2008r2 Standard<\/li>\n<li>System Center Data Warehouse Manager<\/li>\n<\/ul>\n<\/td>\n<td>SCDW Manager cannot be installed on the same server as SCSM.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>PreReqs<\/h3>\n<p>I&#8217;ll assume you already have SQL installed. I created seperate instances for FIM and System Center.<\/p>\n<ul>\n<li>The instance for SC needs Database, Full Text Indexing and Reporting Services.<\/li>\n<li>If you use the default collation you get\u00c2\u00a0a warning during installation about multi-lingual environments, so if this is an issue you will need to install with a suitable collation.<\/li>\n<\/ul>\n<p>The FIM Service and Portal may already be installed, but you should not yet have installed the Reporting component.<\/p>\n<p>I also disabled all the Windows Firewalls just to get it working. I&#8217;ll look into what ports I need to open up when I switch them back on later.<\/p>\n<h3>Install SCSM<\/h3>\n<p>Install System Center Service Manager on the FIM server. (Note: I don&#8217;t know that it needs to be on the FIM server &#8211; that&#8217;s just how it is in my lab).<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>Configure the Service Manager database<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-1.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-1833\" title=\"Install SCSM 1\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-1-300x144.jpg\" alt=\"\" width=\"300\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-1-300x144.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-1.jpg 697w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Configure the management group:<\/p>\n<ul>\n<li>Pick a suitable name for the management group\u00c2\u00a0 &#8211; this is some kind of system center thing and I used the name of the company (changed in the picture here to something generic).<\/li>\n<li>For the administrators group I added FIMSyncAdmins because it&#8217;s a lab and I was feeling lazy and it&#8217;s just being installed for FIM. Obviously IRL you would create a dedicated group.<\/li>\n<\/ul>\n<\/td>\n<td>\u00c2\u00a0<a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1834\" title=\"Install SCSM 2\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-2-300x153.jpg\" alt=\"\" width=\"300\" height=\"153\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-2-300x153.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-2.jpg 664w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>The following two screens ask you to select accounts for service and for the workflow account. I left both on the default of Local System.There was something about the workflow account needing to be an email-enabled domain account if you want to send reports by email later on, but that&#8217;s a nicety I can come back to later.<\/td>\n<td>\u00c2\u00a0<a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1835\" title=\"Install SCSM 3\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-3-300x120.jpg\" alt=\"\" width=\"300\" height=\"120\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-3-300x120.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCSM-3.jpg 664w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After completing these options you should be able to proceed with the installation.<\/p>\n<h3>Install SCDW<\/h3>\n<p>Install System Center Data Warehouse Management Server\u00c2\u00a0onto its dedicated (or at least, seperate) server.<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>Straight off you may see a couple of warnings.<\/p>\n<ul>\n<li>The 8GB seems excessive for a lab. My server has 4GB configured and I&#8217;ve not seen it\u00c2\u00a0go above 2GB usage.<\/li>\n<li>The message about the hotfix may be ignored for Win2008r2. I downloaded and tried to install the patch several times and was always told that the hotfix was not applicable to my system. So eventually I googled it and, sure enough, you don&#8217;t need it on R2, even though it warns you about it!<\/li>\n<\/ul>\n<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-1-warnings.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1836\" title=\"Install SCDW 1 warnings\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-1-warnings-300x115.jpg\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-1-warnings-300x115.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-1-warnings.jpg 663w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Configure the databases &#8211; Click &#8220;Staging and Configuration&#8221; and &#8220;Data Mart&#8221; in turn and point it at the SQL server and instance &#8211; in my case hosted\u00c2\u00a0on the FIM server.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-3-server.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1837\" title=\"Install SCDW 3 server\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-3-server-300x193.jpg\" alt=\"\" width=\"300\" height=\"193\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-3-server-300x193.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-3-server.jpg 678w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Here for the name I just added &#8220;FIM&#8221; after the &#8220;DW_&#8221; that was already there. And as above I was lazy and reused the FIMSyncAdmins group.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-4-management-group.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1838\" title=\"Install SCDW 4 management group\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-4-management-group-300x149.jpg\" alt=\"\" width=\"300\" height=\"149\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-4-management-group-300x149.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-4-management-group.jpg 654w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Set the details of the SQL Reporting Server to be used by SCDW.<\/p>\n<p>I&#8217;ve ticked the box saying I&#8217;ve taken certain manual steps\u00c2\u00a0 but actually I haven&#8217;t done it yet so we&#8217;ll go do that now.(Incidentally if you forget these manual steps all the DW Management Packs deploy except for the ones named &#8220;* Report Library&#8221;.)<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-5-plus-extra-manual-steps.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1839\" title=\"Install SCDW 5 plus extra manual steps\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-5-plus-extra-manual-steps-300x185.jpg\" alt=\"\" width=\"300\" height=\"185\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-5-plus-extra-manual-steps-300x185.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-5-plus-extra-manual-steps.jpg 654w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Here&#8217;s the link where the manual steps are described: <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ff461215.aspx\">http:\/\/technet.microsoft.com\/en-us\/library\/ff461215.aspx<\/a><\/p>\n<p>First you copy the file <strong>Microsoft.EnterpriseManagement.Reporting.Code.dll<\/strong> from the Prerequisites folder on the System Centre DVD to the ..\/ReportServer\/bin folder relevant to your named instance of SQL (more details about how to find this folder in the technote).<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1840\" title=\"manual change 1\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-1-300x198.jpg\" alt=\"\" width=\"300\" height=\"198\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-1-300x198.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-1.jpg 740w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Then there&#8217;s a piece of XML to be pasted into the ..\/ReportServer\/rssrvpolicy.config file. You don&#8217;t need to modify the XML, but you do need to copy it at the same level as the other CodeGroup nodes.<\/p>\n<p>While it doesn&#8217;t say in the technote, there is a comment at the bottom saying you should restart Reporting Services, which sounds pretty sensible.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1841\" title=\"manual change 2\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-2-300x264.jpg\" alt=\"\" width=\"300\" height=\"264\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-2-300x264.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/manual-change-2.jpg 665w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Now back to the SCDW installation &#8211; specify a domain account to run the service. This account needs to be a local Administator on the SCDW server.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1842\" title=\"Install SCDW 6\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-6-300x156.jpg\" alt=\"\" width=\"300\" height=\"156\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-6-300x156.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-6.jpg 691w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>I just used the same account for the reporting account. Again not sure if this is a good or bad idea, but it&#8217;ll do for now.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-7.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1843\" title=\"Install SCDW 7\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-7-300x189.jpg\" alt=\"\" width=\"300\" height=\"189\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-7-300x189.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Install-SCDW-7.jpg 598w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now you should be able to click <strong>Install<\/strong> and let the installation run.<\/p>\n<h3>Register the DW server with SCSM<\/h3>\n<p>Next you have to register the SC Data Warehouse Management Server with SC System Manager.<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>Run the System Center Service Manager Console and, on the Administration page,\u00c2\u00a0click on &#8220;Register with Service Manager Data Warehouse&#8221;.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-0.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1844\" title=\"Regsiter DW 0\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-0-300x168.jpg\" alt=\"\" width=\"300\" height=\"168\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-0-300x168.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-0-1024x575.jpg 1024w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-0.jpg 1366w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Enter the name of the SCDW server.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1845\" title=\"Regsiter DW 1\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-1-300x141.jpg\" alt=\"\" width=\"300\" height=\"141\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-1-300x141.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-1.jpg 755w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Here I just accepted the default, even though the accountname doesn&#8217;t look familiar\u00c2\u00a0&#8211; I guess it maps to the service account because it seems to work.<\/td>\n<td>\u00c2\u00a0<a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1847\" title=\"Regsiter DW 2\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-2-300x155.jpg\" alt=\"\" width=\"300\" height=\"155\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-2-300x155.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/Regsiter-DW-2.jpg 690w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The last step is just to click <strong>Create<\/strong> and\u00c2\u00a0the registration\u00c2\u00a0should complete.<\/p>\n<h3>Wait for the Management Packs to finish deploying<\/h3>\n<p>The first time I installed I had a lot of trouble with DW jobs seemingly never finishing and no data appearing in the reports. So the second time through I made sure each step completed without errors before continuing on.<\/p>\n<p>In the System Center console, if you open Data Warehouse -&gt; Management Packs, you should see a list of Management Packs. Wait until all of them have &#8220;Completed&#8221; as their Deployment Status.<\/p>\n<p>If any come up as &#8220;Failed&#8221; then troubleshoot that before proceeding. Note that when looking for error messages you have to go into the Operations Manager event log on the <strong>Data Warehouse Management Server<\/strong>\u00c2\u00a0&#8211; and not the server where you&#8217;re running the console.<\/p>\n<h3>Install the Reporting component of FIM\u00c2\u00a0R2<\/h3>\n<p>&nbsp;<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>If you don&#8217;t yet have the FIM Service and Portal installed, install it now, selecting the FIM Reporting option.If it is already installed, go to Control Panel \/ Uninstall a Program. Select &#8220;Forefront Identity Manager Service and Portal&#8221; and choose &#8220;Change&#8221;.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1848\" title=\"install portal 1\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-1-300x214.jpg\" alt=\"\" width=\"300\" height=\"214\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-1-300x214.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-1.jpg 536w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Enter the name of the server where you installed SCSM (the FIM server in my lab). If you get a warning about a hotfix go and install it.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1849\" title=\"install portal 5\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-5-300x240.jpg\" alt=\"\" width=\"300\" height=\"240\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-5-300x240.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/install-portal-5.jpg 541w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Otherwise just configure as appropriate for your environment and complete your Portal re\/installation.<\/p>\n<h3>Run the DW Configuration Script<\/h3>\n<p>&nbsp;<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>There&#8217;s a script in the FIM R2 installation media you need to run to set things up correctly. It&#8217;s called FIMPostInstallScriptsForDataWarehouse.ps1 and you&#8217;ll find it in the &#8220;Data Warehouse Support Scripts&#8221; folder which ius located in FIM_R2_RC_TechNet_Docs.zip (a seperate download to the installtion files).You have to enter the DataWarehouseServerInstance which is actually asking for the SQL instance where the DW databases are\u00c2\u00a0&#8211; so here I&#8217;ve entered localhost\\SCDW.<\/p>\n<p>The FIMServiceAccountName is simple enough &#8211; the account running the FIM Service.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-21.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1855\" title=\"initial sync 2\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-21-300x66.jpg\" alt=\"\" width=\"300\" height=\"66\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-21-300x66.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-21.jpg 962w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Run the FIM powershell cmdlets to create Report objects<\/h3>\n<p>The reporting data is exported by a workflow that is triggered by the creation of Reporting Job\u00c2\u00a0objects in the FIM Portal. There are a couple of powershell cmdlets that do this for you.<\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<td>First run the Start-FIMReportingInitialSync script. If you haven&#8217;t already done so you&#8217;ll need to add the FIMAutomation pssnapin.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1856\" title=\"initial sync 3\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-3-300x44.jpg\" alt=\"\" width=\"300\" height=\"44\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-3-300x44.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-3.jpg 333w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Now go into the FIM Portal and check the Reporting Job\u00c2\u00a0object was created. In Adminstration -&gt; All Resources locate the object class msidmReportingJob. Click on &#8220;Reporting Job&#8221; to view all objects of this type.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1857\" title=\"initial sync 4\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-4-300x76.jpg\" alt=\"\" width=\"300\" height=\"76\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-4-300x76.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-4.jpg 942w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>You should see a job of type &#8220;Initial&#8221;. Open it and check it&#8217;s properties to see the status of the job. First it will be &#8220;Running&#8221; and then &#8220;Completed&#8221;. If the job fails then you will have some troubleshooting to do.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1858\" title=\"initial sync 6\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-6-300x219.jpg\" alt=\"\" width=\"300\" height=\"219\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-6-300x219.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/initial-sync-6.jpg 427w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Next run the cmdlet Start-FIMReportingIncrementalSync script.\u00c2\u00a0This does the same sort of thing\u00c2\u00a0&#8211; creates a Reporting Job object in the Portal.It is this cmdlet that you will need to schedule to run periodically.<\/td>\n<td><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/partial-sync-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1859\" title=\"partial sync 1\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/partial-sync-1-300x28.jpg\" alt=\"\" width=\"300\" height=\"28\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/partial-sync-1-300x28.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/partial-sync-1.jpg 377w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Wait for DW Jobs to complete<\/h3>\n<p>You won&#8217;t see any data in the reports until the following Data Warehouse Jobs have completed:<\/p>\n<ul>\n<li>Extract_<em>MyName<\/em><\/li>\n<li>Transform.Common<\/li>\n<li>Load.Common<\/li>\n<\/ul>\n<p>In the FIM doco there&#8217;s a section showing you how to create a script called ETLScript.ps1 that forces these jobs to run straight away. However in my environment the first two scripts are set, by default,\u00c2\u00a0to run every 5 minutes, and the last one runs once an hour. So you can either run the script, or wait an hour or so and then find data in the reports.<\/p>\n<p>I found the following powershell cmdlets useful while I was waiting for the pot to boil. They have to be run on the <strong>SCDW Server<\/strong>.<\/p>\n<ul>\n<li>Get-SCDWJob<\/li>\n<li>Get-SCDWJobModule<\/li>\n<li>Get-SCDWJobSchedule<\/li>\n<\/ul>\n<p>You have to add the pssnapin SMCmdletSnapIn first.<\/p>\n<h3>View Reports<\/h3>\n<p>All going well you should eventually see some data in the reports, which can be viewed\u00c2\u00a0in the SC Service Manager Console under Reports.<\/p>\n<p><a href=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/view-report.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1860\" title=\"view report\" src=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/view-report.jpg\" alt=\"\" width=\"1284\" height=\"577\" srcset=\"https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/view-report.jpg 1284w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/view-report-300x134.jpg 300w, https:\/\/www.wapshere.com\/missmiis\/wp-content\/uploads\/2012\/01\/view-report-1024x460.jpg 1024w\" sizes=\"auto, (max-width: 1284px) 100vw, 1284px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have just installed the reporting for FIM R2 RC\u00c2\u00a0and generated my first reports. Though when I say &#8220;just&#8221; read that as &#8220;spent two days on it and reinstalled twice&#8221;. However it is now working (yay! Was it worth it? Not sure yet!) and here&#8217;s my write-up. You should also refer to the following documents&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":[]},"categories":[60,61],"tags":[],"class_list":["post-1831","post","type-post","status-publish","format-standard","hentry","category-fim-2010-r2","category-reporting"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pkp1o-tx","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/1831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=1831"}],"version-history":[{"count":15,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/1831\/revisions"}],"predecessor-version":[{"id":1866,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/1831\/revisions\/1866"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=1831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/categories?post=1831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/tags?post=1831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}