Running reports – how can I run historical reports on agents that have been decommissioned?

  When we delete an agent from monitoring, we do NOT delete the agent data from the Data Warehouse – by design of course.   However – when running a report, the deleted agent was not showing up.  For instance – I am running the Windows Server 2003 Operating System – Operating System Performance report….

0

Silect MPAuthor version 7.0 released

  The free version of Silect’s MP Author just released a new version:  7.0 http://www.silect.com/mp-author   June 2016: MP Author Version 7.0 The enhancements in MP Studio and MP Author consist of a number of changes to improve reliability and performance including the following: “Event Description” has been added as an expression option for both…

0

Getting SQL Admin Studio to connect to your SQL Cluster

I had hell yesterday figuring out what was wrong with this. I built a new SQL 2005 cluster, on Server 2003×64, to install my SCOM R2 release candidate environment into.  I used iSCSI for my cluster, and my nodes are VM guests under Hyper-V, the same basic process that I documented here:  Setting up a…

0

Service Pack 1 ships for Server 2008R2 and Windows 7

Microsoft recently announced the release of Service Pack 1 for both Server 2008 R2 and Windows 7. SP1 is available for download with your MSDN subscription now, and general availability on Feb 22.   Documentation on SP1, what it includes, and changes to each OS is available here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=61924cea-83fe-46e9-96d8-027ae59ddc11&displaylang=en   I have been running SP1…

0

Internet Explorer 9 ships final version today

http://windows.microsoft.com/en-us/internet-explorer/products/ie/home   I have been using IE9 from beta, to RC, and now I am on the RTM version which shipped last night.  I really, really like IE9.  It is crazy fast, and very secure.  While on the beta version – there where a bunch of websites that I had trouble with – but enabling…

0

AD Role Holders Report – how to get data

The “AD Role Holders” report has some incorrect description information on how to run the report.  If you follow the instructions… adding the “Active Directory Domain Controller Computer Role” you will get no data returned.  This will be fixed in an upcoming ADMP update… but in the meantime:   Instead – you need to add…

0

Windows 10 Client MP’s are available

    Download here:    https://www.microsoft.com/en-us/download/details.aspx?id=51189 The client OS MP’s are available when you need to monitor Windows clients in your SCOM management group.  These might be “light” monitoring of desktops and laptops in the organization, or these might be for mission critical roles such as Kiosks and ATM type machines running a Windows client OS….

0

New SQL MP released – version 6.0.6648.0 and why you NEED it.

  Get it from the MP catalog:  http://technet.microsoft.com/en-us/opsmgr/cc539535.aspx   This is considered a “minor” update.  However, there are some SIGNIFICANT changes you should consider.  Not all of the changes are documented in the guide.   I did a XML diff of the files to see what is new:   Some of the changes: In previous…

0

Getting Monitor State Change Events via PowerShell

    This is a script example on how to get statechangeevents from monitor context using PowerShell.  This example uses a URL transaction monitor, but you can change this to any class/classinstance.   #Set arrays to empty $Monitor = @() $MonitorColl = @() $States = @() #Get Web Transaction URL Class $URLClass = Get-SCOMClass -Name…

0

Writing reports against RAW Perf data in the Data Warehouse

By default – our generic reports access *aggregated* data in the warehouse… either daily or hourly.  These contain information like number of data points, avg, min, max, and std. deviation data.  However, sometimes users will want access to the RAW, individual data points. This is kept in the warehouse – and you can see it…

0

Silect offers new MP Authoring tool – MP Author Professional

  http://www.silect.com/content/mp-author-professional   Building on the simple-to-use, free MP Author tool, they released MP Author Professional.  It adds/extends many more monitoring scenarios to the basic version.  

0

Silect wants your feedback – support fragments in MP Author?

  Silect is looking for user community feedback, to see if it is valuable to support the import of VSAE fragments into MP author, to extend the types of workflows that MP Author could support. They are looking to see how valuable this would be, and how many MP authors would actually use and benefit…

0

Alerting on Events – waiting for a specific amount of time to pass

  Consider the scenario –  you want to monitor the event logs for a specific event, however, this event has a tendency to “storm” or log hundreds of events in a short time window.  Not a good condition for a monitoring system, as you can quickly overwhelm the system, nor do you want hundreds or…

0

Update: Automating Run As Account distribution dynamically

  Just an FYI – I have updated the automatic run as account distribution script I published, to make it more reliable in large environments, limit resources used and decrease the chance of a timeout, along with adding better debug logging.   Get the script and read more here: Automating Run As Account Distribution –…

0

Updated Scheduled Maintenance Mode scripts for R2

Tim McFadden of Microsoft PFE has updated the scripts for his “SCOM Remote Maintenance Mode Scheduler 2.0” tool.  They now work with R2 and wont put the HealthService or HealthService Watcher into maintenance mode, as this is automatic in R2 and not necessary. Get the original tool:  SCOM Remote Maintenance Mode Scheduler 2.0 Get the…

0

Microsoft iSCSI target software 3.3 now available for free download

  I did not realize we had updated this to version 3.3 and released it for download.  Previously this iSCSI software was only available in Microsoft Windows Storage Server SKU’s.  Now this is a separate download and you can install this on any Windows 2008 R2 server with no additional licensing requirements!   The Microsoft…

0

How to move views in My Workspace into a Management Pack

  Customers often use “My Workspace” to create customized views that they use on a regular basis.  However, one of the drawbacks on My Workspace is that these views are not available to any other users.  Generally, we recommend customers use My Workspace to test and develop views, then simply re-create them in a Management…

0

DataWarehouse StandardDataSetMaintenance fails due to too many tables

I wrote previously about the most common issues that cause the StandardDataSetMaintenance to fail: http://blogs.technet.com/b/kevinholman/archive/2010/08/30/the-31552-event-or-why-is-my-data-warehouse-server-consuming-so-much-cpu.aspx   One of those reasons can be caused by using SQL 2005, and having long retention with large amounts of data being stored.  This can bring about a situation where more than 256 tables exist for a given dataset (state,…

0