How to Delete a State Migration Point Role

Article
05/03/2011

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

You delete the state migration point role, in Microsoft System Center Configuration Manager 2007, by deleting the role's SMS_SCI_SysResUse Server WMI Class object.

To delete a state migration point role

Set up a connection to the SMS Provider. For more information, see About the SMS Provider in Configuration Manager.
Get the SMS_SCI_SysResUse Server WMI Class object for the state migration point role.
Set the corresponding state migration point to none.
Delete the state migration point SMS_SCI_SysResUse Server WMI Class object.

Example

The following example method deletes the state migration point identified by the site code and network abstraction layer (NAL) path. The example determines whether the state migration point has any incomplete state migration restores in process. If there are any, the current implementation still deletes the state migration point.

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

public void DeleteSmpRole(
     WqlConnectionManager connection,
     string siteCode,
     string nalPath)
 {
     try
     {
         bool smpFound = false;
         Console.WriteLine("About to delete the state migration point");
         string query = string.Format(CultureInfo.InvariantCulture,
      @"SELECT * from SMS_SCI_SysResUse where SiteCode='{0}' AND FileType=2 AND RoleName='{1}'AND NALPath='{2}'",
      siteCode,
      "SMS State Migration Point",
      nalPath.Replace(@"\", @"\\"));

         IResultObject resultObjs = connection.QueryProcessor.ExecuteQuery(query);

         foreach (IResultObject resultObj in resultObjs)
         {
             smpFound = true;
             if (DeleteSmpOK(resultObj) == true)
             {
                 resultObj.Delete();
             }

             Console.WriteLine("Deleted");
         }

         if (smpFound == false)
         {
             Console.WriteLine("No state migration point was found");
         }
     }
     catch (SmsException e)
     {
         Console.WriteLine("Couldn't delete the state migration point: " + e.Message);
         throw;
     }

 }

public bool DeleteSmpOK(IResultObject selectedResultObject)
{
    IResultObject resultObjs = null;
    try
    {
        // Locate this state migration point, and determine if it is in QuiesceState or not, normal deletion
        // if it is not.
        string query = string.Format(CultureInfo.InvariantCulture,
        @"SELECT * from SMS_SCI_SysResUse where SiteCode='{0}' AND FileType=2 AND NALPath='{1}' AND RoleName='{2}'",
        selectedResultObject["SiteCode"].StringValue,
        selectedResultObject["NALPath"].StringValue.Replace(@"\", @"\\"),
        "SMS State Migration Point");

        resultObjs = selectedResultObject.ConnectionManager.QueryProcessor.ExecuteQuery(query);

        // Retrieve the state migration point server name because there could be more than one state migration point on the site, and you want to
        // determine if there are unrestored data stores on only this one.
        string smpServer = selectedResultObject["NetworkOsPath"].StringValue;
        smpServer = smpServer.Replace(@"\", "");

        foreach (IResultObject resultObj in resultObjs)
        {
            if (resultObj.EmbeddedProperties.ContainsKey("SMPQuiesceState") == true &&
                resultObj.EmbeddedProperties["SMPQuiesceState"].Properties["Value"].IntegerValue != 0)
            {
                // Find out whether this state migration point contains any stateMigrationRestores that are incomplete on this
                // server that is to be deleted.
                string query2 = string.Format(CultureInfo.InvariantCulture, @"SELECT * from SMS_StateMigration where StorePath Like '%{0}%'", smpServer);

                IResultObject resultObjs2 = selectedResultObject.ConnectionManager.QueryProcessor.ExecuteQuery(query2);

                foreach (IResultObject resultObj2 in resultObjs2)
                {
                    // Look for state migration objects without a StoreReleaseData/Migration date
                    // it's the one that will cause an exception when reading releasetime because it is not a valid datetime.
                    try
                    {
                        DateTime releaseTime = resultObj2["StoreReleaseDate"].DateTimeValue;
                    }
                    catch (ArgumentOutOfRangeException)
                    {
                        // Alternatively return false if you do not to delete.
                        return true;
                    }
                }
            }
        }
    }
    catch (SmsQueryException ex)
    {
        Console.WriteLine("Failed during smp state determination" + ex.Message);
        throw;
    }
    finally
    {
        if (resultObjs != null)
        {
            resultObjs.Dispose();
        }
    }

    // Delete the role.
    return true;
}

The example method has the following parameters:

Parameter	Type	Description
connection	Managed: WqlConnectionManager	A valid connection to the SMS Provider.
siteCode	Managed: String	The Configuration Manager site code.
nalPath	Managed: String	The NAL path to the state migration point. For example `["Display=\\SERVERNAME\"]MSWNET:["SMS_SITE=SITECODE"]\\SERVERNAME\`

Compiling the Code

The C# example has the following compilation requirements:

Namespaces

System

System.Collections.Generic

System.Text

Microsoft.ConfigurationManagement.ManagementProvider

Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine

System.Globalization

Assembly

microsoft.configurationmanagement.managementprovider

adminui.wqlqueryengine

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.

Share via