If you’ve been reading this blog for any length of time then you’re already familiar with the postings made by Steve Rachui over on his Manageability blog, but there’s been a flurry of activity over there in the past two days and it probably deserves a quick pointer here just in case you’re not a subscriber. He’s managed to crank out 4 posts in the past two days and I have a brief snippet and link for each below:
LocalizedText issues gone in R2?
Routine maintenance to keep the LocalizedText table trim has been a part of the OpsMgr administrators world for a while now. We have had a standardized query to clean this table that is posted on many blogs around the community – Kevin has a good article on the required cleanup posted here. I recently came across a problem where this cleanup script was not fully effective.
Using a variable to query TOP N entries from SQL
I was recently building a SQL query for use in a report and was looking for a way to return the ''top N’ results from a table matching my query criteria. No big deal, right? We do this all the time with a simple statement similar to
Select TOP 10 <what you want to display> from <tablename>
Ah, but what if you want to use a variable to specify the value for TOP?
Understanding ‘nested’ management pack discoveries and how they impact total discovery time
Most management packs require discoveries be run to figure out which systems are hosting the objects we wish to monitor with the management pack. Only after the discoveries find our target objects do processes kick in to deliver appropriate monitors/rules so that monitoring begins.
Continue reading here.
Is your RMS updating configuration too frequently?
The RMS is responsible for maintaining a master list of agent configurations for the management group. As new information arrives from discoveries that are running on agents, that configuration becomes stale and needs to be updated. You can see this happening in the OpsMgr event log on the RMS – just look for an event 21025 or 21025 as shown below.
J.C. Hornbeck | Manageability Knowledge Engineer
BTW: Steve hangs out at myITforum.com, so feel free to participate there to pick his brain. :)