public void DeletePxeRole(
	WqlConnectionManager connection,
	string siteCode,
	string nalPath)
{
	bool roleFound = false;
	try
	{
		// Get the PXE service point role.
		string query = string.Format(
			CultureInfo.InvariantCulture,
			@"SELECT * from SMS_SCI_SysResUse where SiteCode='{0}' AND FileType=2 AND RoleName='SMS Pxe Service Point'AND NALPath='{1}'",
			siteCode,
			nalPath.Replace(@"\", @"\\"));

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

		IResultObject resultObj = null;

		foreach (IResultObject pxeSiteRole in resultObjs)
		{
			roleFound = true;
			Console.WriteLine("Trying to delete: " + pxeSiteRole["RoleName"].StringValue);

			int pxeRoleState = -1;
			int blockingPackages = -1;

			// Get the PXE role state.
			string querySummarizer = string.Format(
				CultureInfo.InvariantCulture,
				@"SELECT * FROM SMS_SiteSystemSummarizer Where SiteCode=""{0}"" And SiteSystem=""{1}"" And Role=""SMS PXE Service Point""",
				pxeSiteRole["SiteCode"].StringValue,
				pxeSiteRole.ConnectionManager.EscapeQueryString(pxeSiteRole["NalPath"].StringValue, ConnectionManagerBase.EscapeQuoteType.DoubleQuote));

			resultObj = connection.QueryProcessor.ExecuteQuery(querySummarizer);

			foreach (IResultObject item in resultObj)
			{
				pxeRoleState = item["AvailabilityState"].IntegerValue;
				break;
		}

			// Get any blocking packages.
			string sharePath = pxeSiteRole["NetworkOSPath"].StringValue + "\\SMSPXEIMAGES$\\";

			query = string.Format(
				CultureInfo.InvariantCulture,
				@"SELECT Count(*) FROM SMS_PackageStatusDistPointsSummarizer Where SiteCode=""{0}"" And ServerNALPath = ""{1}""",
				pxeSiteRole["SiteCode"].StringValue,
				pxeSiteRole.ConnectionManager.EscapeQueryString(nalPath, ConnectionManagerBase.EscapeQuoteType.DoubleQuote));

			resultObj = pxeSiteRole.ConnectionManager.QueryProcessor.ExecuteQuery(query);

			foreach (IResultObject item in resultObj)
			{
				blockingPackages = item["Count"].IntegerValue;
				break;
		}

			// if (PXE Role State is Online) and (On PXE DP Package Count > 0)
			if ((pxeRoleState == 1) && (blockingPackages > 0))
			{
				Console.WriteLine("Remove all packages before deleting the PXE role");
				throw new ApplicationException("Remove all packages before deleting the PXE role");
		}
			else
			{
				pxeSiteRole.Delete();
				Console.WriteLine("Deleted");
		}
	}
}
	catch (SmsException e)
	{
		Console.WriteLine("Failed to delete PXE service point role: " + e.Message);
		throw;
}
	finally
	{
		if (roleFound != true)
		{
			Console.WriteLine("No matching PXE service points were found");
	}
}
}