Class security Level Vs Instance Level Security Rights You can configure the security rights either the class level or the instance level in SMS/SCCM. These rights basically helpful in providing the access to the SMS objects like collection,packages,reports and many more too! class security rights: It applies to the entire class like SMS site.Let say…

some times its hard to know the systems which are having issues in reporting their inventory and even some systems doesnt reporte anything to the site server though the client is installled on it. Here is the collection which gives you all computers which doesnt report inventory for x days(taken 15days). 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…

Below are the basic log files (more understandable way) that are helpful in troubleshooting the client issues if there are any application instllation failure/inventory and other issues.This information has been compiled from Microsoft Knowledge Base Article 867490 A list of windows update error codes can be found here. CAS.log ."CAS" means "Content Access Service". In this Log…

Here are some webcasts related to ConfigMgr and deployment in general. ConfigMgr - Prerequisites Before Installation Installing SQL Server on a Server other than the ConfigMgr Primary Installing SQL 2005 SP2 Local to the ConfigMgr Primary Server In-Place Upgrade of SMS 2003 SP3 with the ITMU to ConfigMgr Mixed Mode Virtual LABS for SCCM 2007  http://technet.microsoft.com/en-us/virtuallabs/bb539977.aspx…
SCCM Configmgr collection report how to check Group policy file updated or not for X days

This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory has to be enabled for GPO file secedit.sdb file which will is available in  %windir%\security\database. collection(WQL): 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 inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName =…

This Report will help you in identifying the collection that are member of any other parent collection. SELECT COL.CollectionID, COL.Name, COL.Comment, CTSC.parentCollectionID FROM dbo.v_Collection COL, dbo.v_CollectToSubCollect CTSC WHERE CTSC.subCollectionID = COL.CollectionID The above report is to get collection with its parent collection but if you want to know the root map of particular, go with…

Gives list of computers where Programs installed recently. SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_INSTALLED_SOFTWARE ISW WHERE ISW.ResourceID = CS.ResourceID ORDER BY ISW.InstallDate0 DESC, CS.Name0, CS.UserName0, ISW.ProductName0