I have migrated my blog to a WordPress site, please check the new site at https://paddymaddy.com

I have migrated my blog to a WordPress site, please check the new site at https://paddymaddy.com

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.QueryExpression
FROM         dbo.v_Collection INNER JOIN
                      dbo.v_CollectionRuleQuery ON dbo.v_Collection.CollectionID = dbo.v_CollectionRuleQuery.CollectionID
ORDER 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.
http://sourceforge.net/projects/smstorrent
SMS 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 Interface.
http://sourceforge.net/projects/smssettings
Screen Lock
This Tool does lock the Screen, Mouse and Keyboard for a specified time.
http://sourceforge.net/projects/screenlock
SMS Client Center
Troubleshoot and manage SMS 2003 advanced clients
http://sourceforge.net/projects/smsclictr
SMS 2003 Offline Hardware Inventory
Capture SMS2003 Hardware Inventory on Systems without Network connectivity or Systems without an SMS Agent installed. This Tool creates a DDR (DataDiscoveryRecord) and an IDMIF File for each scanned system.
http://sourceforge.net/projects/smshwinv
Secure Autologon
Enable Windows Autologon without a cleartext password in the Registry. The password will be stored by the Local Security Authority (LSA).
http://sourceforge.net/projects/autologon
SMS2003 Object Backup
Backup and restore a definable set of SMS 2003 Objects (Packages, Programs, Advertisements, Collections...). SMSObjBackup can also be used for Site Migration (Objects can be moved to another SMS Primary Site Server)
http://sourceforge.net/projects/smsobjbackup
SMS 2003 Adv.Client local policy import
A command line tool to assign local software distribution policies to an SMS 2003 Advanced Client. The Software will be installed independent of collection memberships.
http://sourceforge.net/projects/smspolimp
SMS CloneDP
Manage the assigned Software Packages of a Microsoft SMS (SystemManagementServer) 2003 DistributionPoint
http://sourceforge.net/projects/smsclonedp
SMS 2003 Software Request Web Form
SMS 2003 Software Request Web Form with a simple Workflow (mail/web based).
http://sourceforge.net/projects/smsswreq
SMS Collection Commander
Initiate SMS 2003 advanced client actions on a collection: Ping, WakeUp, HW/SW Inventory, ReRun Advertisements, Show logged on user, Download/Refresh Policy, Repair SMS Agents, Import Clients to the Collection...
http://sourceforge.net/projects/smscollctr
SMS OSD Program Import
SMSOSDXML extends the SMS 2003 Admin Console to import OSD Program-Settings based on a XML File. SMS OSD automatically creates such XML Files (SMSDeploy.xml) for each OSD Program created in the Admin Console.
http://sourceforge.net/projects/smsosdxml
SMS Package Dependency Viewer
Show "Microsoft System Management Server 2003" Software Package dependencies in a TreeView.
http://sourceforge.net/projects/smsdepview

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.

1. Open the Windows Management Instrumentation Tester dialog box.
2. In the Windows Management Instrumentation (WMI) Tester dialog box, click Connect.
3. In the Namespace box, type the path to the namespace that you want to connect to.
   Example?
   • To connect to the namespace where the Win32 provider classes reside, type:
     root\cimv2
4. Click Connect.
5. Click Delete Class.
6. In the Get Class Name dialog box, type the name of the class you want to delete, and then click OK.
   A dialog box is displayed to warn you that the class might have derived classes or instances. This dialog box is displayed even if there are no derived classes or instances.
7. If you are sure you want to delete the class, click Yes to delete the class.

Notes

• Performing this task on the local computer does not require you to have administrative credentials. Therefore, as a security best practice, consider performing this task as a user without administrative credentials.
• Performing this task on a remote computer requires that you are a member of the Administrators group on the remote computer, or that you have been delegated the appropriate authority.
• To open the Windows Management Instrumentation Tester dialog box, click Start, click Run, and then type WBEMTest.exe.

Client Site code

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
v_Program
v_Query
v_R_System
v_R_User
v_R_UserGroup
v_RA_System_IPAddresses
v_RA_System_IPSubnets
v_RA_System_IPXAddresses
v_RA_System_MACAddresses
v_RA_System_SMSAssignedSites
v_RA_System_SMSInstalledSites
v_RA_System_SystemContainerName
v_RA_System_SystemGroupName
v_RA_System_SystemOUName
v_RA_System_SystemRoles
v_Report
v_Site
v_SiteBoundary_ADSite
v_SiteBoundary_IPSubnet
v_StateNames
v_UpdateBundles
v_UpdateListStatus_Live
v_UpdatePrograms

Download these next path ::

vnext
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ffca869c-4a83-434e-acc9-8b2388c0c7f7&displaylang=en&hash=AsfGo9XDkf9sIbtk88J1avBWmhXUWCuAjSQj1%2fsZM8VWG9dUPmqIq8n7VvOTw8xKAUCheBh89IzMW23MsS5aCA

scom r2
http://download.microsoft.com/download/E/2/9/E29F1A2F-78B0-4B11-9517-435A2627A72F/OPSMGR2007R2EVAL.exe

service manager
http://download.microsoft.com/download/8/5/2/8529ED85-8D64-4662-A337-2DCA431C495B/SCSM_RETAIL.exe

Data Protection Manager

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d

Opalis

http://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 that enables the administrator to apply a task sequence to the device that can use the pre-staged media.
• Dynamic Collection Evaluation: Enables you to rapidly evaluate a collection membership by adding only newly discovered resources.
• Active Directory Delta Discovery: Performs an intermediate discovery cycle that adds only new resources to the Configuration Manager 2007 database.
• Simplified Resource Management: Enables you to search for and add resources to a specified collection.
• Desired Configuration Management: Enables you to create a collection of compliant or noncompliant computers in desired configuration management.
• Higher Number of Supported Clients Per Hierarchy: Configuration Manager 2007 R3 supports up to 300,000 clients per hierarchy when it uses the default settings for all Configuration Manager 2007 features. This increase in supported clients is the result of improvements to the Active Directory synchronization and Collection Evaluation processes

Test post

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 in System Center Configuration Manager v.Next
• TechNet Virtual Lab: Implementing Software Updates in System Center Configuration Manager v.Next
• TechNet Virtual Lab: Deploying a System Center Configuration Manager v.Next Hierarchy
• TechNet Virtual Lab: Basic Software Distribution in System Center Configuration Manager v.Next
• TechNet Virtual Lab: Advanced Software Distribution in System Center Configuration Manager v.Next

You can find the labs all on the TechNet Virtual Lab page here.
Don’t forget, tomorrow the Community Evaluation Program for ConfigMgr v.Next starts.  More information on that is here.