Just spend a few hours this morning troubleshooting a new Configuration Manager 2007 SP2 R2 installation.  I started to search the Internet for a solution and didn’t really find any good blog entries. Found a few similar errors posted in the Technet forums and thought I would write a post on the subject. The errors After configuring the Management Point I started to receive these errors: Sitecomp.log: Component [SMS_MP_CONTROL_MANAGER] could not install correctly on server Servername. WebDAV on the Windows Longhorn server is not configured correctly. MPsetup.log <12-30-2009 09:00:07>  WebDAV settings is not setup appropriately <12-30-2009 09:00:07>  [Allow property queries [...]

Download a step by step description of customizing and deploying Microsoft Office 2010 Beta 2 with Microsoft System Center Configuration Manager 2007 [download id="17"]

Adobe has just informed about a critical vulnerability in Adobe Reader 9.2 and earlier versions  - which is well… all Adobe Reader versions :-) An update to fix the vulnerability will be released mid January 2010. You can read the bulletin here - http://www.adobe.com/support/security/advisories/apsa09-07.html Disable Adobe Reader JavaScript manually 1. Launch Adobe Reader. 2. Select Edit>Preferences 3. Select the JavaScript Category 4. Uncheck the 'Enable Acrobat JavaScript' option 5. Click OK Disable Adobe Reader JavaScript with a configmgr. package 1. Create bat file with this entry reg add "HKCU\Software\Adobe\Acrobat Reader\9.0\JSPrefs" /v bEnableJS /d 0 /t REG_DWORD /F 2. Copy the [...]

 Websites:  http://www.microsoft.com/smserver/default.mspx - SMS 2003 homepage http://www.microsoft.com/systemcenter/en/us/default.aspx - System Center homepage http://social.technet.microsoft.com/Forums/en-US/category/configurationmanager/ - Configuration Manager News groups http://www.microsoft.com/events/series/technetmms.aspx?tab=webcasts&id=42364 - Configuration Manager webcasts http://www.microsoft.com/systemcenter/configurationmanager/en/us/default.aspx - Config Mgr. homepage http://www.myitforum.com/ - Great community http://www.smsexpert.com/ - Information about MOF editing http://www.1e.com/ - Config Mgr. addons http://blogs.technet.com/configmgrteam/default.aspx – System Center Config Mgr. team blog http://v-irtualization.com/tag/app-v/ – How to virtualize 3D games using the App V. sequencer http://technet.microsoft.com/en-us/library/bb892800.aspx – List of Configuration Manager log files http://blogs.technet.com/b/configurationmgr/archive/2010/11/30/configmgr-2007-antivirus-scan-and-exclusion-recommendations.aspx - ConfigMgr 2007 Antivirus Scan and Exclusion Recommendations http://blogs.technet.com/b/yasc/archive/2010/09/18/asset-intelligence-license-wizard-v1-4.aspx - Asset Intelligence License Wizard Tools: http://www.microsoft.com/technet/scriptcenter/tools/scripto2.mspx - Scriptomatic http://sourceforge.net/projects/smsclictr - Config Mgr Client Center http://www.myitforum.com/myITWiki/SCCMTools.ashx - SCCM Right click [...]

In order to successfully discover and install the ConfigMgr. clients on workgroup computers you need to configure a few settings. Configure a Server Locator Point Configure the proper client installation settings Configure the network discovery method Configure the Network access account Configure the client push installation account. Site Systems When you are working with clients that are not able to query the Active Directory services for ConfigMgr information you need to create a Server Locator Point – SLP. In my example I have one SLP a the central site. The SLP is used by the client during the site assignment [...]

With this basic report you will be able to monitor any new applications installed and registrered in Add/Remove programs during the last 7 days on a client computer.  Thanks to Claus Codam for helping out The SQL code SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, DATEDIFF(Day, CONVERT(date,dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0), GETDATE()) AS [days since installed] FROM dbo.v_R_System INNER JOIN dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID WHERE (SELECT ISDATE(dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0)) = 1 GROUP BY dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, DATEDIFF(Day, CONVERT(date,dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0), GETDATE()) HAVING ( (CASE WHEN (ISDATE(dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0))=1 THEN (DATEDIFF(Day, CONVERT(date,dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0), GETDATE())) ELSE 500 END) > 0 AND (CASE WHEN (ISDATE(dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0))=1 THEN (DATEDIFF(Day, CONVERT(date,dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0), GETDATE())) ELSE 500 END) < [...]

ConfigMgr. 2007 SP2 was released a few days ago and can be downloaded from - details.aspx-displaylang=en&FamilyID=3318741a-c038-4ab1-852a-e9c13f8a8140 To successfully install the service pack you need to start the upgrade from the central site and then upgrade child sites and administrator consoles. After the sites have been upgraded it’s time to upgrade the clients. You can use various methods to upgrade the client – check the Technet article for detailed information about the methods - http://technet.microsoft.com/en-us/library/bb694166.aspx One of the most commonly used methods is using a ConfigMgr. package to perform the upgrade. It works like a charm but when deploying the client [...]

I recently got a very good question from a student – how can we check the workstations that haven’t restarted during the last 7 days. The intention is to automatically restart the computers. However not until the end-users have been contacted. For that reason I need to create a report and a query. The report The SQL statement Create a new empty report and copy this SQL code into the SQL statement box: SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, DATEDIFF(Day, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) AS [Days since last boot], dbo.v_GS_OPERATING_SYSTEM.Caption0 FROM dbo.v_GS_OPERATING_SYSTEM INNER JOIN dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID WHERE (DATEDIFF(Day, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, [...]

Spending some time in other communities often gives me a lot of good ideas to reports and queries. A little while ago in the System Center Technet community I stumbled over a very need report created by a user called Qu4rk. His report shows a status of each update deployment, with a count of the each possible software update states. The only thing I have changed (thanks to Claus) is a new column showing the compliant computers in %. I am not going to take any credit for the report as my work was very limited. But this report is [...]

From time to time you will need to remove one or more software updates from a deployment. To remove the update from the deployment you can: Identify the update by reviewing the updatesdeployment.log on one the clients. If the deployment process is visible, you can also identify the failure by looking at the Updates installation status. Remove the update from the Update Management list You can see which update lists the update is part of by looking at the updates properties in the Config Mgr. console Navigate to the Deployment Management node, select the Deployment management list. Select the update [...]

Tools http://www.microsoft.com/technet/scriptcenter/tools/scripto2.mspx - Scriptomatic http://sourceforge.net/projects/smsclictr - Config Mgr Client Center http://www.myitforum.com/myITWiki/SCCMTools.ashx - SCCM Right click tools and more http://www.microsoft.com/downloads/details.aspx?FamilyId=04D26402-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en – Microsoft Virtual PC 2007 http://www.microsoft.com/downloads/details.aspx?FamilyID=e0fadab7-0620-481d-a8b6-070001727c56&displaylang=en – ConfigMgr. 2007 evaluation VHD Other sites http://scug.dk/ – Danish community for System Center products http://support.microsoft.com/default.aspx/kb/555638 - List of Active Directory attributes names to be used in system and user discovery http://technet.microsoft.com/en-us/library/bb693476.aspx and http://technet.microsoft.com/en-us/library/bb632952.aspx - Where to configure AD system/User discovery attributes http://www.adobe.com/support/downloads/detail.jsp?ftpID=3993 – Adobe customization wizard http://www.appdeploy.com/ – Information about software and deployment Troubleshooting software installations Check if the advertisement is received by the client. Open the exemgr.log and look for any installation errors. [...]

Using SQL Reporting Services is really a “blast”. If you want to use the reporting feature with Configuration Manager 2007 R2 (and you do!), you need to configure a few accounts, groups and configure permissions. In this post I assume that SQL Reporting Services is installed and configured. Accounts to be created Execution Account (Configured in the SQL Reporting Services manager) The EA is used by SRS to execute reports used for subscribtions. The account should be a low privilige account that has: Read access to all reports Open a browser and type SQLReportingSername/Reports Click Properties Click New Role Assignment [...]