-
-
select
*
from
SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_COMPUTER_SYSTEM.Domain = "<domain name>"
-
-
I saw this event posted on System Center Configuration Manager Training Resource web site..
http://blogs.msdn.com/systemcenterconfigurationmanagertrainingcanada/archive/2009/08/28/new-training-resources-on-system-center-configuration-manager.aspx
Event Overview
We focus on automating Windows 7 operating system deployments using Microsoft System Center Configuration Manager in this webcast. First, we cover how to automate hardware and software inventory using Asset Intelligence to determine what applications and hardware are needed for deploying Windows 7. Next, we examine deploying Windows 7 packages, and we discuss how to add Windows 7 packages to System Center Configuration Manager and then the deploy packages to bare metal machines and existing Windows Vista clients across the enterprise.
Presenter: Kevin Remde, Senior IT Pro Evangelist, Microsoft Corporation
A prolific blogger, Kevin Remde shares his thoughts, ideas, and tips on the TechNet Events Bloggers Web site and the IT Professional Community Web site. As a webcast presenter, he has landed on the Microsoft top 10 webcast list several times. Kevin has worked as both a developer and an IT professional, so he loves sharing helpful new solutions and technologies with his IT peers. At Microsoft, Kevin relishes the opportunity to generate fresh ideas and run with them. He received his bachelor’s degree in computer science at the University of Minnesota (go Gophers!), where he also studied music theory and composition.
To Register:
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032416867&EventCategory=4&culture=en-US&CountryCode=US
-
-
With all the talk about 70-401 exam this week and with at least 3 new MCTS. I thought that I would update the stats on my blog.
Here are the old stats from April 2009, if you want to compare them.
http://smsug.ca/blogs/garth_jones/archive/2009/06/05/how-many-certified-system-center-people-are-there-april-2009.aspx
I add the VMM MCTS stats too, are you one?
Microsoft System Center Configuration Manager 2007: Configuration 2,414
Microsoft System Center Operations Manager 2007: Configuration 1,686
Microsoft System Center Virtual Machine Manager 2008, Configuration 478
The numbers are from http://www.microsoft.com/learning/en/us/certification/cert-overview.aspx#tab5, I wish that they would put at date on these stats.
-
-
select
CS.Name0,
NAC.IPAddress0
from
dbo.v_GS_COMPUTER_SYSTEM cs
JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceId = NAC.ResourceId
Where
NAC.IPAddress0 !=''
and DHCPEnabled0 = 0
