Bize Ulaşın / Contact Us

How to exclude a collection from a collection in SCCM

14 / 09 / 2012 by SCCM / Configuration Manager Yorum yok / No Comments

To exclude a collection from another collection, add the query below to Criteria section by using Show Query Language window. 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 where SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_CAM001B6) and SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_SMS00011) The bold blue text here is the excluded collection ID. Another example select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, […]

Error Code descriptions for SCCM 2007

19 / 07 / 2012 by SCCM 2007 Yorum yok / No Comments

Links below provide custom error codes and their descriptions for SCCM 2007. They are very helpful. Client Custom Error Codes Desired Configuration Custom Error Codes Inventory Custom Error Codes Mobile Device Management Custom Error Codes Operating System Deployment Custom Error Codes Remote Tools Custom Error Codes Software Distribution Custom Error Codes Software Updates Custom Error […]

Find error code descriptions from decimal long number in SCCM 2007 reports

23 / 05 / 2012 by SCCM / Configuration Manager Yorum yok / No Comments

Convert error code from decimal to hexadecimal 2147746369 > 80040241 -2147220846 > FFFFFFFF80040292 (Ignore first 8 Fs) Converted error codes that begin with 800402 or 800403 are typically System Center Configuration Manager 2007 error codes. Visit for all custom error codes for Configuration Manager 2007. All other error codes are typically Windows error codes […]

Fix for "WARN: Could not get property (domain) for system (0x80005010)"

01 / 01 / 2012 by SCCM / Configuration Manager Yorum yok / No Comments

The Active Directory system discovery process cannot detect a client if the DNS suffix of the client differs from its DNS domain name in System Center Configuration Manager 2007 SP2 To request the hotfix from MS or to see more details : File Information File name File version File size Date Time Platform Adsgdis.dll […]

Create Desktop Shortcut with Script

11 / 11 / 2011 by SCCM / Configuration Manager, Scripting Yorum yok / No Comments

Hi all Today, I have received an application to deploy with SMS Server 2003, I had to create a MSI Package and some scripts to make that application installation most user friendly, actualy something doesn’t need user interaction. So I have needed a script that can find logged user profile folder and create a desktop shortcut […]