March 17 2010 3:37 PM

How-To: Import Computer Location Information Into OpsMgr Using a Connector

This article gives step-by-step instructions how to feed computer location information from an external source into OpsMgr using a connector.

March 16 2010 12:56 AM

How to use the SCCM Reporting Dashboard (Beta) for OpsMgr 2007 data

Here's a neat idea from Tim McFadden, author of the Remote Maintenance Mode Scheduler for OpsMgr. Says Tim: "You might have noticed that the SCCM Reporting Dashboard (Beta) was released about a month ago. But what most of you don’t know is that you can u

March 15 2010 6:12 PM

What is ODR and Why do we Care?

After reading Ake’s post the logic to enabling the Operational Data Reporting make a lot more sense now. The screenshots in his post show the type of information that Microsoft can get to their MP developers based upon how the MP’s are functioning in the

March 14 2010 10:08 PM

Kris Bash: Building an Oracle Management Pack for OpsMgr Cross-Platform Agents, Part 1

Very cool to see someone forging ahead with OpsMgr X-Plat authoring....Go Kris! Says Kris: "Over a series of future posts, I intend to describe my efforts to build an OpsMgr SCX Management Pack for monitoring of Oracle running on UNIX/Linux platforms. In

March 14 2010 12:00 PM

Collection Query for Systems with a particular application installed (or not installed)

When creating a dynamic collection in ConfigMgr 2007 for applications with a particular application installed, you can simply replace the application name with the application of your choice by look at Add/Remove Programs. Take the name from there and pu

March 14 2010 11:54 AM

ConfigMgr Collection Query for Windows 7 Systems

We had a thread on SCC about a Windows 7 collection query, and I believe this is the one we ended up with based on that chat. Here is the collection query to create a dynamic collection of Windows 7 systems in ConfigMgr 2007. select SMS_R_SYSTEM.Resource

March 14 2010 11:51 AM

ConfigMgr Collection Query for Windows 2008 Server Systems

Here's the collection query for Windows 2008 Server Systems select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainOrWorkgroup, SMS

March 14 2010 11:28 AM

ConfigMgr Collection Query to find all Systems in an Active Directory OU

Here's another I've been playing with. ConfigMgr collection query with variables. Here's a collection query that SELECT * FROM SMS_R_System WHERE SystemOUName like "%PLAY% How to create custom collection with a query Here's a write up on how to add your

March 14 2010 11:08 AM

ConfigMgr Collection Query to find Systems with a Windows service installed (or not installed)

Here's a ConfigMgr 2007 collection query I've been using to find Systems without an OpsMgr 2007 agent installed. This query will show you systems with the System Center Management service (HealthService) installed select SMS_R_SYSTEM.ResourceID,SMS_R_SYS

March 13 2010 11:01 AM

Helpful queries for spotting OpsMgr agents with health issues

I decided to clean up some Operations Manager (OpsMgr) agent issues agent problems in my environment this morning and find the completely dead ones. Here are the queries I used to find them... Problems with the Health Service Watcher (Kevin) select bme.D