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
Thursday, December 2, 2010
ALL Collections WQL and collection ID and Names in a Site
Tuesday, November 30, 2010
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
Thursday, November 4, 2010
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 want to connect to.
Example?- To connect to the namespace where the Win32 provider classes reside, type:
root\cimv2
- To connect to the namespace where the Win32 provider classes reside, type:
- Click Connect.
- Click Delete Class.
- 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. - 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.
Wednesday, October 20, 2010
Tuesday, October 19, 2010
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 |
Monday, October 18, 2010
Download these next path ::
service manager
http://download.microsoft.com/download/8/5/2/8529ED85-8D64-4662-A337-2DCA431C495B/SCSM_RETAIL.exe
Data Protection Manager
Opalis
http://download.microsoft.com/download/D/F/C/DFC9F061-65A9-44C0-9012-450A7B8697CC/Opalis_180_Day_Evaluation.exe
Saturday, October 16, 2010
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