Links and other usefull information from this week MOC 6451

Websites: Config Mgr sites - SMS 2003 homepage - System Center homepage - Configuration Manager News groups - Configuration Manager webcasts - Config Mgr. homepage - Great community - Information about MOF editing - Config Mgr. addons Deployment Sites: - Deployment Blog, author Michael Petersen - MDT Blog Tools: - Scriptomatic - Config Mgr Client Center - 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: - List of Active Directory attributes names to be used in system and user [...]

By |2008-09-26T08:55:44+01:00September 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+01:00September 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+01:00September 7th, 2008|Configuration Manager (SCCM)|0 Comments