Microsoft Product Support Reporting Tool - SQL Server 32/64-bit Edition ======================================================================== Version: v9.14.2004.3264 Build Date: 09/14/04 PURPOSE: ======== The MPS Reporting Tool is utilized to gather detailed system status and configuration information. The data collected will assist the Microsoft Support Professional with fault isolation. The reporting tool DOES NOT make any registry changes or modifications to the operating system. Please see the section for PACKAGE CONTENTS and DIRECTORY STRUCTURE for details on what is copied to the system and what directories are made. NOTE: You may install and use an unlimited number of copies of MPSRPT_SQL.EXE solely for the purpose of gathering system information necessary for Microsoft Product Support Services to provide you with technical support services requested by you. All other purposes are not supported by Microsoft. Please refer to the EULA for more detailed information regarding your usage rights. USAGE: ====== The MPS Reporting Tool is self-installing and will run on Windows NT 4.0, Windows 2000, Windows 2003, and Windows XP. Every time you run MPSRPT_SQL.EXE it will install itself, overwriting the previous installation then call MPSRpt.cmd to gather the reports. Use the /Q option to install the Tool without running the report. 64-bit Version Installation ============================ If you are using this version of the tool on a 64-bit Windows 2003 you must launch this tool using the Start\Run option by entering the following command line or locating the path shown in the command line and double-clicking on the MPSRpt.cmd: %windir%\MPSReports\SQLServer\bin\MPSRpt.cmd Latest Version Availability =========================== The links latest version of the various versions of the MPS Reporting tool are listed in KB: 816819 Description of the Microsoft Platform Support Reporting Utility http://support.microsoft.com/?id=816819 Command line install options ============================== Example: MPSRPT_SQL.EXE /Q The Tool has two reporting modes: Lite (default) and Full. Either mode can be run with the /Q Quiet-option. The Quiet-option reduces the amount of user interaction with the Tool. Lite Mode - Executing MPSRPT_SQL.EXE with no command line options run the Tool in LITE reporting mode. Examples: MPSRPT_SQL.EXE MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /Q" Full Mode - Full mode can take an extended period of time to gathering information and should only be run when directed by a Microsoft Support Professional. Examples: MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /F" MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /F /Q" The above examples show how to install the tool and run the reports with the options Full reporting and Quiet mode. The default behavior (using no command-line options) is Lite reporting in Verbose mode. ALTERNATE INSTALLATION PATH =========================== It is now possible to instruct MPS Reports to be installed to an alternate location (eg. other than %SYSTEMROOT%). This is especially useful if your system drive is low on available disk space. The /P option has been added to the Setup.cmd script to allow you to specify an alternate location. This folder must exist and the name cannot include spaces. The MPS Reporting tool will not create it. The folder specified becomes new root folder for the MPSReports folder tree. All of the data collected will also be logged to this location. The following example illustrates how to use the /P option: MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /P D:\data" This results in the MPSReports folder being created as a subfolder of D:\data. This alternate installation path is recorded in the MPSRPT.CMD script. Therefore, it is possible to run the MPSRPT.CMD script from the alternate location and expect that all data will be logged to that same alternate location. Please see the section for PACKAGE CONTENTS and DIRECTORY STRUCTURE for details on what is copied to the system and what directories are made. Batch File command options =========================== If the Tool is already installed, you can execute the MPSRpt.cmd batch file from the Bin folder. Examples: MPSRpt.cmd MPSRpt.cmd /F MPSRpt.cmd /F /Q MPSRpt.cmd /Q For your convenience CAB file containing all of the reports will be created. Please send the cab file to the Microsoft Support Professional who is working on your support incident. Each time your run the Tool it will overwrite any existing report files. However, a new CAB file will be created. If you need to look at an older report you can extract it from the old CAB file. Running MPS Reports as a scheduled job -------------------------------------- MPS Reports can be run as a scheduled job. It should be run in QUIET mode to prevent extraneous user interface windows from being invoked. Use one of the following example command-lines when scheduling the job: MPSRpt.cmd /Q MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /Q" MPSRpt.cmd /F /Q MPSRPT_SQL.EXE /C:"cmd /c Setup.cmd /F /Q" Here is an example use the AT command to schedule MPS Reports: AT 1:00am %SystemRoot%\MPSReports\SQLServer\bin\MPSRpt.cmd /Q NOTES: ====== Average completion times for the MPS Reporting Tool Lite Mode are in the range of 10 to 30 minutes. Gathering of MSINFO, Event log information, SQLDiag reporting and Checksym information for the system32 directory normally take the longest time. If for some reason the data collection process is not completing try running the tool during non-peak usage times. Full Mode should only be run during non-peak usage times or on systems that are not under heavy load. Should the tool seem to hang the progress report will state the name of any executable being used and you could kill choose to end that process from your task manager. To ensure that all of the data is collected properly, the user running the MPS Reporting Tool must have Administrative rights on the system. If you have any questions regarding the usage or operations of the Tool, consult with your Microsoft Support Professional. Known 64-bit issues under investigation: ======================================== Ipconfig not fully supported on 64-bit systems, see 836829 You cannot run the 32-bit version of the Ipconfig.exe tool on Windows (http://support.microsoft.com/?id=836829) for details. Checksym.exe fails on AMD 64-bit systems. DIRECTORY STRUCTURE: ==================== %SystemRoot% Example - C:\WINNT \MPSReports MPS Reports root folder - can contain many support specific versions \SQLServer \bin Tools folder - non-version specific \x86 Folder for Intel I386-based tools \1381 Windows NT specific tools \2195 Windows 2000 specific tools \2600 Windows XP specific tools \3700 Windows 2003 specific tools \SQL2K SQL Server 2000 version specific tools & scripts \SQL2K5 SQL Server 2005 version specific tools & scripts \SQLSrvr Common SQL Server script for SQL Server specific information \AMD64 AMD 64-bit specific tools \IA64 Intel 64-bit specific tools \rpt Report output folder for the SQL Server Edition of MPS Reports \cab Output folder for the CAB files \doc Folder containing Readme and other files PACKAGE CONTENTS: ================= File Size Date Version -------------------- --------- ---------- ------------ MPSTools.exe 1,415,772 08-04-2004 5.1.2600.0 Setup.cmd 4,265 08-04-2004 8.00.2004 MPSTools.exe CONTENTS: ====================== File Size Date Version -------------------- ---------- ---------- ------------ BIN\GETEVENTS.VBS 4,536 04/13/2004 VBScript Script File used in event log gathering BIN\MPSRpt.CMD 106,879 08-05-2004 Windows NT Command Script for gathering report information. BIN\x86\CHOICE.EXE 88,576 05-19-2003 5.2.3765.0 BIN\x86\CHECKSYM.EXE 233,472 11-06-2003 2.5.0.0 BIN\x86\CLUSINFO.EXE 57,344 02-22-2003 NA BIN\x86\CLUSMPS.EXE 249,911 06-16-2004 NA BIN\x86\DUMPEL.EXE 53,248 05-22-2002 6.0.2600.1 BIN\x86\DUMPEVT.EXE 28,672 05-05-2004 NA BIN\x86\FCINFO.EXE 55,808 03-27-2004 5.2.3790.1166 BIN\x86\FLTRFIND.EXE 40,960 08-26-2003 NA BIN\x86\HBAAPI.DLL 33,792 03-27-2003 5.2.3790.1166 BIN\x86\HBATAPI.DLL 12,800 03-27-2003 NA BIN\x86\MPSRPT.CMD 53,816 07-08-2003 4.8.0.0 BIN\x86\QFECHECK.EXE 33,792 12-18-2001 5.1.2600.24 BIN\x86\REG.EXE 49,424 09-10-2001 NA BIN\x86\RPCDUMP.EXE 90,159 07-07-2003 2.0.0.0 BIN\x86\SHOWPRIV.EXE 32,768 04-07-2003 NA BIN\x86\TLIST.EXE 19,968 05-19-2003 6.0.4019.0 BIN\x86\UNSGNDRV.EXE 49,152 09-10-2003 1.0.0.1 BIN\x86\SETSPN.EXE 10,240 05-02-2002 5.2.3630.0 BIN\x86\SQLSCAN.EXE 53,760 02-10-2003 3.0.3.0 BIN\x86\1381\MAKECAB.EXE 81,168 11-30-1999 5.0.2147.1 BIN\x86\1381\PSTAT.EXE 43,792 08-08-1996 4.0.1371.1 BIN\x86\1381\REG.EXE 56,080 07-12-2003 NA BIN\x86\2195\GPRESULT.EXE 61,200 11-29-1999 5.0.2184.1 BIN\x86\2195\NETDIAG.EXE 389,904 03-15-2002 5.0.2195.5080 BIN\x86\2195\PSTAT.EXE 9,488 11-30-1999 5.0.2134.1 BIN\x86\2195\REG.EXE 49,424 09-25-1999 2.0.0.0 BIN\x86\2195\SHOWPRIV.EXE 32,768 04-07-2003 NA BIN\x86\2600\GPRESULT.EXE 61,200 11-29-1999 5.0.2184.1 BIN\x86\2600\NETDIAG.EXE 321,536 08-17-2001 5.1.2600.0 BIN\x86\2600\PSTAT.EXE 8,704 08-17-2001 5.1.2600.0 BIN\x86\3700\GPRESULT.EXE 138,752 03-24-2003 5.2.3790.0 BIN\x86\3700\NETDIAG.EXE 382,976 03-24-2003 5.2.3790.0 BIN\x86\3700\PSTAT.EXE 8,704 08-17-2001 5.1.2600.0 BIN\x86\3700\SHOWPRIV.EXE 32,768 04-07-2003 NA BIN\x86\SQL2K\OSQL.EXE 53,299 08-06-2000 2000.080.0194.00 BIN\x86\SQL2K5\OSQL.EXE 37,888 07-20-2000 2000.090.0852.00 (BETA 2) BIN\x86\SQLSRVR\REPLINFO.SQL 1,458 04-04-2004 SQL Server script for replication configuration discovery 32-bit only, inconsistent on 64-bit. BIN\x86\SQLSRVR\SPCONFIG.SQL 269 08-18-2004 SQL Server script for SQL Server configuration settings BIN\x86\SQLSRVR\SQL.VBS 52,618 09-15-2004 1.0 BIN\AMD64\CHECKSYM.EXE 194,048 03-15-2004 6.0.4067.0 BIN\AMD64\QFECHECK.EXE 49,664 03/22/2004 6.1.0.0 BIN\IA64\CHECKSYM.EXE 348,672 11-06-2003 6.0.4053.0 BIN\IA64\QFECHECK.EXE 89,600 03/22/2004 6.1.0.0 Documentation Description -------------------- ------------------------------------------------ Doc\EULA.TXT End-User License Agreement Doc\README.txt Documentation for MPS Reporting tool (this file) Doc\SQLSCAN.txt Documentation for Slammer vulnerability detection tool Doc\SETSPN_D.txt Documentation for the setspn.exe tool Report files created in LITE mode: ================================== .Net Framework Registry ======================== %COMPUTERNAME%_NETFRAMEWORK_REG.TXT .NET Framework registry Cluster Information =================== - gathers information about MSCS and WLBS if these services are configured on the system. %COMPUTERNAME%_WLBS.TXT - configuration of the Windows Load Balancing Service %COMPUTERNAME%_CLUSTERINFO.TXT - configuration state and resource information from CLUSTER.EXE %COMPUTERNAME%_Cluster_MPS_Information.txt - Cluster configuration information from Clusinfo.exe %COMPUTERNAME%_CLUSTER_REGISTRY.HIV - Cluster service registry hive %COMPUTERNAME%_CLUSTERFILES.[CSV/TXT] - file version information for Cluster Service binaries %COMPUTERNAME%_CLUSTER.LOG - cluster log file %COMPUTERNAME%_CLUSTER_CLCFGSRV.LOG - ClCfgSrv.log file %COMPUTERNAME%_CLUSTER_OBJ.TXT - cluster.obj file %COMPUTERNAME%_CLUSTER_OML.TXT - cluster.oml file %COMPUTERNAME%_CLUSTER_CHKDSK*.LOG - copy of all cluster chkdsk logs Event logs =========== - The event logs are captured in both native and CSV format to allow analysis by different tools. %COMPUTERNAME%_EVENT_LOG_Application.evt - only gathered in Full mode %COMPUTERNAME%_EVENT_LOG_Security.evt - only gathered in Full mode %COMPUTERNAME%_EVENT_LOG_System.evt - only gathered in Full mode %COMPUTERNAME%_EVENT_LOG_Application.CSV and TXT %COMPUTERNAME%_EVENT_LOG_Security.CSV - only gathered in Full mode %COMPUTERNAME%_EVENT_LOG_System.CSV and TXT - The following event logs are only created on Windows 2000 or later and only if the specific service is installed. %COMPUTERNAME%_Directory_Service.evt %COMPUTERNAME%_DNS_Server.evt %COMPUTERNAME%_EVENT_LOG_Directory Service.CSV %COMPUTERNAME%_EVENT_LOG_DNS Server.CSV %COMPUTERNAME%_EVENT_LOG_File Replication Service.CSV %COMPUTERNAME%_File_Replication_Service.evt Hotfix information ================== - information about hotfix install history %COMPUTERNAME%_HOTFIX.TXT HP(Compaq) logging ================== %COMPUTERNAME%_HPSurvey.TXT - Copy of Survey report if it exists %COMPUTERNAME%_HPSETUP.TXT - Copy of the HP(Compaq) setup log %COMPUTERNAME%_HP-SSDSetup.TXT - Copy of the HP(Compaq) SSD setup log IIS Metabase Information ==================== %COMPUTERNAME%_METABASE.txt Uses adsutil.vbs script already on system with the enumerate_all switch to gather IIS configuration information Internet Explorer Information ============================== - log files and registry settings for IE %COMPUTERNAME%_IESETUPLOG.TXT - Installation log %COMPUTERNAME%_IEBRNDLOG.TXT - Branding log %COMPUTERNAME%_IEPOLICYREG.TXT - Dump of policy registry keys for IE %COMPUTERNAME%_Signup.Log - ISP signup log %COMPUTERNAME%_Install.ins - Custom installation log iSCSI Information ================== %COMPUTERNAME%_iSCSI.TXT - Information for Microsoft iSCSI software Fibre Channel Information (FCINFO.EXE) ====================================== %COMPUTERNAME%_FIBRE_CHANNEL_INFO.TXT - HBA information from HBAAPI compliant Fibre Cards Group Policy Information ========================= %COMPUTERNAME%_GPResult.txt - Shows which policies are applied to the machine. MDAC Information ================ %COMPUTERNAME%_MDAC_CurrentControlSet.TXT - HKLM\System\CurrentControlSet %COMPUTERNAME%_MDAC_DAHOTFIX.TXT - %SYSTEMROOT%\dahotfix.log %COMPUTERNAME%_MDAC_DASETUP.TXT - %SYSTEMROOT%\DASETUP.LOG %COMPUTERNAME%_MDAC_ExceptionComponents.TXT - HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents %COMPUTERNAME%_MDAC_HKCR_CLSID - HKCR\CLSID %COMPUTERNAME%_MDAC_HKCU_ODBCREG.TXT - HKCU\SOFTWARE\ODBC %COMPUTERNAME%_MDAC_HKLM_ODBCREG.TXT - HKLM\SOFTWARE\ODBC registry entries %COMPUTERNAME%_MDAC__CURRENTVERSION_REG.TXT - HKLM\SOFTWARE\Microsoft\windows\currentversion %COMPUTERNAME%_MDAC__ORACLE_REG.TXT - HKLM\SOFTWARE\Oracle,HKLM\SOFTWARE\Microsoft\MSDTC\MTxOCI "HKLM\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer" registry key values Microsoft Analysis Server Information - OLAP inventory ====================================================== %COMPUTERNAME%_OLAPSTP.log - setup log %COMPUTERNAME%_OLAPSP.log - setup log %COMPUTERNAME%_OLAPSERVER_REG.HIV - OLAPServer registry in HIV format, not available on Windows 2003 servers %COMPUTERNAME%_OLAPSERVER_REG.TXT - OLAPServer registry in text format %COMPUTERNAME%_OLAP_OLEDB.[CSV/TXT] - File version reporting for Program Files\Common Files\System\OLE DB folder %COMPUTERNAME%_OLAP_DSO.[CSV/TXT] - File version reporting for Program Files\Common Files\Microsoft Shared\DSO folder %COMPUTERNAME%_OLAP.[CSV/TXT] - File version reporting for Program Files\Analysis Services folder Network configuration ===================== - various network configuration and current state information %COMPUTERNAME%_NETINFO.TXT %COMPUTERNAME%_MISC.TXT %COMPUTERNAME%_HOST.TXT %COMPUTERNAME%_LMHOST.TXT Network Diagnostics Reporting ============================= %COMPUTERNAME%_NETDIAG.TXT - Network / Domain Diagnostics Process Information =================== - inventory of the currently running processes and device drivers on the system %COMPUTERNAME%_PROCESS.[CSV/TXT] %COMPUTERNAME%_DRIVERS.[CSV/TXT] Scheduled Job information ========================== - information from both the AT Scheduler and the Task Scheduler %COMPUTERNAME%_SCHEDULE.[CSV/TXT] %COMPUTERNAME%_SCHEDLGU.TXT System Diagnostics =================== - output from the Windows diagnostics tools %COMPUTERNAME%_MSINFO32.NFO - Windows 2000 or later diagnostics report %COMPUTERNAME%_WINMSD.TXT - Windows NT 4.0 diagnostics report %COMPUTERNAME%_SYSTEMINFO.TXT - Windows XP/.NET system information %COMPUTERNAME%_PSTAT.TXT - Process Status output show some performance data for the running processes System File Information ======================= - subset inventory of the most important system files %COMPUTERNAME%_IEFILES.[CSV/TXT] %COMPUTERNAME%_SYSTEM32.[CSV/TXT] Setup log files =============== - Log files created by MSI when applications are installed %COMPUTERNAME%_SETUPACT.LOG - Windows setup actions log %COMPUTERNAME%_SETUPAPI.LOG - Windows setup API log %COMPUTERNAME%_SETUPERR.LOG - Windows setup error log %COMPUTERNAME%_SVCPack.log - Service Pack installation log %COMPUTERNAME%_dahotfix.log - MDAC hotfix installation log %COMPUTERNAME%_Q*.log - hotfix installation log %COMPUTERNAME%_KB*.log - hotfix installation log System service configuration and trace settings =============================================== - registry settings for key system components %COMPUTERNAME%_TRACING.TXT - Settings for LSA, Winlogon, Netlogon, NTDS, NTFRS, RAS and other misc. settings. %COMPUTERNAME%_IPSEC.TXT - Settings for IPSEC (Windows 2000 or later only) System Startup and Crash Recovery data ======================================= - copies of the BOOT.INI, Autoexec.NT and Config.NT are collected as well as the registry settings that control application and system crash handling %COMPUTERNAME%_BOOT_INI.TXT %COMPUTERNAME%_CONFIG_AUTO.TXT %COMPUTERNAME%_RECOVERY.TXT Terminal Server data ==================== - lists of users, processes and connections available on a Terminal Server %COMPUTERNAME%_TERMSERV.TXT Reporting Services =================== %COMPUTERNAME%_ROSETTA_REG.TXT - Reporting services registry entries SQL Server 2005 Installation Logs ================================= All SQL Server 2005 setup related files will start with %COMPUTERNAME%_SQL2005_ %COMPUTERNAME%_SQL2005_SUMMARY.TXT - Summary of installation results %COMPUTERNAME%_SQL2005_SQLSETUP*.CAB - CAB files with installation files for each instance found, InstName would be the actual instance name. %COMPUTERNAME%_SQL2005_SQLSETUP*.[log, xml] - SQL Server setup files for incomplete installations. Note: Complete SQLDiag only gathered on machine in control of the server, cluster nodes not in control will show connectivity error in report for attempt to gather while not controlling the virtual server. If the user is not a SQL Server administrator some information will be missing such as the sp_configure SQLDiag Reports for all installed Instances =========================================== %COMPUTERNAME%_MSSQLSERVER_SQLDIAG.txt - SQLDiag for default SQL Server installation %COMPUTERNAME%__SQLDIAG.txt - SQLDiag for named SQL Server installation where InstanceName is the actual instance name. SQL Server File Inventories ========================== %COMPUTERNAME%_SQLFILES.[CSV/TXT] - SQL Server files for Microsoft SQL Server and all sub directories %COMPUTERNAME%_SQL(x86)FILES.[CSV/TXT] - SQL Server files for Microsoft SQL Server and all sub directories of 32-bit files on 64-bit systems only. Full text common files %COMPUTERNAME%_COMMON_SYSTEMFILES.[CSV/TXT] - %ProgramFiles%\Common Files\System file report for use in trouble shooting Fulltext issues SQL Server Logs - SQLAgent, Error, Exception & SQLDump logs retrieved using CpySQLLogs.vbs =========================================================================================== %COMPUTERNAME%_%InstanceName%_errorlog*.* %COMPUTERNAME%_%InstanceName%_sqlagent*.* %COMPUTERNAME%_%InstanceName%_sqldump*.txt %COMPUTERNAME%_%InstanceName%_exception.log SQL Server Registry Keys ======================== %COMPUTERNAME%_MS_SQL_SERVER_REG.TXT - Microsoft SQL Server registry keys, text version %COMPUTERNAME%_MS_SQL_SERVER_REG.HIV - Microsoft SQL Server Registry hive, not available on Windows 2003 servers %COMPUTERNAME%_MSSQLSERVER_REG.HIV - MSSQLServer Registry hive, not available on Windows 2003 servers %COMPUTERNAME%_MSSQLSERVER_REG.TXT - MSSQLServer Registry, text version SQL Server Replication reporting ================================= %COMPUTERNAME%_MSSQLSERVER_REPLINFO(OSQL).txt - REPLINFO for default SQL Server installation, not available on 64-bit servers %COMPUTERNAME%_InstanceName_REPLINFO(OSQL).TXT - REPLINFO for named SQL Server installation where InstanceName is the actual instance name, not available on 64-bit servers. SQL Server ServiceUser Rights ============================== - required for SQL Server service accounts, OLAP services, Kerberos on Windows 2000 & 2003 %COMPUTERNAME%_SQLRIGHTS.TXT - List accounts that have: Right/Deny to Access this computer from the network Right/Deny to Logon Locally Right/Deny to Log on as a service Act as part of the operating system Replace a process-level token List of localgroup Administrators members List of localgroup OLAP Administrators members SetSPN - L results for %COMPUTERNAME% SetSPN - L results for %USERNAME%, must be logged in with SQL Server service account for this to be of value SQL Server Setup logs ===================== %COMPUTERNAME%_%InstanceName%_sqlclstr.log %COMPUTERNAME%_%InstanceName%_sqlsetup.log %COMPUTERNAME%_%InstanceName%_sqlstp*.log %COMPUTERNAME%_%InstanceName%_sqlsp*.log SQLScan Slammer Vulnerability Detection ======================================= %COMPUTERNAME%_SQLSCAN.TXT - Detection to verify SQL Server instances are patched against the Slammer virus SQL Server SP_CONFIGURE reporting ================================= %COMPUTERNAME%_MSSQLSERVER_SPCONFIG.txt - SP_configure settings, dbcc tracestatus(-1), and xp_msver results for default SQL Server installation %COMPUTERNAME%_ InstanceName_SPCONFIG.TXT - SP_configure settings, dbcc tracestatus(-1), and xp_msver results for named SQL Server installation where InstanceName is the actual instance name TLIST.EXE Information ===================== %COMPUTERNAME%_TList.TXT Report files created in Full Mode: ================================== Full Mode creates all of the reports in Lite Mode and adds the following extra reports: BackOffice File Information - inventory of the BackOffice applications installed on the system %COMPUTERNAME%_EXCH.[CSV/TXT] - Exchange files %COMPUTERNAME%_EXCHREG.TXT - Exchange registry keys %COMPUTERNAME%_IIS.[CSV/TXT] - Internet Information Server files %COMPUTERNAME%_ISA.[CSV/TXT] - Internet Security & Acceleration Server file %COMPUTERNAME%_SMS.[CSV/TXT] - Systems Management Server files %COMPUTERNAME%_SNA.[CSV/TXT] - SNA/Host Interagration Server files Microsoft Office File Information - inventory of the Office applications installed on the system %COMPUTERNAME%_MSOFFICE.CSV System File Information - inventory of all application files and more system files not collected in Lite Mode %COMPUTERNAME%_PROGFILES.[CSV/TXT] - inventory of the %ProgramFiles% folder %COMPUTERNAME%_SYSROOT.[CSV/TXT] - inventory of %SYSTEMROOT% Other files created: ==================== %COMPUTERNAME%_PROGRESS.TXT - Progress Report log file showing the progress of the Tool. Used by the Microsoft Support Professional to debug problems running the Tool %COMPUTERNAME%_PROGRESS.TXT CAB files - Cabinet file containing all of the reports CABDIRECT.[DDF/TXT] - used to create the CAB file - deleted after CAB is created CABERRORS_%DATETIME%.TXT - deleted if no errors occurred during CAB creation %COMPUTERNAME%_MPSReports_%DATETIME%_#.CAB - Where # is equal to a number if CAB file is over 4MB and has the same DATETIME and multiple CAB files were created, else if DATATIME are different you will still get multiple files but they will have same number. HISTORY: ======== Version Changes ========== ======== v9.14.2004.3264 - Moved System information gathering to last item on the Lite mode - Modified file names for better understanding of file contents - Added OSQL for gathering SP_configure and replication information (%COMPUTERNAME%_InstanceName_REPLINFO(OSQL).TXT, %COMPUTERNAME%_ InstanceName_SPCONFIG.TXT) - Added registry entries for Reporting services (%COMPUTERNAME%_ROSETTA_REG.TXT) ............... - Updated CLUSMPS.EXE - Updated DUMPEL.EXE - Added event logs in EVT format back in. - IIS Metadata gathered to assist with IIS configuration verification for SQL Server CE related cases - Replaced SQL VBS script for SQL Server version detection and full support for SQL Server 2005 (Yukon) - Improved logging in the %COMPUTERNAME%_PROGRESS.TXT file, more error checking, more verbose. - Added machine and current user SPN information to the %COMPUTERNAME%_SQLRIGHTS.TXT - Added FCINFO Fiber Channel reporting - Added link in readme.txt to KB article 816819 Description of the Microsoft Platform Support Reporting Utility - Added additional 64bit information to readme - Added section to readme on running as scheduled job - Restructured the bin directories - Added additional instructions on screen for 64 operation - Added %ProgramFiles%\Common Files\System file report to assist on fulltext cases (%COMPUTERNAME%_COMMON_FILES.[CSV/TXT]) - Added .NETFramework registry entries (%COMPUTERNAME%_NETFRAMEWORK_REG.TXT) - Added command line install option installation to path, (path must already exist) v7.08.2004.3264 - Complete rewrite and moved to new format based on Alliance version 4.8.0.0 with all its functionality shown in history and ability to modularize for easier version updating Altered Version string format = MajorVer(Month).MinorVer(Day).BuildMajorVer(Year).BuildMinorVer(32-bit - 32, 64-bit - 64, Both 3264) Added 64-bit detection & compatibility Added CpySQLLogs.vbs for gathering of SQL Server errorlogs and SQLAgent logs for all SQL Server instances Added Checksym for gathering file information from the Microsoft SQL Server folder level • %COMPUTERNAME%_SQL.[CSV/TXT] - SQL Server files for Microsoft SQL Server and all sub directories Complete CurrentControlSet & Microsoft registry hives now created in full report only Added cpySQLLogs.VBS to allow gathering of SQLAgent logs, SQL Server Errorlogs, SQL Server exception.txt listing, SQLDump.txt header files, for all detected SQL Server instances. All SQL Server setup logs, both initial setup and service pack setup. No longer limited to only 10 logs. Files will have format of: • %COMPUTERNAME%_%InstanceName%_errorlog*.* • %COMPUTERNAME%_%InstanceName%_sqlagent*.* • %COMPUTERNAME%_%InstanceName%_sqldump*.txt • %COMPUTERNAME%_%InstanceName%_exception.log • %COMPUTERNAME%_%InstanceName%_sqlclstr.log • %COMPUTERNAME%_%InstanceName%_sqlsetup.log • %COMPUTERNAME%_%InstanceName%_sqlstp*.log • %COMPUTERNAME%_%InstanceName%_sqlsp*.log Added getDiags.VBS to gather SQLDIAG reports for all installed instances except those installed with minimum config, in those cases sqldiag.exe is not present in the binn folder as expected • %COMPUTERNAME%_MSSQLSERVER_SQLDIAG.txt - SQLDiag for default SQL Server installation • %COMPUTERNAME%_InstanceName_SQLDIAG.txt - SQLDiag for named SQL Server installation where InstanceName is the actual instance name. Gathering of SQL Server 2005 setup logs • %COMPUTERNAME%_SQL2005_InstName.CAB EVT formatted event logs only in FULL Mode Added SQL Server Replication gathering for: • Replication information/agent details/profiles/publishers/subscribers/distributors • Identify the distributor server and property settings • Replication agent jobs/profiles • %COMPUTERNAME%_MSSQLSERVER_ REPLINFO.txt - REPLINFO for default SQL Server installation • %COMPUTERNAME%_ InstanceName_REPLINFO.TXT - REPLINFO for named SQL Server installation where InstanceName is the actual instance name. CAB files now limited to max size of 4MB, once limit is reached additional CAB files will be created with same name plus numbered in ascending order when multiple cab files are created with same date/time stamp in filename Added SQLScan reporting • %COMPUTERNAME%_SQLSCAN.[CSV/TXT] - Detection to verify SQL Server instances are patched against the Slammer virus Added Microsoft Analysis Server Information, OLAP: • %COMPUTERNAME%_OLAPSTP.log - setup log • %COMPUTERNAME%_OLAPSP.log - setup log • %COMPUTERNAME%_OLAPSERVER_REG.HIV - OLAPServer registry in HIV format, except on Windows 2003 • %COMPUTERNAME%_OLAPSERVER_REG.TXT - OLAPServer registry in text format • %COMPUTERNAME%_OLAP_OLEDB.[CSV/TXT] - File version reporting for Program Files\Common Files\System\OLE DB folder • %COMPUTERNAME%_OLAP_DSO.[CSV/TXT] - File version reporting for Program Files\Common Files\Microsoft Shared\DSO folder • %COMPUTERNAME%_OLAP_BIN.[CSV/TXT] - File version reporting for Program Files\Analysis Services\Bin folder • %COMPUTERNAME%_OLAP_DATA.[CSV/TXT] - File version reporting for Program Files\Analysis Services\Data folder Removed Gathering of HIV SQL Server registries on Windows 2003 machines • %COMPUTERNAME%_MSSQL_REG.HIV - Microsoft SQL Server Registry gathering on Windows 2003 machines • %COMPUTERNAME%_SQL_REG.HIV - MSSQLServer Registry gathering on Windows 2003 machines Known 64-bit issues under investigation: Ipconfig not fully supported on 64-bit systems, see 836829 You cannot run the 32-bit version of the Ipconfig.exe tool on Windows (http://support.microsoft.com/?id=836829) for details. Checksym.exe fails on AMD 64-bit systems Alliance Version History =========================== 4.8.0.0 - Collect Security Event log as CSV only in FULL mode Added /n option to NET CONFIG commands for better error handling IE Configuration data collection Collecting hotfix and SP installation log files Updated Checksym.EXE to v2.5.0.0 Updated DumpEVT.EXE Updated OEMInbox.exe Minor edits to README.TXT 4.7.0.4 - Updated Readme to refer to EULA Updated RPCDUMP.EXE to v1.1 Dumping TCP/IP regkey 4.7.0.3 - Minor bug fix - Checksym of Office files would overwrite SQL txt report Added registry dump of SQL Server keys 4.7.0.2 - Renamed to "Alliance" for web publication 4.7.0.1 - Renamed to "General" for web publication 4.7.0.0 - Now running Eventquery.vbs instead of DUMPEL on build 2600+ Minor changes to make it Windows 2003 compatible Added EXE name to progress report per customer request 4.6.0.0 - Clusmps replaced by ClusInfo - New version of Checksym with no DLL dependencies 4.5.4.0 - Added new cluster tool - collecting setup*.log files - improved Event log CSV dump code 4.5.3.0 - Cleaned up registry dumps - added PSTAT back to get some basic performance data - Updated Checksym to v2.2.7.0 - Running IPSECCMD for Windows XP/.NET 4.5.2.0 - Added Exchange registry dump - Added Terminal Server registry dump 4.5.1.0 - Added WLBS to cluster section - Added IPSec info gathering - Now deleting report files after CAB creation - Updated to Checksym.exe v2.2.4.0 - Added rpcdump - minor cleanups 4.4.1.0 - added many new registry queries - consolidated some report files 4.3.1.1 - Refreshed some binaries 4.3.1.0 - Refreshed some binaries removed unneeded Checksym support DLLs Minor syntax improvements 4.2.1.1 - Refreshed some binaries Reordered some actions 4.2.1.0 - Added Cluster info Fixed some output formatting issues 4.1.1.0 - Added quiet and install modes Bugfix querying hotfix registry 4.0.1.0 - Total rewrite Now support Windows NT 4.0, Windows 2000, and Windows XP Uses newest version of Checksym and other tools 3.0 - Integrated tool for Windows 2000 and Windows NT 4.0. Added reporting modes LITE and FULL. 2.0 - Switched from ZIP packaging to IEXPRESS packaging. Switched from FILEVER.EXE to CHECKSYM.EXE to gather file information. 1.0 - Initial version