Links and other usefull information from this week MOC 6451

Websites: Config Mgr sites 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://technet.microsoft.com/da-dk/configmgr/default(en-us).aspx http://technet.microsoft.com/da-dk/library/bb735860(en-us).aspx http://www.smsexpert.com/ - Information about MOF editing http://www.1e.com/ - Config Mgr. addons Deployment Sites: http://blog.ctglobalservices.com/osdeploy/ - Deployment Blog, author Michael Petersen http://blogs.technet.com/msdeployment/default.aspx - MDT Blog 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 Troubleshooting Management Point: http://siteservername/SMS_MP/.sms_aut?MPCERT http://siteservername/SMS_MP/.sms_aut?MPList Other sites: http://support.microsoft.com/default.aspx/kb/555638 - List of Active Directory attributes names to be used in system and user [...]

By | 2008-09-26T08:55:44+00:00 September 26th, 2008|Configuration Manager (SCCM)|0 Comments

Creating Configuration Manager 2007 Reports – Part II Creating the first report

In this part I will walk you through the creation of a report in SQL Server Managmenet Studio. The report will show all clients with SMS 2003 Toolkit installed. Open SQL Server Management Studio and log on to the server. Navigate to the Configuration Manager database. The name is most likely SMS_<Sitecode>. Right click Views and select New View Select the Views tab. Add V_R_System and V_GS_Add_Remove_Programs Note: V_R_System contains the basic discovery data. Now when we have the views we must create an Inner Join.From V_R_System drag the column RessourceID onto the RessourceID column onto the V_GS_Add_Remove_Programs view Select [...]

By | 2008-09-08T19:30:19+00:00 September 8th, 2008|Configuration Manager (SCCM)|7 Comments

Creating Configuration Manager 2007 Reports – Part I the basics

I often hear customers and students complaining about the complexity of creating reports. Statements like; “the database is a mystery” and “I am not a SQL expert. I agree, the database can be a mystery. But using the proper tools and some very basic SQL skills you will be able to create powerful reports. I will post 4 parts explaining the basics and how to build a few reports. Views: Reports are based on SQL views. A view is basically just a query joining one or more tables. Knowing a few basics of the naming standard I very helpful: V_GS_Name [...]

By | 2008-09-07T16:15:31+00:00 September 7th, 2008|Configuration Manager (SCCM)|0 Comments