Content Preview: rss
723 days ago
MOM 2005 Stats to Jet Database Redux Just in time for the holiday season, a new and improved version of MOM_Report_to_Database.vbs This script takes in two arguments, the MOM Server name and the Management Group Name, collects the mom daily statistics and puts them into a database D:\MOMMGT\MOMRPT.MDB. This will allow for reporting on multiple Management Groups. For full details please see my prior posting http://myitforum.com/articles/2/view.asp?id=10257 If your already using the original script and database only a few modifications will have to be made. The database will have to have a row called MGName added, and the scheduled task will have to have the parameters added for the /MOMServer:ServerName /MGName:ManagementGroupName There is error checking to make sure that there are 2 parameters, if the two parameters are not there, the script will quit with the parameters that are required. Usage: cscript mom_report_to_database.vbs /MOMServer:MOMServerName ...747 days ago
The KB below is packed with information and trouble shooting steps. Microsoft KB article How to install and manage Microsoft Operations Manager 2005 agent computers that are behind a firewall or in an untrusted domain http://support.microsoft.com/kb/904866 The majority of the problems I've encountered are usually related to, Naming resolution and firewall ports. Requirements for MOM agents that are behind a firewall The following ports must be open TCP port 1270 and UDP port 1270, and it must be bi-directional. Also note that the agent must be manually installed on the DMZ host, and updates must be manually applied too. The following should be done prior to manually installing the agent on the DMZ host. 1. Use the host file on mom server to resolve the fqdn name of the DMZ host. 2. Use the host file on the agent computer to resolve the fqdn name(s) of the MOM Server(s). 3. After modifying and saving the changes to the host file, open a command prompt and run the ...
747 days ago
This is an easy way to capture data for reporting on MOM 2005 stats utilizing the MOM WMI Class MSFT_TodayStatistics. I've created a script that will dump the MOM WMI Class MSFT_TodayStatistics (the daily stats) for MOM 2005 into a database. Props to Don Hite, his script to dump the same info into an excel file gave me the idea to dump the info into a jet database. http://www.myITforum.com/articles/2/view.asp?id=9909 The MOM WMI Class MSFT_TodayStatistics gets zeroed out at 11:59:59 pm each night. If you manage more than one management group, it would not be hard to modify this script to use a sql db and include the management group name when the data is collected. I'm sure the management group name can be gotten thru WMI... but I'll save that for a later article. User requirements: 1. Create Access Database and Table Create an Access Database named: MOMRPT.MDB Create a table named: MOMDATA Create field names that correspond with the ...
