Patching Related End to end – Collections and reports :-

Below is for a compliance report based on SQL declare @CollectID AS  varchar(8)SET @CollectID= ‘SMS0001’ declare @CollectionListID AS  varchar(90)SET @CollectionListID=’ScopeId_5432f432-F885-4A98-B666-5432134122/AuthList_F15C63EA-B655-4940-A250-654323fd432′ declare @CI_ID int; select @CI_ID=CI_ID from v_ConfigurationItems where CIType_ID=9 and CI_UniqueID=@CollectionListID declare @CollCount int, @NumClients int; select @CollCount = count(*), @NumClients=isnull(sum(cast(IsClient as int)), 0) from v_ClientCollectionMembers ccm where ccm.CollectionID=@CollectID select     CollectionName=vc.Name,    ‘Update List’=al.Title,    Status=sn.StateName,    … Read more

NAP

https://blogs.technet.com/b/ryanan/archive/2008/04/01/struggling-to-configure-network-access-protection-with-sccm.aspx

AutoCAD Mof File for all versions

:::::::::::::::SMS_def.mof file::::::::::::::: #pragma namespace (“\.rootcimv2sms”) [ SMS_Report (TRUE),SMS_Group_Name (“AutoCAD 14”),SMS_Class_ID (“CUSTOM|AUTOCAD_14|1.0”) ]class Win32Reg_AutoCAD_14 : SMS_Class_Template{    [SMS_Report (TRUE), Key ] string KeyName;    [SMS_Report (TRUE)] string ProductName;    [SMS_Report (TRUE)] string Release;    [SMS_Report (TRUE)] string SerialNumber;    [SMS_Report (TRUE)] string StandaloneNetworkType;}; [ SMS_Report (TRUE),SMS_Group_Name (“AutoCAD 2000”),SMS_Class_ID (“CUSTOM|AUTOCAD_2000|1.0”) ]class Win32Reg_AutoCAD_2000 : SMS_Class_Template{    [SMS_Report (TRUE), Key ] string KeyName;    [SMS_Report (TRUE)] … Read more

Confimgr / SCCM Pro / Cons

ConfigMgr 2007 Limitations     What is DISTRIBUTION POINT (DP): A site system that has the role of storing package source files. Clients contact distribution points to obtain source files when they run advertised programs, advertised task sequences, or deployed software updates.Types of Distribution Points: Some distribution point types are not compatible with other distribution … Read more

ConfigMgr/ SCCM Pro / Cons

ConfigMgr 2007 Limitations     What is DISTRIBUTION POINT (DP): A site system that has the role of storing package source files. Clients contact distribution points to obtain source files when they run advertised programs, advertised task sequences, or deployed software updates.Types of Distribution Points: Some distribution point types are not compatible with other distribution … Read more