Monday, October 27, 2014

Authorized Users Dashboard

It is always a pain to determine all users that have permissions in Operations Manager and the SCOM user role and AD group.

So I created a script that to show all that data in a PowerShell Grid Widget. The view at the end looks like the screenshot:

image

Of course you can change the sort order as expected by the role, group, user or account name.

There is no additional configuration necessary since the script takes the management server from the registry.

The script can be downloaded directly from the TechNet Gallery: https://gallery.technet.microsoft.com/PSGW-Authorized-Users-e566c5aa

You can easily install the AD PowerShell module if you run the Operations Console on a server OS by entering the following command in an elevated PowerShell:
Add-WindowsFeature RSAT-AD-PowerShell
For Windows 7:
http://www.microsoft.com/en-us/download/details.aspx?id=7887
For Windows 8:
http://www.microsoft.com/en-us/download/details.aspx?id=28972
For Windows 8.1:
http://www.microsoft.com/en-us/download/details.aspx?id=39296

All information is provided "as is" without any warranty! Try in lab before. Handle with care in production.

All information is provided "as is" without any warranty! Try in lab before. Handle with care in production.
Read Full Post...

Monday, October 13, 2014

SQL Dashboards do not show Display Name

In the version 6.5.1.0 of the SQL Management Pack the dashboards have been changed and adopted to 2008 besides of 2012.

Unfortunately, in some SCOM environments (seems to be the ones that are upgraded from 2007) the DB display name is not shown in the Databases widget and the column is empty.

The problem is that in the dashboard MPs there is a value “$Object/PropertyCollection[Name=’DisplayName’]$” and that collection simply does not exist.

This can be tested by extracting the MP to XML, searching for the string “PropertyCollection[Name=’DisplayName’]$” and replacing it by “Property[Name=’DisplayName’]$”.

Please keep in mind that the MP/XML is still intellectual property of Microsoft and that the EULA apply!

The sample above is only to show the reason for the missing value.

All information is provided "as is" without any warranty! Try in lab before. Handle with care in production.

All information is provided "as is" without any warranty! Try in lab before. Handle with care in production.
Read Full Post...