Friday, June 5, 2015

SCOM: Fixing a blank report list in Ops Mgr Console

Something I came across in SCOM 2012 R2 is that when users try and view Reports from the OpsMgr console wunderbar they could receive a blank list.

Possible Cause #1 - Incorrect SSRS file system permissions
One thing that can impact this is incorrect file system permissions on the SSRS installation location.

1. On the server where the SSRS instance is installed, navigate to the SSRS install folder. Depending on your environment this could be the default of the following or a custom drive:

C:\Program Files\Microsoft SQL Server\MSRS.\Reporting Services

Where is the numerical version of SQL (e.g. 11) and is the instance name. Such as \MSRS11.MSSQLSERVER\Reporting Services

In my lab I customised this to the root of a partition like:
D:\MSRS11.MSSQLSERVER\Reporting Services

2. Open the properties of /ReportManager and /ReportServer separately

3. Ensure that a group which would contain the Windows Accounts of the users trying to access the reports has Read & Execute permissions to the relevant folders.

This is from my lab where it is the default, you may choose to secure this back to a group(s) containing just the users granted rights to your reports but you need to ensure these permissions exist.

Possible Cause #2 - Corrupted identities
If you face this issue are you find that some users, or even just the SCOM Administrator, can access the reports but others cannot. This could be following a restore of the "Reporting" component or even a restore/migration/upgrade of the whole SCOM environment.

The key to understand the cause of this is to look at how both SCOM and SSRS configure security.

First access the Administrator section from the OpsMgr Console wunderbar, and view the User Roles. Open the properties of the Report Operator User Role which contains the users who receive a blank list. Click on the Identity tab.

Take note of the ID which is displayed. Copy this to the clipboard.... you will need it ;)

Now navigate to your Report Server url (e.g. http://localhost/Reports).
Click on the Folder Settings button from the home screen.

Here you will be shown the security of the reports. Check if the ID from earlier is shown, chances are your list will contain a different set of IDs.

IMPORTANT: Do not remove any role assignments

Click the "New Role Assignment" button.

Enter the ID into the "Group of user name" and select Browser, My Reports, and Report Builder roles.

Click OK

The security assignments should now contain the ID of your User Role from OpsMgr.

Now if you have your user refresh the Reports in Ops Mgr Console they should have access to the reports. At least that was the solution I found in my lab.

If you find other causes let me know :)

Reference articles/blogs:
Here are some other articles I have since found which provide troubleshooting guidance on this topic as well for your reference.

Legal Stuff: As always the contents of this blog is provided “as-is”. The information, opinions and views expressed are those of the author and do not necessarily state or reflect those of any other company with affiliation to the products discussed. This includes any URLs or Tools. The author does not accept any responsibility from the use of the information or tools mentioned within this blog, and recommends adequate evaluation against your own requirements to measure suitability.


  1. Ci sono buone notizie per te. Ora, non è necessario spendere quei soldi per acquistare il tuo orologio da sogno. La tua risposta è orologi replica. Sì, vieni qui, acquista replica orologi Regno Unito replica rolex orologi migliori orologi Cosmograph Daytona ecc.

  2. Copiar el reloj es muy bonito, este es un estilo de gama alta.Réplica de relojes Rolex Realmente me gusta este reloj réplica. El servicio de la tienda es muy bueno, la calidad del reloj es muy buena y el precio es muy rentable,Réplica de relojes yacht master creo que es muy barato, de buena calidad y bajo precio.

  3. replica Cartier watches is a noted jewelry brand with luxurious elegance and technical innovation. It has massive selection of product lines ranging from jewellery, bridal, accessories, leather goods to timepieces. In our leading online shop, we are particularly specialized in selling Swiss replica Cartier watches. There is no denying the fact that Cartier watches are within the dream list of many women. However, they come with astronomical prices which are far beyond the reach of many people. In consideration of this problem, we miniforwatch website provide the final products of Swiss replica Cartier watches, which are much more authentic than that of our competitors, and at a fraction of the cost of originals. Furthermore, we always take attention to details, high-end materials, fine watchmaking and advanced design.

  4. Gli orologi Repliche longinesLongines sono stati un punto di riferimento del settore da quando il replica longines conquest orologiloro marchio è iniziato nel 1832 a Saint-Imier. Oggi il marchio offre una vasta gamma di orologi da uomo e da donna. Gli orologi prodotti da Longines sono stati utilizzati nel corso della storia per tutto, dalle esplorazioni all'espressione dell'eleganza. Oltre ad essere famosi per i loro legami con il mondo delle corse e dei cavalli, gli orologi Longines sono riconosciuti a livello globale per la loro raffinatezza senza tempo e chic. abbiamo una varietà di orologi Longines in vendita, tutti nuovi, belli e garantiti per essere genuini. Ancora meglio, quando acquisti i nostri orologi Longines online, sai che stai ottenendo il miglior valore. Sfoglia la nostra selezione per trovare il miglior prezzo dell'orologio Longines su Internet.

  5. Had this issue. Had to change proxy settings in IE.

  6. Rolex watches are crafted from the finest raw materials and assembled with scrupulous attention to detail. cheap replica watchesEvery component is designed, replica rolex watchesdeveloped and produced in-house to the most exacting standards.

  7. Today it may be one of the biggest and most profitable luxury brands on the planet, Replica handbags a byword for indulgence from Beijing to Bond Street, replica Louis Vuiton bags but Louis Vuitton's origins are more humble, dating back to a young man who left home to make his living packing luggage for the great and the good in 19th-century Paris.