Sub MigrationState(connection)

	Dim migrations
	Dim migration
	Dim inProgress
	Dim zeroTime
	
	zeroTime = "00000000000000.000000+***"

	Set migrations = connection.ExecQuery( "Select * From SMS_StateMigration")

	For Each migration in Migrations
		inProgress=False
			
		If migration.StoreCreationDate<>zeroTime Then
			If migration.StoreReleaseDate = zeroTime Then
				inProgress=True
			Else If migration.StoreDeletionDate = zeroTime Then
				inProgress = True
			Else
				inProgress = false
			End If
		End If   
		Else
			inProgress=False
		End If
		 
		WScript.StdOut.Write "Migration " + migration.MigrationID
		If inProgress = True Then
			Wscript.Echo " is in progress"
		Else
			WScript.Echo " is not in progress"
		End If   
	Next

End Sub   

public void MigrationState(WqlConnectionManager connection)
{
	try
	{
		IResultObject migrations =
			connection.QueryProcessor.ExecuteQuery("Select * from SMS_StateMigration");

		string zeroTime = "00000000000000.000000+***";

		foreach (IResultObject migration in migrations)
		{
			Boolean inProgress = false;
		

			if (migration["StoreCreationDate"].DateTimeValue.Equals(zeroTime) == false)
			{
				if (migration["StoreReleaseDate"].DateTimeValue.Equals(zeroTime) == true)
				{
					inProgress = true;
			}
				else if (migration["StoreDeletionDate"].DateTimeValue.Equals(zeroTime) == true)
				{
					inProgress = true;
			}
				else
				{
					inProgress = false;
			}
		}
			else
			{
				inProgress = false;
		}

			Console.Write("Migration " + migration["MigrationID"].StringValue);
			if (inProgress)
			{
				Console.WriteLine(" is in progress");
		}
			else
			{
				Console.WriteLine(" is not in progress");
		}
	}
}
	catch (SmsException e)
	{
		Console.WriteLine("Failed while displaying migration state: " + e.Message);
		throw;
}
}