Monthly Archives: October 2015

Create Custom Report User Role for ConfigMgr 2012 R2

Posted on October 27, 2015 by ConfigMgrMVP

Most of the information you need to create the Report User role is contained in Kent’s blog: http://blog.coretech.dk/kea/creating-the-reporting-user-role-in-configmgr-2012/ To make things a little easier, from the ConfigMgr console > Administration > Security > Security Roles, right click and import the … Continue reading →

Posted in ConfigMgr, SSRS | Leave a comment

Finding Maintenance Window Collections

Posted on October 27, 2015 by ConfigMgrMVP

For workstations: — List Computers with Maintenance Window SELECT col.Name AS CollectionName, sw.Name AS [MW Name], sw.Description, sw.StartTime, sw.Duration AS ‘Duration Minutes’, sw.IsEnabled AS ‘MW Enabled’, sys.Name0 AS WorkstationName, sys.Operating_System_Name_and0 AS OperatingSystem FROM dbo.v_ServiceWindow AS sw INNER JOIN dbo.v_FullCollectionMembership AS … Continue reading →

Posted in ConfigMgr, SQL Server | Leave a comment

ConfigMgr 2012 – Identify Custom SSRS Reports

Posted on October 7, 2015 by ConfigMgrMVP

Working through an upgrade / migration on a client site and needed to be able to identify custom reports created within the ConfigMgr 2012 reporting structure. The following query will provide that information, change the DOMAIN below to match your … Continue reading →

Posted in ConfigMgr, SQL, SQL Server, SSRS | Leave a comment

SQL Server 2012 – Setup account privileges

Posted on October 6, 2015 by ConfigMgrMVP

Encountered a strange issue today, installing SQL Server 2012 on Windows Server 2012 and received the following condition during the Setup Support Roles. Setup Account Privileges – Failed. That’s weird, I’m an Administrator on the server (of course :). Checked … Continue reading →

Posted in SQL Server 2012, Windows Server 2012 | 1 Comment

Congratulations 2015 Microsoft MVP

Posted on October 1, 2015 by ConfigMgrMVP

  Another year, another honor. Thank you Microsoft, and thanks to the community! Dear Steve Thompson, Congratulations! We are pleased to present you with the 2015 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively … Continue reading →

Posted in ConfigMgr, Microsoft, MVP | Leave a comment