How to assign basic reporting permissions in Configuration Manager R2

Configuration Manager 2007 R2 offers two options when it comes to reporting. The classical reports and SQL Reporting Services. This post will explain how you assign permissions to both solutions. Classical reports Add the user/group to the local SMS Reporting Users group on the Reporting Point In the Configuration Manager console, navigate to Security and assign the User/Group Read permissions on the Reporting Class. SQL Reporting Services Open the SQL Reporting Services website http://server/reports For SQL Reporting Services 2008 R2, Click Folder Settings. For SQL Reporting Services 2008, Click Properties. Click New Role Assignment Assign the Browser role for all [...]

By |2011-02-24T07:14:11+01:00februar 24th, 2011|Configuration Manager (SCCM)|5 Comments

MMS 2011 BIRDS-OF-A-FEATHER System Center Custom Updates Publisher

It’s only a month until this year MMS 2011 kicks off. I personally think it’s an awesome schedule this year, lots of very great speakers, hands on labs and BOF sessions. I have just submitted a BOF session with Jason Lewis. Jason is a program manager for Configuration Manager at Microsoft. The session will focus on System Center Custom Updates Publisher 2011 and version 4.5 The usage of SCUP is increasing and there is huge demand for knowledge on how to use the product correctly. This BOF will give you information about lessons learned from the field including tips and [...]

By |2011-02-20T12:09:33+01:00februar 20th, 2011|Configuration Manager (SCCM)|Kommentarer lukket til MMS 2011 BIRDS-OF-A-FEATHER System Center Custom Updates Publisher

Install the Configuration Manager administrator console

Recently I had to prepare a “Configuration Manager Servicedesk kit”. In the kit I added the Configuration Manager console and Client Center. The installation had a few challanges: Creating and specifying Setup.ini during the installation Installing the correct version of Client Center - X64 or X86 – depending on the architecture. To solve the challenge I created a Task Sequence with these steps Use Toolkit package Gather Run Command "%_SMSTSOOO00127%\bin\i386\setup.exe" /Script "%_SMSTSOOO00127%\Setup.ini" (where OOO00127 is the packge id). Make sure you have created a package with the Configmgr. source files and that package is selected in the TS Install software, [...]

By |2011-01-27T07:23:18+01:00januar 27th, 2011|Configuration Manager (SCCM), General info|2 Comments

Specific updates installed

A common question in the forums is “How can I see who has this specific update installed”. One easy way to check that is by creating a DCM rule. Create a new DCM Baseline Click Theese software Updates must be present Select the needed updates and click OK Fiinish the wizard and assign the baseline to collection If you want to create a collection based on the non-compliant computers, check this blog post - https://blog.ctglobalservices.com/confmgr07/using-software-distribution-and-desired-configuration-management-to-fix-non-compliant-computers/

By |2011-01-02T12:07:46+01:00januar 2nd, 2011|Configuration Manager (SCCM), General info|1 Kommentar

Configuration Manager Power Management charts won’t show

At a few sites I have experienced a problem where none of the Power Management charts will show in the canned SQL Reporting Services reports. Everything looks like fine from the client side, power management is part of the inventory and data is being send correctly back to the Management Point. Yesterday evening I found the solution the Technet forums (credit goes to Paul024). The solution In order to fix the problem, log on to the SQL Reporting Services point and run Dunsetup.exe (found in Configuration Manager install dir\Bin\I386\) The report after running Dunsetup.exe

By |2010-12-31T10:27:33+01:00december 31st, 2010|Configuration Manager (SCCM)|Kommentarer lukket til Configuration Manager Power Management charts won’t show

How to fix ConfigMgr 2007 Console Error: “MMC cannot initialize the snap-in”

Today I was working in my test environment, my colleague had been testing some backup/restore of the site software. This had resulted in the console not working. this error appeared, when I tried to start it: “MMC cannot initialize the snap-in” I searched the net and found this article: ConfigMgr 2007: Unable to open Configuration Manager Console, error: MMC Cannot Initialize the Snap-in It helped me a lot in finding the installation log and testing the error. I had the problem in the installation log, but when I ran the commandline test: “C:\windows\Microsoft.Net\Framework\v2.0.50727\installutil.exe "Drive:\Program Files\Microsoft Configuration Manager Console\AdminUI\bin\AdminUI.ResourceExplorerConsole.dll" /logfile=C:\inst.log  /showcallstack” [...]

By |2010-12-29T13:04:38+01:00december 29th, 2010|Configuration Manager (SCCM)|1 Kommentar

Using Software distribution and Desired Configuration Management to fix non-compliant computers

Desired Configuration Management (DCM) is a feature in Configuration Manager which helps us tracing non-compliant computers. In Configuration Manager 2012 the feature also allows us to automatically remediate non-compliant computers. With Configuration Manager 2007 we can use a combination of DCM and Software Distribution to achieve the same functionality. In this example I will create a DCM CI that will report a workstation as non-compliant if Adobe Flash automatic update is enabled. To fix the problem, I have a script that will disable the check for new updates. The script will be deployed using a normal software package. Part I [...]

By |2010-12-24T10:45:49+01:00december 24th, 2010|Configuration Manager (SCCM), General info|5 Comments

Mastering Configuration Manager 2007 SP2 R3 training – 2011 Q1 dates and updated agenda (now with Forefront Endpoint Protection integration)

I’m thrilled to announce the lab schedule for first Quarter of 2011 along with the updated agenda. Dates Oslo, Norway - January 31 – feb. 2, 2011 Chicago, US - February 8-10, 2011  Stockholm, Sweden, February 16-18 New York, US - March 16-18, 2011 Boston , US - April 12-14, 2011   I have updated the agenda to include Forefront Endpoint Protection, client remediation, advanced software deployment, deploying custom updates like Adobe and Java. Updated agenda: Day 1 Introduction to System Center Installing and Configuring ConfigMgr. SP2 and R3 Installing and supporting ConfigMgr clients Installing and configuring clients Maintaining and [...]

By |2010-12-17T13:47:11+01:00december 17th, 2010|Configuration Manager (SCCM)|Kommentarer lukket til Mastering Configuration Manager 2007 SP2 R3 training – 2011 Q1 dates and updated agenda (now with Forefront Endpoint Protection integration)

Technet.dk Julekalender, 8. december (opdateret med spørgsmål)

Technet julekalenderen er godt igang og undertegnet deltager med spørgsmålet d. 8. december. Der er masser af spændende præmier i spil og en masse interessante spørgsmål. Spørgsmålet som kan findes nederst i denne blog post (fra d. 8. december kl. 09:00), kan besvares fra d. 8. december, når Bjarne Dollerup har givet startskuet, dette kan følgende på hans blog eller på Twitter (@ bdollerup). Svaret skal sendes som email [email protected] Den første som svarer rigtigt bliver kontaktet, og vinderen vil denne blive annonceret på bloggen. Spørgsmålet burde kunne besvares enten fra almindelig viden, eller ved at søge lidt på min [...]

By |2017-08-22T13:08:44+01:00december 6th, 2010|Configuration Manager (SCCM)|1 Kommentar

Error extracting files from KB977384

I have seen a few Configuration Manager R3 installations failing when trying to create the Configuration Manager package and program. To fix that problem I extract the SCCM2007-SP2-KB977384-ENU.msi file like this: msiexec /a SCCM2007-SP2-KB977384-ENU.msi /qb TARGETDIR=D:\R3 The command will extract all files and place them in D:\R3. From this folder you can take the sccm2007ac-sp2-kb977384-x86-enu.msp file and create the configuration manager package manually.    

By |2010-11-24T21:47:02+01:00november 24th, 2010|Configuration Manager (SCCM), General info|2 Comments

November Newsletter from TrueSec

Be sure to check out the November newsletter from TrueSec. Get some nice, helpful and very useful tricks on Deployment, Security, Configuration Manager and much more. The newsletter is written by Marcus Murray (MVP on Enterprise Security), Mikael Nyström (MVP on Setup/Deployment), Johan Arwidmark (MVP on Setup/Deployment) and Kent Agerlund (MVP on ConfigMgr.)

By |2010-11-23T14:00:11+01:00november 23rd, 2010|Configuration Manager (SCCM), General info|Kommentarer lukket til November Newsletter from TrueSec

Modifying the execution account after installing Configuration Manager R3

In a previous post I described how you create and configure an execution account for SQL Reporting Services and Configuration Manager R2. The execution account is a requirement for those who want to use the e-mail subscription feature. Due to changes in security the execution account does not have the needed permission to open the new Power Management reports. Instead you will get error messages like these: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DataSet3'. (rsErrorExecutingCommand) The EXECUTE permission was denied on the object 'PowerManagementGetDayRange', database 'SMS_A01', schema 'dbo'. An error occurred during client [...]

By |2010-11-17T21:58:26+01:00november 17th, 2010|Configuration Manager (SCCM), General info|2 Comments

System Center Configuration Manager 2012 presentations and slides from TechED 2010

Configuration Manager 2012 presentations and slides from TechED 2010 Europa and North America. You can watch these online or download them for offline viewing. Enjoy :) System Center Configuration Manager 2012 Overview http://www.msteched.com/2010/Europe/MGT203 System Center Configuration Manager 2012 Site Hierarchy Technical Overview http://www.msteched.com/2010/Europe/MGT303 Microsoft System Center Configuration Manager 2012 - Device Management http://www.msteched.com/2010/NorthAmerica/MGT305 Microsoft System Center Configuration Manager 2012 - Software Distribution http://www.msteched.com/2010/NorthAmerica/MGT309 Microsoft System Center Configuration Manager 2012 - Migration from Configuration Manager 2007 http://www.msteched.com/2010/NorthAmerica/MGT307 Microsoft System Center Configuration Manager 2012 Technical Demonstration http://www.msteched.com/2010/Europe/MGT202-LNC System Center Configuration Manager 2012 - Application Management http://www.msteched.com/2010/Europe/MGT302

By |2010-11-16T09:54:00+01:00november 16th, 2010|Configuration Manager (SCCM)|3 Comments

System Center Configuration Manager 2012 presentations and slides from TechED 2010

Configuration Manager 2012 presentations and slides from TechED 2010 Europa and North America. You can watch these online or download them for offline viewing. Enjoy :) System Center Configuration Manager 2012 Overview http://www.msteched.com/2010/Europe/MGT203 System Center Configuration Manager 2012 Site Hierarchy Technical Overview http://www.msteched.com/2010/Europe/MGT303 Microsoft System Center Configuration Manager 2012 - Device Management http://www.msteched.com/2010/NorthAmerica/MGT305 Microsoft System Center Configuration Manager 2012 - Software Distribution http://www.msteched.com/2010/NorthAmerica/MGT309 Microsoft System Center Configuration Manager 2012 - Migration from Configuration Manager 2007 http://www.msteched.com/2010/NorthAmerica/MGT307 Microsoft System Center Configuration Manager 2012 Technical Demonstration http://www.msteched.com/2010/Europe/MGT202-LNC System Center Configuration Manager 2012 - Application Management http://www.msteched.com/2010/Europe/MGT302

By |2010-11-16T09:53:40+01:00november 16th, 2010|Configuration Manager (SCCM)|Kommentarer lukket til System Center Configuration Manager 2012 presentations and slides from TechED 2010

Links and notes from MOC 6451 course, week 43, 44 and 45

SCCM Right Click Tools http://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx System Center Configuration Manager 2007 Toolkit v2 http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=5a47b972-95d2-46b1-ab14-5d0cbce54eb8 SMS Client Center http://sourceforge.net/projects/smsclictr/ Creating Configuration Manager Reports Part 1: https://blog.ctglobalservices.com/confmgr07/config-mgr-inventory-and-reporting/creating-configuration-manager-2007-reports/ Part 2: https://blog.ctglobalservices.com/confmgr07/config-mgr-inventory-and-reporting/creating-configuration-manager-2007-reports-part-ii-creating-the-first-reports/ Creating Custom Reports by Using Configuration Manager 2007 SQL Views http://www.microsoft.com/downloads/en/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en Read the blog at Coretech.dk for information about System Center, deployment and scripting https://blog.ctglobalservices.com/ Microsoft System Center Configuration Manager 2007 Dashboard Download it from here: http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=27fe0d80-38c6-464a-953a-1c2edcf35c2d Read about it here: http://technet.microsoft.com/en-us/library/ff369719.aspx See how to install it here: http://technet.microsoft.com/en-us/edge/system-center-configuration-manager-dashboard-part-1-installation.aspx Configuration Manager 2007 driver management http://blogs.technet.com/b/mniehaus/archive/2010/04/29/configmgr-2007-driver-management-the-novel-part-1.aspx http://www.deployvista.com/Home/tabid/36/EntryID/82/language/en-US/Default.aspx List of Log Files in Configuration Manager 2007 http://technet.microsoft.com/en-us/library/bb892800.aspx Desired Configuration Management Packs http://pinpoint.microsoft.com/en-US/systemcenter/managementpackcatalog System Center Configuration [...]

By |2010-10-29T13:55:08+01:00oktober 29th, 2010|Configuration Manager (SCCM)|2 Comments

Installing a Secondary site with non-standard SQL port

Configuration Manager will by default utilize the standard SQL ports when accessing the database. If you have configured the SQL server to use a non-standard port you will need to configure a SQL failure to do so will result in a non-working Management Point and WDS. The error: In the MPcontrol.log file you will see that the Management Point is unable to connect to the database. Attempting to connect to the configured SQL database.  $$<SMS_MP_CONTROL_MANAGER><Fri Oct 08 07:53:58.211 2010 Coordinated Universal Time><thread=2772 (0xAD4)> *** [08001][11][Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.  $$<SMS_MP_CONTROL_MANAGER><Fri Oct 08 07:59:00.227 2010 Coordinated [...]

By |2010-10-18T09:33:44+01:00oktober 18th, 2010|Configuration Manager (SCCM)|4 Comments

Capture none syspreped image using SCCM (Running imagex from a TS)

  One of the limitations of SCCM is the use of Imagex. When you want to capture an image of a computer, this computer needs to be syspreped before capture, or the capture process will fail. To do a capture of a reference image before sysprep, you normally would have to create a separate WinPE and run ImageX from that. This is also the case if you want to backup a system. So once again MDT comes to the rescue… By using the ZTIBackup.wsf script, you not only get to run ImageX from a Task Sequence, you also utilize  the [...]

Links and notes from MOC 6451 – Week 40 (Norway)

SCCM Right Click Tools http://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx System Center Configuration Manager 2007 Toolkit v2 http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=5a47b972-95d2-46b1-ab14-5d0cbce54eb8 SMS Client Center http://sourceforge.net/projects/smsclictr/ Creating Configuration Manager Reports Part 1: https://blog.ctglobalservices.com/confmgr07/config-mgr-inventory-and-reporting/creating-configuration-manager-2007-reports/ Part 2: https://blog.ctglobalservices.com/confmgr07/config-mgr-inventory-and-reporting/creating-configuration-manager-2007-reports-part-ii-creating-the-first-reports/ Creating Custom Reports by Using Configuration Manager 2007 SQL Views http://www.microsoft.com/downloads/en/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en Read the blog at Coretech.dk for information about System Center, deployment and scripting https://blog.ctglobalservices.com/ Microsoft System Center Configuration Manager 2007 Dashboard Download it from here: http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=27fe0d80-38c6-464a-953a-1c2edcf35c2d Read about it here: http://technet.microsoft.com/en-us/library/ff369719.aspx See how to install it here: http://technet.microsoft.com/en-us/edge/system-center-configuration-manager-dashboard-part-1-installation.aspx Configuration Manager 2007 driver management http://blogs.technet.com/b/mniehaus/archive/2010/04/29/configmgr-2007-driver-management-the-novel-part-1.aspx http://www.deployvista.com/Home/tabid/36/EntryID/82/language/en-US/Default.aspx

By |2010-10-07T14:43:55+01:00oktober 7th, 2010|Configuration Manager (SCCM)|Kommentarer lukket til Links and notes from MOC 6451 – Week 40 (Norway)

Teched Berlin 2010

Some mails are just better than others :-) This one just arrived in my inbox. Dear Kent: Congratulations!  You have been selected to participate in Tech·Ed Europe 2010 as a Microsoft Product Expert in the Technical Learning Center (TLC).  I’ll be helping out as Microsoft Expert in the System Center area. If you are in Berlin please drop in for a little chat – look forward to see you and Berlin.  

By |2010-09-29T21:45:59+01:00september 29th, 2010|Configuration Manager (SCCM), Events|Kommentarer lukket til Teched Berlin 2010