Downloads

Downloads: #2 Automate your group creation with Powershell

Wed, 17 Mar 2010 12:32:42 GMT

One of our very good customers are managing servers with an dedicated internal administrator as a primary contact for each server. They are managing this one to one relation with an Excel sheet.

A while ago we talked about automating this group creation with powershell, so the last time Jacob and I was discussing Powershell in Operations Manager we found a solution – Jacob who is the best Danish Powershell Guru of cause did a superoptimization of my first script and now its up to you to test it on your own.

Downloads: Windows Service Recovery Monitor (for OpsMgr and Essentials)

Mon, 15 Mar 2010 19:06:53 GMT

Checks to see if a Windows service is configured to 'automatically restart' in case of service failure (service properties, Recovery tab). Use in a two-state monitor targeting a Windows operating system class. Script accepts one parameter - the name (not display name) of the Windows service.

Works with OpsMgr 2007 or Essentials 2007 / 2010. For help in implementing,see this tutorial:

How to create a Script-based 2-State Monitor

Downloads: Script to Monitor Age of Multiple Files (for two-state monitor)

Sat, 27 Feb 2010 06:58:44 GMT

by Olof Helge, this script can monitor files in a target directory and raise an alert if any file in the directory is older than a user-defined threshold. Designed to be used in OpsMgr or Essentials in a two-state monitor.

For steps to implement a custom two-state monitor, see

How to create a Script-based 2-State Monitor

See original SCC forum dicussion HERE.

Downloads: PowerShell to change ConfigMgr Client Cache size

Mon, 22 Feb 2010 02:19:13 GMT

by Aaron Czechowski, this is a Script to Change A Remote ConfigMgr Clients Cache Size using PowerShell

Downloads: Operations Manager - Set email address for a notification device

Thu, 18 Feb 2010 08:14:20 GMT

This script is a helper function to enable setting email addresses on notification devices in Operations Manager 2007. Can be used to update the email address of the currently on call administrator. Note you will need the out-log function from here.

Downloads: Using a script to automatically reset monitor state when alert is closed

Wed, 17 Feb 2010 23:15:33 GMT

A powershell script that can help you reduce "monitoring noise" created by the "manual reset" monitors.

The script is intended to be used as an alert notification command. The notification channel should be configured to pass alert ID as an argument to the script and corresponding notification subscription must include _closed_ alerts of warning and error severity.

Once the script recieves ID of the closed alert, it will look up the monitor that generated the alert and check if there is a workflow defined for the current state of the monitor. If there is no workflow for the current state, then the script will force reset of the monitor's state, returning it to the "healthy" condition.

$s_rms variable should be modified to contain the name of your rms

Downloads: A powershell script for resetting state of "manual reset" monitors

Wed, 17 Feb 2010 22:50:26 GMT

The script iterates through the state hierarchy of each monitoring
object in the management group and resets all "manual reset" monitors
that have been in "Error" or "Warning" state longer than the specified
max period for time in state.

The script is intended to run as a scheduled task. There are two
variables that need to be adjusted to match your environment:

$rms_name - set it to the name of your rms server
$MaxTimeInState - defines delay for resetting a manual reset monitor in hours

Downloads: DPM 2007 Share Restore Recovery Point Script

Tue, 22 Dec 2009 05:05:09 GMT

This Powershell script will Restore the latest recovery point for all Shares/Volumes within specified protection group to a network folder.

Downloads: OpsMgr Script: Automatically Starting Maintenance Mode When Servers are Rebooted

Sun, 20 Dec 2009 00:04:26 GMT

by Kris Bash, automated solution including a PowerShell script that puts nodes (and clusters, if applicable) in maintenance mode when used as part a

Downloads: OpsMgr Script: Status Check for Local TCP Port

Sat, 19 Dec 2009 23:59:15 GMT

by, Kris Bash, A vbs script (as a .txt file) for use in a SCOM unit monitor to locally check the status of a listening TCP port.

Downloads: New and Improved Two-State Monitor Script to Identify SQL Databases Never Backed Up

Fri, 13 Nov 2009 21:19:54 GMT

by Bob Messer and David Scheltens, this script, designed for use in an OpsMgr two-state monitor, will alert on databases not based up within a user-defined threshold.

This is just a downloadable copy from the original discussion of the problem which can be viewed HERE.

Downloads: DPM 2007 Daily Maintenance Script

Tue, 03 Nov 2009 05:45:00 GMT

By Jeff Graves (OrcsWeb), This powershell script will query the DPM 2007 database for alerts and addresses the four most common. Replica disk and Recovery Point Volume threshold exceeded, Replica is inconsistent, and Recovery Point creation failed.

The script takes 4 optional parameters:

replicaIncreaseRatio - Percentage of existing replica disk size to increase (ie. 1.1 increases by 10%. This is the default if nothing is specified)
scIncreaseRatio - Percentage of existing recovery point volume size to increase (ie. 1.1 increases by 10%. This is the default if nothing is specified)
replicaIncreaseSize - Fixed value to increase replica disk (ie. 1GB)
scIncreaseSize - Fixed value to increase recovery point volume (ie. 1GB)

The script will first query the database for alerts, and then sorts them alphabetically and by alert type...

...full description at download source.

Downloads: Process Monitoring Sample for 2-State Monitoring Tutorial

Wed, 30 Sep 2009 03:20:07 GMT

This is the sample Process Monitoring script referenced in the "HOW-TO Create a 2-State Script Monitor" tutorial for OpsMgr and Essentials 2007. Use as a learning tool only, not for production environments.

How to create a 2-State Script Monitor in OpsMgr 2007 Tutorial is available for download at http://www.systemcentercentral.com/Downloads/DownloadsDetails/tabid/144/IndexID/7362/Default.aspx

Downloads: Put any object type in maintenance mode in OpsMgr using Powershell

Tue, 15 Sep 2009 00:19:12 GMT

In OpsMgr, sometimes you may not wish to put the whole computer into maintenance mode. Instead you may wish to put just a number of databases or websites into maintenance mode. This script by Boris Yanushpolsky provides means to put any object into maintenance mode, regardless of class.

Click the link at right to visit the download page on Boris blog at Technet.

Downloads: Set Primary and Failover Mgmt Server Powershell Script for OpsMgr 2007

Mon, 14 Sep 2009 23:54:22 GMT

This sample script illustrates how to retrieve a list of agents based on a common search element, and then loop through these agents, updating the settings on each. Update setting as instructed in comments, then save with a .ps1 file. The script can be run on any computer with the Operations Console / Command Shell interfaces loaded.

Originally published in this blog post...just moving this to an easy-to-find download. Click download button at right for a downloadable copy.

P.S. - Do handle with care. Make sure your agents can reach the Mgmt Servers you specify in the script to avoid "orphaned" agents.

http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/19791/Default.aspx

Downloads: DPM 2007 Exchange Recovery Point Export Script

Thu, 27 Aug 2009 04:51:02 GMT

This Powershell script will Restore the latest recovery point for all Exchange storage groups within specified protection group to a network folder. This script is intended to run as a scheduled task to dump these recovery points to disk. This allows another backup system to back the data up to tape.

This script exports recovery points to disks serially (one at a time), but can be modified to dump all in parallel (see commented sectoin at the end of this script).

Downloads: Event-count-by-hour Powershell script

Fri, 24 Jul 2009 19:15:47 GMT

Powershell script that will retrieve a count of the number of events logged each of the last X hours from a user-defined NT Windows Event Log.

Downloads: SQL Recovery Point Restore Script for SCDPM

Tue, 21 Jul 2009 01:32:27 GMT

This Powershell script for System Center Data Protection Manager script will Restore the latest recovery point for all SQL databases within specified protection group to a network folder.

Please test thoroughly before use in a production environment.

Rename with a .ps1 extension

Downloads: Script: Query Value from SQL Database (for 2-state monitor)

Fri, 10 Jul 2009 17:49:27 GMT

This sample monitoring script illustrates how run a T-SQL query on a database and sets monitor state based on value returned. Good example of how to dynamically create the connection string when database server & database name must be discovered at runtime.

In this sample, we actually run a query to retrieve the 'Pending Actions' count from the SCOM 2007 Operational database. Since the name and server location are up to the administrator, this script actually retrieves the server and database name from the registry (when run on Mgmt Server or RMS), and runs the query.

If the count of Pending Actions is greater than your user defined threshold, it sets the health of a 2-state monitor to BAD.

This sample is intended to run on the RMS to query the Operational Database. For targeting assistance, see the sample MP from which this script was derived, the OpsMgr 2007 Extensions MP

For detailed steps on how to use a script in a script-based 2-state monitor, see the tutorial at the link below.

How to create a script-based 2-state monitor http://www.systemcentercentral.com/Downloads/DownloadsDetails/tabid/144/IndexID/7362/Default.aspx

Downloads: Script: Query Value from SQL Database and Log Event

Thu, 09 Jul 2009 13:13:26 GMT

This sample monitoring script illustrates how run a T-SQL query on a database and log an event based on value returned. Good example of how to dynamically create the connection string when database server & database name must be discovered at runtime.

If the count of Pending Actions is greater than your user defined threshold, an event is logged. This could be used with an alert-generating rule to create an alert.

To see this script in action, try the sample OpsMgr 2007 Extensions MP, which will raise an alert when you have pending actions waiting for your attention in the Operations Console.