Links and notes from Mastering Configuration Manager 2007 R3 training (updated February, 17 2010)

 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 [...]

By |2009-11-30T09:55:13+01:00november 30th, 2009|Configuration Manager (SCCM)|3 Comments

Supporting ConfigMgr. workgroup clients

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 [...]

By |2009-11-02T09:41:20+01:00november 2nd, 2009|Configuration Manager (SCCM)|4 Comments

Audit software installations r2

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) < [...]

By |2009-11-02T09:23:32+01:00november 2nd, 2009|Configuration Manager (SCCM)|17 Comments