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
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’ […]
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. In this sample, we actually run a query to retrieve the ‘Pending Actions’ […]
Resolves rule-generated alerts in SCOM 2007 older than X days old. Powershell script that resolves all alerts more than X days old in Operations Manager 2007. Includes connection string to RMS so the script can be run as a scheduled task to keep old alerts cleared out. Run with no arguments to echo syntax.
This VBScript will read a list of systems from a text file and add them to an existing SMS / SCCM collection. Does work on SCCM 2007 R2. Rename with .vbs extension. Run with no arguments to display syntax information.
Powershell script prompts user for SCVMM Server and Hyper-V host and then 1) Marks Hyper-V host as unavailable for placement and 2) Takes a snapshot of all VMs on host and labels as “Checkpoint Before Hotfix Application” Designed to be run from the SCVMM Administrator Console (right-click launch from Library)
Checks web page at a given URL for HTTP 200 response and presence of user-defined text string.
2 Scripts here. 1 for checking version compliance for SQL Reporting Services and the second for checking the version of SQL 2000.
This is a SQL Space Monitoring that uses a stored procedure to get DB and log used space rather than relying on SQL DMO. Drawback is that you have to place the stored procedure in the master DB for each instance of SQL
This archive contains Powershell scripts that can be ran from the command line to put agents or a group of agents into maintenance. Very handy!