Category Archives: System Center

How to change SCCM 2012 Site name

Posted on January 14, 2013 by Idit Bnaya

1. Open to SQL Server management studio 2. Under databases 3. Open your SCCM DB 4. Search for Table called – dbo.SC_SiteDefinition 5. Right click – Edit top 200 Rows   6. Change the name. Idit Bnayawww.itblog.co.il

Posted in SCCM 2012 | Leave a comment

SCCM 2012 – Error: some drivers cannot be imported successfully

Posted on December 30, 2012 by Idit Bnaya

  As soon as you Detach an reattach the SCCM database in SQL, two properties are changed, and SCCM isn’t able to do certain operations, as importing drivers, or applications. In my case I got this error when trying to … Continue reading →

Posted in SCCM 2012 | Leave a comment

How to- Deploy Office 2010 using SCCM 2012

Posted on December 23, 2012 by Idit Bnaya

  1. MSP file The first step is to create a customize MSP file: 1. Open CMD type setup.exe /admin at the command line from the root of the network installation point that contains the Office 2010 source files for … Continue reading →

Posted in SCCM 2012 | Leave a comment

SCCM – Collection Queries

Posted on August 6, 2012 by Idit Bnaya

Name: All sccm  clients requiring a reboot Query:  select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from sms_r_system AS sms_r_system inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid where c.LastEnforcementMessageID = 9 ____________________________________________________________________________________________________________________________ Name: All SCCM client  computers in a specific site Description … Continue reading →

Posted in SCCM 2012, SCCM 2012 R2, SCCM2007 | Leave a comment