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

SCCM – Roger Zander Sourceforge Tools

Roger Zander Sourceforge Tools And Utilities SMS/SCCM Peer2Peer AddOn SMSTorrent is a Peer2Peer AddOn for SMS2003/SCCM2007 Clients. SMS/SCCM Clients are able to share the local Package cache with other Clients using the BitTorrent filesharing protocol. https://sourceforge.net/projects/smstorrent SMS Site Settings tweak SMSSettings provides a GUI to modify SMS2003 (Microsoft System Management Server 2003) Site Settings which … Read more

Use Full SQL Tables / Views

UseFull SQL Tables/ Views Description / Use v_Add_Remove_Programs   v_Advertisement   v_AdvertisementInfo   v_ClientCollectionMembers   v_Collection   v_Collection   v_ConfigurationItems   v_DistributionPoint   v_DistributionPointGroup   v_GS_ADD_REMOVE_PROGRAMS   v_GS_ADD_REMOVE_PROGRAMS_64   v_GS_COMPUTER_SYSTEM   v_GS_DISK   v_GS_Memory_Details0   v_GS_OPERATING_SYSTEM   v_GS_PATCHSTATE   v_GS_SERVICE   v_GS_SoftwareProduct   v_GS_SYSTEM   v_GS_WORKSTATION_STATUS   v_GS_X86_PC_MEMORY   v_OS_Details   v_Package   v_PackageStatus   … Read more

You must know these collections as handy : Collections End to End

1.Client all system collection 2.Non client systems 3.Inactive systems 4.Obsolete system 5.Duplicate client Yes or No 6. Last hardware inventory 14 days 7.Last software inventory 14 days 8.Last Data discovery cycle. 9. XYZ package, XYZ Advertisement success systems’ collection 10. XYZ package, XYZ Advertisement Failed systems’ collection 11.XYZ subnet collection system 12.Add XYZ system’s to … Read more

SQL Reporting Services: SRS

SQL Reporting services have some benefits over the current reporting solution: Provide best in class reporting capability by integrating SQL Reporting Services, with the leading change and configuration management product: SCCM 2007 Enable Ad-hoc reporting – Make it easy for both SCCM administrators, and non administrators to find the information they need to make the … Read more

Systems Part of What Collections

–Systems Part of What Collections SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = ‘Systemname’)

For finding the 90 days old computers in the AD

    For finding the 90 days old computers in the AD DSQUERY COMPUTER “DC=MydomainName,DC=COM” -STALEPWD 90 -LIMIT 5000 >> C:output.csv for finding the 90 days old computers in the AD & action to delete with the output DSQUERY COMPUTER “OU=COMPUTERS,DC=LANDESK,DC=COM” -STALEPWD 90 -LIMIT 5000 | DSRM -NOPROMPT >C:Output.csv