Blog Detail

Don Hite

Don Hite

http://myitforum.com/cs2/blogs/dhite/default.…

Tags: Break Time, By Request, Microsoft SQL Server, Odds & Ends, PowerShell, SMS 2003 SQL Queries, Vbs Scripts

View More Recent Posts

  • Setting Configuration Manager Web Reports and R2 Reporting Services Display Options

    Posted on Friday January 29th, 2010 at 03:05 pm in configmgr 2007

      Here you will find the steps necessary to set or configure ConfigMgr 2007 Web Reports or ConfigMgr 2007 R2 Reporting options to open the selected reports within the console or with Internet Explorer.   1. Open the Configuration Manager c...

  • SQL Query To Retrieve SQL Server TCP EndPoint Information

    Posted on Friday January 29th, 2010 at 11:01 am in sql queries

      The SQL Query here will allow you to retrieve information from your SQL Server installation pertaining to your TCP Endpoints.   SQL Query:   Select Name 'Endpoint Name', 'Protocol' = Case When Protocol = 1 Then ...

  • TechNet Magazine: SQL Server Reporting Services and SCCM

    Posted on Thursday January 28th, 2010 at 01:11 pm in configmgr 2007

      In the January 2010 Issue of TechNet Magazine Microsoft’s Steve Rachui has a great write up on System Center Configuration Manager: SQL Server Reporting Services and System Center Configuration Manager.   Check it out and drop by h...

  • VBS Script To Last Hardware Scan Information For A Collection

    Posted on Wednesday December 23rd, 2009 at 01:58 pm in vbs scripts

      This VBS script will return the last Hardware Scan information for all the resources in a specified collection.   Note: Change the All Systems collection _Res_Coll_Sms00001 to any other collection needed.   VBS Script:   strServ...

  • Get Domain Machines And Versions From Active Directory

    Posted on Wednesday December 23rd, 2009 at 01:48 pm in vbs scripts

      This VBS script will allow you to retrieve the machine names and their appropriate Network Operating Systems (NOS) names from Active Directory.   VBS Script:   Set objExcel = CreateObject("Excel.Application") objExcel.Visib...

  • Common SMS Log File Names

    Posted on Wednesday December 23rd, 2009 at 01:43 pm in configmgr 2007

      Provided here for your reference - and mine - is a list of the more common SMS log files with an easy to use description of each.   Client Component Installation Manager - Ccim Client Configuration Manager - Ccm Client Install Data Mana...

Post A Comment/Review

Log In or Sign Up to leave a comment.