Posted by Jeremy on 16th May 2008
System Center Operations Manager 2007 is great, don’t get me wrong. But it does have it’s oddities - and one of those are messages such as these:
Details:Health service ( A63BAA7B-20B1-D6C0-75B9-8A8CE3DD7E02 ) should not generate data about this managed object ( 021971E6-1EFB-E123-7E2A-452ADB511016 ).
Now, we know that Health Service ID is referring to a specific agent, but which one? Luckily, this is fairly easy to figure out. Just hop onto the database server and run the following query:
-
SELECT DisplayName FROM BaseManagedEntity WHERE BaseManagedEntityId = ‘THE ID’
It should return the DisplayName property of said ID, which is the agent you’re looking for.
In fact, to go a step further - if you have many queries like this, you could write a PowerShell function to simplify things for you - here’s a real rough outline:
-
function Get-AgentByHSID ([string]$hsid)
-
{
-
$omdbserver = "<Set Your DB Name Here>"
-
$omdb = "OperationsManager"
-
-
$cn = new-object system.data.SqlClient.SqlConnection("Data Source=$omdbserver;Initial Catalog=$omdb;Integrated Security=SSPI;");
-
$ds = New-Object "System.Data.DataSet" "AgentName"
-
$q = "Select DisplayName from BaseManagedEntity where BaseManagedEntityId = ‘$HSID’"
-
$da = new-object "System.Data.SqlClient.SqlDataAdapter" ($q, $cn)
-
$da.Fill($ds)
-
Write-Host "HSID $HSID is associated with the following agent:"
-
$ds.tables
-
}
Like I said, the script is fairly basic and assumes a trust relationship with the database. It also expects a valid HSID - I’ll clean it up later. Edit the script, entering in your SCOM DB and DB Name if necessary, then add it to your $PROFILE. Then it’s as simple as Get-AgentByHSID “long health service guid” and it does all the heavy lifting.
Posted in Information Technology, PowerShell, Scripting | No Comments »
Posted by Jeremy on 10th March 2008
In the MS Press book “Windows PowerShell Scripting Guide” one of the first scripts listed is how to detect, via WMI & VBScript, whether or not PowerShell is installed.
In the book, it says that the best way to locate PowerShell is to use it’s QFE hotfix ID, which is listed as “928439″. This will only work with Windows Vista. If you’re using Windows XP or Windows 2003, the hotfix number if PowerShell is installed will be “926139″.
I’ve edited the original script included with the MS Press book and have added a function to determine which OS we’re looking at, then search for the corresponding hotfix ID.
In the book, it says that the best way to locate PS is to use it’s QFE hotfix ID, which is “928439″. This is, however, an incorrect hotfix ID, at least now. The most current one is 926139, which is listed as SP3. I assume 928439 was the original number, before SP3 was thought of. Not to mention, they improperly format the WMI query, so even if you used the correct number, it wouldn’t show. Note: This is on Windows XP SP2, I’m unsure if this is on other versions as well.
-
-
‘==========================================================================
-
-
‘
-
-
‘ NAME: FindPowerShell.vbs
-
-
‘
-
-
‘ AUTHOR: Jeremy D. Pavleck, based off original script by Ed Wilson , MS
-
-
‘ EMAIL: JPavleck@GMail.com
-
-
‘ DATE : 03/11/2008
-
-
‘
-
-
‘ COMMENT: Identifies if PowerShell is installed on the current machine or not.
-
-
‘ Originally this script would only work under Vista, added additional
-
-
‘ logic so it will work with other versions
-
-
‘
-
-
‘==========================================================================
-
-
Option Explicit
-
-
dim strComputer, wmiNS, wmiQuery, objWMIService, colItems, objItem, osItems, itemConst RtnImmedFwdOnly = &h30 ‘iflags for ExecQuery method of swbemservices object
-
-
strComputer = "."
-
-
wmiNS = "\root\cimv2"
-
-
Set objWMIService = GetObject("winmgmts:\\" & strComputer & wmiNS)
-
-
Set osItems = objWMIService.ExecQuery("SELECT * FROM Win32_OperatingSystem",,48) ‘ Query WMI for OS information
-
-
For Each item In osItems
-
-
If Left(item.Version, 1) = 5 Then ‘ Windows XP, 2000 & 2003 are version 5
-
-
wmiQuery = "Select * from win32_QuickFixEngineering where hotfixid like ‘%926139%’" ‘ For XP & Windows 2003
-
-
ElseIf Left(item.Version, 1) = 6 Then ‘ Windows Vista & (Presumably Server 2008) are version 6
-
-
wmiQuery = "Select * from win32_QuickFixEngineering where hotfixid like ‘%928439%’" ‘ For Vista
-
-
Else
-
-
WScript.Echo "Unable to determine OS version, quitting."
-
-
WScript.Quit
-
-
End If
-
-
Next
-
-
Set colItems = objWMIService.ExecQuery(wmiQuery,,RtnImmedFwdOnly) ‘ Now query for the hotifx, using the correct ID based on OS
-
-
For Each objItem in colItems
-
-
Wscript.Echo "PowerShell is present on " & objItem.CSName
-
-
Wscript.quit
-
-
Next
-
-
WScript.Echo "Unable to locate PowerShell on local machine"
Posted in Information Technology, PowerShell, Scripting, VBScript | 1 Comment »
