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/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
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
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
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
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
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
https://blogs.technet.com/b/systemcenter/archive/2010/10/14/system-center-configuration-manager-2007-r3-unleashed.aspx
