Blog Detail
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
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
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
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
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
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
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...
