In Microsoft System Center Configuration Manager 2007, you can read user-defined status messages, on the site server, by querying the SMS Provider.

To read a user-defined status messages

  1. Set up a connection to the SMS Provider. For more information, see About the SMS Provider in Configuration Manager.

  2. Query the provider for the SMS_StatusMessage instances you want. As part of the query get the insertion string values from SMS_SMS_StatMsgInStrings and the attribute value from SMS_StatMsgAttributes.

Example

The following example reads error message status messages for the sample created in How to Report User-Defined Status Messages. Make sure the MyPackageID and MyApplication values in the query match in both samples.

For information about calling the sample code, see Calling Configuration Manager Code Snippets.

Visual Basic Script  Copy Code
Sub ReadErrorStatusMesage(connection)

	Dim queryWQL
	Dim message
	Dim messageSet
	Dim statusMessage
	Dim insertionString
	Dim attributes

	queryWQL = "SELECT b.Component, b.MachineName, b.MessageType, b.MessageID, " & _
			"	 c.InsStrValue, d.AttributeValue " & _
			"FROM SMS_StatusMessage b " & _
			"	 JOIN SMS_StatMsgInsStrings c ON b.RecordID = c.RecordID " & _
			"	 JOIN SMS_StatMsgAttributes d ON c.RecordID = d.RecordID " & _
			"WHERE b.Component = 'MyApplication' " & _
			"AND   d.AttributeID = 400 " & _
			"AND   d.AttributeValue = 'MyPackageID' "

	Set messageSet = connection.ExecQuery(queryWQL)

	For Each message in messageSet
	
		' Get the message objects.
		statusMessage = message.Properties_.Item("b")
		insertionString = message.Properties_.Item("c")
		attributes = message.Properties_.Item("d")
	
		' Display the message details.
		WScript.Echo "Message: " + insertionString.Properties_.Item("insstrvalue")
		WScript.Echo "Component: " + statusMessage.Properties_.Item("Component")
		WScript.Echo "Machine: " + statusMessage.Properties_.Item("MachineName")
		WScript.Echo "MessageID: " + Cstr(statusMessage.Properties_.Item("MessageID"))
		WScript.Echo attributes.Properties_.Item("attributevalue")
		WScript.Echo
	 
	Next					

 End Sub
C#  Copy Code
public void ReadErrorStatusMessage(WqlConnectionManager connection)
{
	try
	{
		string queryWQL = "SELECT b.Component, b.MachineName, " +
				"	 b.MessageType, b.MessageID, " +
				"	 c.insstrvalue, d.attributevalue " +
				"FROM SMS_StatusMessage b " +
				"	 JOIN SMS_StatMsgInsStrings c ON b.RecordID = c.RecordID " +
				"	 JOIN SMS_StatMsgAttributes d ON c.RecordID = d.RecordID " +
				"WHERE b.Component = \"MyApplication\" " + 
				"AND   d.AttributeID = 400 " +
				"AND   d.AttributeValue = \"MyPackageID\" ";

		IResultObject query = connection.QueryProcessor.ExecuteQuery(queryWQL);
		foreach (IResultObject o in query)
		{

			ManagementBaseObject  statusMessage = (ManagementBaseObject)o["b"].ObjectValue;
			ManagementBaseObject insertionString = (ManagementBaseObject)o["c"].ObjectValue;
			ManagementBaseObject attributes = (ManagementBaseObject)o["d"].ObjectValue;

			Console.WriteLine("Message: " + insertionString["insstrvalue"]);
			Console.WriteLine("Component: " + statusMessage["Component"]);
			Console.WriteLine("Machine: " + statusMessage["MachineName"]);
			Console.WriteLine("MessageID: " + statusMessage["MessageID"]);
			Console.WriteLine(attributes["attributevalue"]);
			Console.WriteLine();
	}
}
	catch (SmsException ex)
	{
		Console.WriteLine("Failed to read status message: ", ex.Message);
		throw;
}
}

The example method has the following parameters:

Parameter Type Description

connection

  • Managed: WqlConnectionManager

  • VBScript: SWbemServices

A valid connection to the SMS Provider. For more information, see About the SMS Provider in Configuration Manager.

Compiling the Code

This C# example requires:

Namespaces

System

System.Collections.Generic

System.Text

System.Management

Microsoft.ConfigurationManagement.ManagementProvider

Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine

Assembly

adminui.wqlqueryengine

microsoft.configurationmanagement.managementprovider

System.Management

Robust Programming

For more information about error handling, see About Configuration Manager Errors.

Security

For more information about securing Configuration Manager applications, see About Securing Configuration Manager Applications.

See Also


Send comments about this topic to Microsoft.