• SCOM 2012 Documentation
  • Microsoft OpsMgr Team Blog
  • Kevin Holman’s Blog
  • thoughtsonopsmgr
  • SCOM2K7 Blog
  • BICTT Blog
  • Cameron Fuller
  • JC’s SCOM Blog
  • Tao Yang SCOM Blog
SCOM GOD

Category Archives: Scom Downloads

SCOM Reports Edit Issue QFE_MOMEsc_4724

July 10, 2014 4:10 pm / Leave a Comment / SCOMGod

The file QFE_MOMEsc_4724.zip, will unzip an MSI file.
When you run the MSI this will unpack the private fix to the following path,

\Program Files (x86)\System Center\QFE_MOMEsc_4724\ or \Program Files\System Center\QFE_MOMEsc_4724\

This code change updates the following file, %ProgramFiles%\System Center Operations Manager 2007\Microsoft.MOM.UI.Common.dll, and needs to be placed on any machine where you have the OpsMgr console installed.

In order to verify this update I would like to do the following.

1) Take a copy of the current existing file and place it in a suitable directory.
2) Close down any open console and then replace the existing Microsoft.MOM.UI.Common.dll with the one you have downloaded from the URL above.
3) Please then restart the console and confirm this has corrected the issue in your environment.

Download hotfix: QFE_MOMEsc_4724

Posted in: SCOM Downloads

Extended SQL MP

August 29, 2013 3:24 pm / Leave a Comment / SCOMGod

Download: http://www.scomgod.com/wp-content/uploads/2013/08/Microsoft.Extended.SQLServer.MP_.zip

 

Reference: http://gallery.technet.microsoft.com/Extended-SQL-Server-MP-for-645ac604

Posted in: SCOM Downloads, SQL

SQL Instance List Report for SCOM

July 31, 2013 2:40 pm / Leave a Comment / SCOMGod

Download: SCOM_SQL_Instances

Connection string:

Data Source=ServerName;Initial Catalog=OperationsManager

Posted in: SCOM Downloads, SQL

SCOM SQL Script to show gray agent data historical reasons

July 17, 2013 1:02 pm / 3 Comments / SCOMGod

This is a great script I received from PSS working on a case.

Run against the DW and enter your server name near the bottom.

SELECT
ME.FullName,
HSO.StartDateTime AS OutageStartDateTime,
DATEDIFF (DD, hso.StartDateTime, GETDATE()) AS OutageDays,
HSO.ReasonCode,
DS.Name AS ReasonString
FROM  vManagedEntity AS ME
INNER JOIN     vHealthServiceOutage AS HSO ON HSO.ManagedEntityRowId = ME.ManagedEntityRowId
INNER JOIN     vStringResource AS SR ON HSO.ReasonCode =
REPLACE(LEFT(SR.StringResourceSystemName, LEN(SR.StringResourceSystemName)
– CHARINDEX(‘.’, REVERSE(SR.StringResourceSystemName))), ‘System.Availability.StateData.Reasons.’, ”)
INNER JOIN     vDisplayString AS DS ON DS.ElementGuid = SR.StringResourceGuid
WHERE (SR.StringResourceSystemName LIKE ‘System.Availability.StateData.Reasons.[0-9]%’)
AND DS.LanguageCode = ‘ENU’
AND ME.FullName like ‘%SERVER NAME%’   –Change name here or leave %% for ALL SERVERS
ORDER BY OutageStartDateTime

 
Result output will dispaly all of the reasons an agent went gray:

FullName OutageStartDateTime OutageDays ReasonCode ReasonString
Microsoft.SystemCenter.HealthService:ADPAPP 2012-12-23 04:59:41.300 206 0
The heartbeat from System Center Management Service is missing.

Posted in: SCOM Downloads

List of all SCOM Monitors from Various Popular Management Packs

July 16, 2013 1:55 pm / Leave a Comment / SCOMGod

Here is a set of Excel files from the MPWiki Team that is invaluable when people ask for a list of Monitors for a particular MP.

SCOM-RULES-MONITORS

Posted in: SCOM Downloads, SCOM Tips

How to Run Hyper-V on a Laptop

July 10, 2013 5:57 pm / Leave a Comment / SCOMGod

http://social.technet.microsoft.com/wiki/contents/articles/185.hyper-v-how-to-run-hyper-v-on-a-laptop.aspx?PageIndex=3

Posted in: SCOM Downloads

Microsoft Technet Lab Guides

June 10, 2013 3:55 pm / Leave a Comment / SCOMGod

Great link!

http://social.technet.microsoft.com/wiki/contents/articles/1262.test-lab-guides.aspx#TLG_Portal_Pages

Posted in: SCOM Downloads

SCOM Gateway Troubleshooting Steps – Jonathan Cowan Credit

May 22, 2013 7:26 pm / Leave a Comment / SCOMGod

1)      Ping by FQDN from the management server to the gateway server
2)      Ping by FQDN from the gateway server to the management server
3)      Telnet from the gateway server to the management server on port 5723
4)   Validate Certificate (Client\Server and CSP’s especially)
o   Trusted Root on All GW and MS
o   OpsMgr Cert unique to each computer and imported
o   Using either 1024 or 2048 key size (2048 adds CPU overhead)
§  MOMCertImport changes this to 1024
o   2 year expiration
§  MOMCertImport changes this to 1 year
5)   Ensure all SPN’s are correctly registered for DW\DB\MS’s and services are utilizing them
6)   Ensure OperationsManger certificate is copied into Trusted Root store after MOM Cert Import
7)   Event ID 220071 and 21016 on Gateway points to Firewall, SPN or Certificate issue in most cases
8)   Installing GW as Administrator
9)   GW Approval tool run using an account with SysAdmin privileges to SQL DB
10) Ensure you are using the latest MOMCertImport and Gateway Approval Tool
11) Ensure you copy the Gateway Approval tool and the Gateway Approval Tool Config file for running Approval
12) Ensure the Gateway is not in Pending Management after manual install, just prior to approval.
13) Stop HealthService after installing Gateway role, so it doesn’t show in Pending Management if necessary.
14) Ensure no certificates exist in the OperationsManager Certificate store prior to running MOMCertImport
15) Ensure Gateway has been Approved

Posted in: SCOM Downloads

SCOM 2012 Maintenance Mode Utility

April 22, 2013 3:17 am / Leave a Comment / SCOMGod

http://blogs.technet.com/b/markmanty/archive/2013/04/16/scom-scheduling-maintenance-mode-tool.aspx

Posted in: SCOM Downloads

How to Reinstall SCOM Reporting

April 22, 2013 3:14 am / Leave a Comment / SCOMGod

Great link

http://stuartrenes.wordpress.com/2009/06/03/how-to-reinstall-system-center-operations-manager-reporting/

Posted in: SCOM Downloads

Post Navigation

← Older Posts
 

Recent Comments

  • admin on SCOM SQL Script to show gray agent data historical reasons
  • admin on SCOM SQL Script to show gray agent data historical reasons
  • Gene on SCOM SQL Script to show gray agent data historical reasons
  • admin on SCCM 2012 SP1 Installation Pre-reqs
  • Ryan on SCCM 2012 SP1 Installation Pre-reqs

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Blogroll

  • Anders Blog
  • Daniele's Blog
  • Great SCOM Report Tutorial
  • Microsoft SCOM Forums
  • Savision Sample Dashboards
  • SCOM Blog
  • SCOM FAQ
  • scom-2012.blogspot.be
  • System Center 2012 Notes From the Field
  • Veam Install PDF

Recent Posts

  • PowerShell Script RDP Sessions List
  • Powershell Search Thru IIS Logs for Text String
  • PowerShell Reboot AD Based Computers
  • PowerShell Dump ACL of a Path Folder
  • SCOM Maintenance Mode Group of Servers
  • WMI Admin Access without Domain Admin Privilege
  • Script to Update User Redirected Folders ACL
  • Windows 2012 R2 Folder Redirection Step by Step
  • SharePoint 2013 Pre-reqs Link
  • Windows 2012 TSAdmin Download
  • Server Reboot Batch File
  • SCOM Get Missing Performance Data
  • SCOM 2012 Linux Agent gray and critical – Requires uninstall of agent & cert
  • SCOM 2012 Batch File to Clear Health Service Cache
  • SCOM 2012 Put URL into Maintenance Mode
  • MS Operations Management Suite Survival Guide
  • Script to Logoff All Disconnected Citrix Sessions
  • SCOM 2012 R2 Close All Alerts Script
  • SCOM Health Service Flush Scripts
  • SCOM 2012 PowerShell One Liners
  • GreenMachine for SCOM 2012
  • VBS Script to get AD Group Members
  • SCOM 2012 Maintenance Mode Notification MP
  • SCOM 2012 Reminder Alerts – PowerShell Script to Update Alert Resolution
  • SCOM 2012 R2 Test Event MP
  • SCOM Cluster Failover Events MP
  • SCOM 2012 R2 Maintenance Mode Powershell Script for Single Server
  • SCOM Reports Edit Issue QFE_MOMEsc_4724
  • Clean Windows 2008R2 Space
  • SCOM Linked Availability Report
  • SCOM Catch All Management Pack
  • PowerShell Script Close All SCOM Alerts 2007R2
  • Windows Update Error 80072EFE in Client Hyper-V Guest
  • SCOM query to get all data about an obejct
  • SCOM 2012 Cluster Disks management pack addendum
  • SCOM Cluster CSV Query
  • SCOM REPORT MODELS
  • SCOM 2012 Bulk URL Editor Manager Download
  • SCOM Catch All Error Events Log Rule
  • SCOM 2012 iSCSI Volume Shadow Copy Rules MP
  • Configuring Hyper-V for multiple subnets with only one NIC (Server 2012 R2 Edition)
  • Windows 2012 USB Boot Disk
  • SCOM Web Console Path Not Showing
  • Windows 2012 R2 BlueScreen Fix
  • AD Password Expiration Report Script
  • SCCM Query: Uptime and Last Reboot Time
  • SCOM 2012 ToolBox Downloads
  • EMC SCOM 2012 Management Pack ESI
  • SCOM ETL Trace Instructions
  • Extended SQL MP
  • SQL Instance List Report for SCOM
  • SCOM SQL Script to show gray agent data historical reasons
  • List of all SCOM Monitors from Various Popular Management Packs
  • How to extend date of SCOM certificate issued by Stand Alone CA
  • How to Run Hyper-V on a Laptop
  • SCOM Alert for Specific Account lockout
  • Microsoft Technet Lab Guides
  • SCOM Gateway Troubleshooting Steps – Jonathan Cowan Credit
  • SCOM 2012 Maintenance Mode Utility
  • How to Reinstall SCOM Reporting
  • SCCM 2012 Client Action Tool!
  • SCOM Report Data Source Fix
  • SCOM 2012 Health Check Script
  • SCOM RunAs Account Fixer PowerShell Script!
  • File Share Check and Email Script
  • SCOM 2012 Exchange 2010 MP Filling Logs with Login Failures
  • SCOM 2012 Report Data Source Option Missing
  • SCOM 2012 File Share Management Pack
  • Dynamic Groups with Expressions in OpsMgr
  • SCOM 2012 Unsealed Management Pack Backup
  • SCOM 2012 Web View Widget
  • Windows 2003 Bits 2.5 Download
  • SCOM 2012 Maintenance Mode
  • SCOM 2012 Utilization Reports Processor Data Missing
  • Windows Server 2012 Keyboard Shortcuts
  • SQL SCOM 2012 Alerts By Email Script
  • Windows 2012 Interface Explanation from Microsoft
  • Microsoft Private Cloud Step By Step
  • Managing SCOM 2012 Alerts: Daily Tasks
  • SCOM 2012 Training Guides and Videos
  • SCCM 2012 SP1 Installation Pre-reqs
  • SCOM SQL Run As Account Guidelines
  • Windows Server 2012 Won’t Activate: DNS Server Not Found
  • Brian Wren’s Sample Network Management Pack for System Center 2012 Operations Manager
  • The Greatest PowerShell Script of All Time for Windows Admins by Sean Duffy
  • SCOM Health Check Excel Template
  • List All AD User Object Attributes
  • Sharepoint 2010 Management Pack for SCOM 2012
  • How to Run a Powershell Script as a rule in SCOM as a Command
  • OpsLogix PING MP for SCOM 2012
  • SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated.
  • SCOM Maintenance Mode EXE – Awesome Utility
  • SCOM Grey Agent MP from SCC
  • The All Management Servers Pool has not reported availability
  • SCOM ACS Filter Events
  • SCOM ACS Modified SQL Stored Procedures
  • MMS 2012 Session Listing Download
  • SQL Database Stuck in Restoring Mode
  • SCOM Maintenance Mode Script
  • SCOM Active Directory Security Management Pack
January 2021
M T W T F S S
« Apr    
 123
45678910
11121314151617
18192021222324
25262728293031

About

This site is a collection of tools and tips that I needed to place in the cloud. I have given credit where credit is due and respect all the hard work of those in the SCOM community that are miles above me in terms of knowledge, experience and accolades.
© Copyright 2021 - SCOM GOD
Infinity Theme by DesignCoral / WordPress