SQL Queries

SCCM 2007 / SMS 2003 SQL Package Related Query

by

———————————————————————————————————————————–SQL Query:–>———————————————————————————————————————————– To know the package Name and ID SELECT     PackageID, NameFROM         dbo.v_Package———————————————————————————————————————————– ———————————————————————————————————————————–SQL Query:–> If you want to filter with the package ID then modify the Query to SELECT     PackageID, NameFROM         dbo.v_PackageWHERE     (PackageID = 'YourPKGID') ———————————————————————————————————————————–——————-Thanks,https://sccm07.blogspot.com/

Troubleshooting SMS 2003 MP and SLP

by

Troubleshooting SMS 2003 MP and SLP This article provides methods to verify the operation of Management Points and Server Locator Points in Microsoft SMS 2003 Test a management point is functioning correctly: https://MP_Server/sms_mp/.sms_aut?mplist – This returns a blank screen if the MP is working correctly. https://MP_Server/sms_mp/.sms_aut?mpcert – This returns a hex string if the MP … Read more

SQL 2008 TechNet Webcasts

by

SQL 2008 TechNet Webcasts   Provided here are links to Microsoft TechNet SQL 2008 Webcasts available in Windows Media Player (WMA), Zune and MP3 format.   SQL-300 What's New In Microsoft SQL 2008 In this session, we will go through an overview tour of the new features of SQL Server 2008, split into four core … Read more

Active Directory Scripts

by

Active Directory Scriptinghttps://www.microsoft.com/technet/scriptcenter/guide/sas_ads_overview.mspx?mfr=true ——————————————————————————————– rem this code creates a user account with the common name MyerKen: Set objOU = GetObject("LDAP://ou=Management,dc=NA,dc=fabrikam,dc=com")Set objUser = objOU.Create("User", "cn=MyerKen") objUser.Put "sAMAccountName", "myerken"objUser.SetInfo Attribute Default Setting pwdLastSet User must change password at next logon userAccountControl Password Not Required userAccountControl Account Disabled ———————————————————————Setting a User Account Password Set objUser = GetObject _("LDAP://cn=MyerKen,ou=Management,dc=NA,dc=fabrikam,dc=com") … Read more

VBSCRIPT To Shutdown Exchange 200x server

by

  ' StopService.vbs' Author Guy Thomas https://computerperformance.co.uk ' Version 2.7 – March 2005 ' —————————————-' ' Option Explicit Dim objService, objWMI, colListOfServices, intExSrvDim strExService1, strExService2, strExService3, strExService4Dim strComp, strWMIsrv '  Amend strExService if you do not have exchange e.g. Alerter strExService1 = "MSexchangeIS"strExService2 = "MSexchangeMTA"strExService3 = "MSexchangeSA"strExService4 = "MSexchangeSRS"intExSrv = 1 ' Loops through all … Read more

Simple Troubleshooting Management Points

by

  Just below point when ever you stuck with MP issues 1) Run https://<MP name>/sms_mp/.sms_aut?mplist This returns a blank screen. 2) Run https://<MP name>/sms_mp/.sms_aut?mpcert This returns a long list of numbers and letters. 3) Verify that the DTS Service is enabled. 4) Verify that the Task Scheduler is enabled. 5) Verify that the Windows Management … Read more

SMS Support Webcasts Archive

by

SMS Support Webcasts Archive     2004 Webcasts • TechNet Webcast: Managing a Microsoft Windows Server 2003 Network – (Part 3 of 4) December 15, 2004: This webcast is the third in a four-part series that examines key aspects of proactive Windows Server 2003 network management. In the third part we will focus on using … Read more

Step by Step guide for Installing and Configuring SCCM 20007 and Applying SP1 Build

by

ConfigMgr (SP1) Setup Guide   Step by Step guide for Installing and Configuring SCCM 20007 and Applying SP1 Build Extend the Active Directory Schema – There is no reason not to! Four actions need to be taken in order to successfully enable Configuration Manager clients to query Active Directory Domain Services to locate site resources: … Read more