Author Archives: scompanion

Find SCOM object from instance id

When troubleshooting SCOM problems by examining alerts that have triggered and the event viewer you sometimes come across objects being referenced by their GUIDS. To retrieve their names you can use the Operations Manager shell in powershell and run the … Continue reading

Posted in Powershell for SCOM | Tagged , , , | Leave a comment

Remote Desktop Connection Manager Distorted Display

I recently connected a Windows Server 2012 R2 computer to my existing Remote Desktop Manager v2.7 console. When I tried to adjust the screen size to scale to the remote desktop to fit the window the display was distorted. To … Continue reading

Posted in Non SCOM Techy Stuff | Tagged , , , , , , , , , , , | Leave a comment

Windows Server 2012 keyboard shortcuts

Keyboard Shortcuts for Windows Server 2012 Windows Key + C – Opens Charms bar Windows Key + Ctrl + Tab – Cycles through apps Windows Key + Shift + Tab – Cycles through apps in reverse order Windows Key + … Continue reading

Posted in Misc Stuff, Non SCOM Techy Stuff | Tagged , , , , | Leave a comment

SCOM 2012 Data Access Service SPN Not Registered

If you’re using a Domain User account (which is best practice) for your Data Access Service account you may receive the following error when opening up the console. “Data Access Service SPN Not Registered” “Alert Description: The System Center Operations … Continue reading

Posted in Misc Stuff | Tagged , , , , , , , | Leave a comment

Cleaning out unwanted event collection data from ops database

Most large SCOM management groups have lots of management packs and lots of monitored computers. Invariably this means that there are lots of event collection rules collecting event data and storing it in the Ops database and the datawarehouse. It … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , | Leave a comment

SQL query to display database sizes

You can ran this SQL query against the Ops DB and the Ops DW to display database size information……. select ‘server’ = @@servername , ‘total size in megabytes’= convert(decimal(10,2),(sum(size * 8.00) / 1024.00 )) , ‘total size in gigabytes’ = … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , | Leave a comment

Cleaning stale data out of datawarehouse database

Prior to SCOM 2012 R2 UR7, there was an issue whereby SCOM did not groom out old data from the Event Parameter and Event Rule tables in the DW database.This will show up as these tables growing quite large, especially … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Manual Install of Scom Agent on Domain Controllers

If you wish to manually install the scom agent on a domain controller you need to also manually install the OOMADS component. OOMADS is an additional piece of software that enables the SCOM Agent to fully utilise the AD MP … Continue reading

Posted in SCOM Agents | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Domain Controllers still generating alerts after being put into maintenance mode

A colleague of mine was doing some work on DC’s so put them into maintenance mode via the scom console, he was perplexed to discover that the DC’s started to generate alerts when he started work on them. Why did … Continue reading

Posted in Misc Stuff | Tagged , , , , , , , , , , , , , , , | Leave a comment

Make single page in word doc landscape orientation

Recently had cause to make a single page within a word document landscape orientation in order to make a diagram that was inserted readable. It can be done easily following the instructions on the attached word doc. NOTE instructions are … Continue reading

Posted in Non SCOM Techy Stuff | Tagged , , , , , , | Leave a comment