Today I want to edit an task sequence within SCCM 2012 and I received the following error message: “Cannot edit the object, which is in use by site P01”. Mmmm….that’s strange!! I’m the only Sysadmin with an ConfigMgr 2012 Management Console. To unlock this object, I’ve used an query within SQL.
1.) Open the SQL Management Console and navigate to the ConfigMgr database
2.) Open a new query
3.) To view all the locked objects, type the following query:
select * from SEDO_LockState
Execute the query and watch te results
4.) We see one object that is locked
5.) Note the ID of this specific object
6.) To unlock this object, type the following query:
delete from SEDO_LockState where ID=’ID of the object’
Execute the query and watch the results
7.) Now the object is succesfully unlocked and you’re able to edit the task sequence
Finally my new home lab environment is up and running. After building a copple of hours, my new monster was ready to rock!! I’ve installed Windows Server 2012 with the Hyper-V server role….and WOW, it really rocks!! The next few moths I’m going to build a big environment, with System Center 2012, Exchange 2013, Windows Server 2012 and many, many, many more cool products!! 🙂
* AMD A8 3870K 3.00GHz 4MB FM1 Box
* Asus F1A75-V PRO AMD A75, SATA600 RAID, HDMI
* Corsair 32GB PC3-14900 DDR3 SDRAM Vengeance (4x 8GB, 1866MHz)
Yesterday and today I passed the 70-246 and 70-247 exams! Right now I’m officially Microsoft Certified Solutions Expert 2012 Private Cloud (MSCE 2012). After a couple of months preperation, reading books, reading blogpost and building, building and again building some lab environments, the big day was there!! After two hours, I hit the the final button….YES, passed the first exam! Today I also passed the second exam!
With the upcoming TechEd Europe 2013 event in Madrid, it’s a great timing to have the MSCE 2012 Private Cloud status in the pocket. Do you know where I’m going to dream about this night….right, my own private cloud!! 😉
When you have multiple computer models in your organization, you have different driver packages available. Each model has his own driver package. You don’t want to use a task sequence per model, but only one task sequence with multiple models in it with different driver packages. This can be accomplished by using a WMI query within your task sequence.
One mayor thing you have to know are the exact computer models in your organization
1.) Create a new task sequence. (in my example Windows 7)
2.) Add a task Apply Driver Package
3.) Select the right Driver Package
4.) Navigate to the Options tab
5.) On the target PC open the command prompt
6.) The next thing you want to know is the hardware model of the target PC.
WMIC ComputerSystem GET model
In my example it is an Dell OptiPlex 9010 as you can see
7.) Navigate back to your task sequence in the Options tab
8.) The WMI namespace will be root\cimv2
9.) The WQL Query will be SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%OptiPlex 9010”
10.) Now the right driver package will be installed during your task sequence.