ALL Collections WQL and collection ID and Names in a Site

SELECT     TOP (100) PERCENT dbo.v_Collection.Name, dbo.v_Collection.CollectionID, dbo.v_CollectionRuleQuery.RuleName, dbo.v_CollectionRuleQuery.QueryID,                       dbo.v_CollectionRuleQuery.LimitToCollectionID, dbo.v_CollectionRuleQuery.QueryExpressionFROM         dbo.v_Collection INNER JOIN                      dbo.v_CollectionRuleQuery ON dbo.v_Collection.CollectionID = dbo.v_CollectionRuleQuery.CollectionIDORDER BY dbo.v_Collection.Name, dbo.v_Collection.CollectionID

SMS 2003 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/smstorrentSMS Site Settings tweak SMSSettings provides a GUI to modify SMS2003 (Microsoft System Management Server 2003) Site Settings which are not accessible over the normal SMS Admin … Read more

WMI delete

To delete a class You can delete a class in the current namespace with Delete Class on the Windows Management Instrumentation Tester dialog box. Open the Windows Management Instrumentation Tester dialog box. In the Windows Management Instrumentation (WMI) Tester dialog box, click Connect. In the Namespace box, type the path to the namespace that you … 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

Download these next path ::

vnexthttps://www.microsoft.com/downloads/en/details.aspx?FamilyID=ffca869c-4a83-434e-acc9-8b2388c0c7f7&displaylang=en&hash=AsfGo9XDkf9sIbtk88J1avBWmhXUWCuAjSQj1%2fsZM8VWG9dUPmqIq8n7VvOTw8xKAUCheBh89IzMW23MsS5aCA scom r2https://download.microsoft.com/download/E/2/9/E29F1A2F-78B0-4B11-9517-435A2627A72F/OPSMGR2007R2EVAL.exe service managerhttps://download.microsoft.com/download/8/5/2/8529ED85-8D64-4662-A337-2DCA431C495B/SCSM_RETAIL.exe Data Protection Manager https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d Opalis https://download.microsoft.com/download/D/F/C/DFC9F061-65A9-44C0-9012-450A7B8697CC/Opalis_180_Day_Evaluation.exe

SCCM R3 Provides

The following features are new to Configuration Manager 2007 R3. Power Management: Provides a set of tools that enable the site administrator to configure standard Windows power settings across computers and monitor power consumption and computer activity. Operating System Deployment Improvements: Provides pre-staging of boot images and Windows Imaging Format (.wim) files on new computers … Read more

V.Next: Configuration Manager and Systems Management Server

Configuration Manager and Systems Management Server TechNet Virtual Lab: Deploying System Center Configuration Manager v.Next TechNet Virtual Lab: Maintaining Healthy Clients in System Center Configuration Manager v.Next TechNet Virtual Lab: Introduction to System Center Configuration Manager v.Next TechNet Virtual Lab: Implementing Settings Management in System Center Configuration Manager v.Next TechNet Virtual Lab: Implementing Role-Based Administration … Read more