Category Archives: System Center

How to change SCCM 2012 Site name

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

  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

  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

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