curl 实用程序可用于直接从 MySQL Enterprise Service Manager 的受监控资产清单中请求信息。要检索有关是否可以删除特定资产的信息，检索为 JSON 数组，请使用以下语法执行 curl 请求：

    curl -k -v --user username:password 
        "https://servername:port/v4/inventory/AssetType/AssetID/deletable

在哪里：

以下示例检索具有唯一标识符的 MYSQL 实例的信息 c14ee437-a615-11e4-8334-f8b156b72e61：

      curl -k -v --user admin:mysql 
      "https://localhost:18443/v4/inventory/com.mysql.etools.inventory.model.mysql.MysqlServer/
      c14ee437-a615-11e4-8334-f8b156b72e61/deletable"

如果MySQL实例是可删除的，请求返回如下数据，确认该资产类型可以从库存中删除：

   "asset" : {
      "id" : "c14ee437-a615-11e4-8334-f8b156b72e61",
      "assetClass" : "com.mysql.etools.inventory.model.mysql.MysqlServer"
  },
  "isDeletable" : true,
  "treeDeletable" : true,
  "problems" : [ ],
  "token" : "3b66cd39467791a739e5131a8d6a856b"

在哪里：

该请求还返回一个状态代码，指示请求成功或失败。有关详细信息，请参阅 请求状态代码。

该related请求使您能够返回与类型字段中定义的主要资产相关的其他资产的数据。例如，使用 related，您可以请求 MySQL 实例和监视它的代理、它所在的主机等的可删除信息。 related还使您能够通过一个请求从库存中删除多项资产。

related采用以下值的逗号分隔列表：

请求的语法如下：

      curl -k -v --user username:password 
      "https://servername:port/v4/inventory/AssetType/AssetID/deletable?
      related=agent,mysqlserver,ndbcluster,os"

例如，以下请求有关具有 AssetID 的 MySQL 实例 c14ee437-a615-11e4-8334-f8b156b72e61和监视它的代理的可删除信息：

curl -k -v --user admin:mysql 
"https://localhost:18443/v4/inventory/com.mysql.etools.inventory.model.mysql.MysqlServer/
c14ee437-a615-11e4-8334-f8b156b72e61/deletable?related=agent"

返回以下 JSON 数组：

"asset" : {
    "id" : "c14ee437-a615-11e4-8334-f8b156b72e61",
    "assetClass" : "com.mysql.etools.inventory.model.mysql.MysqlServer"
  },
  "isDeletable" : true,
  "treeDeletable" : false,
  "problems" : [ ],
  "children" : [ {
    "asset" : {
      "id" : "b68947f9-39f2-4003-981f-8c9cc7a7409f",
      "assetClass" : "com.mysql.etools.inventory.model.agent.Agent"
    },
    "isDeletable" : false,
    "treeDeletable" : false,
    "problems" : [ {
      "code" : "IS_LIVE",
      "description" : "IS_LIVE"
    } ]
  } ],
  "token" : "d0e3607f6029a91a35a9956950908761"

返回的数据显示，虽然MySQL实例是可删除的，但不是treeDeletable，这意味着它不能在相关中删除DELETE，因为监控代理仍在运行。

要从 MySQL Enterprise Service Manager 的清单中删除单个资产，请使用以下语法：

      curl -k -v -X DELETE --header "X-Requested-With:XMLHttpRequest"
            --header "If-Match:tokenID" 
            --user admin:mysql 
            "https://servername:port/v4/inventory/AssetType/AssetID"

要从 MySQL Enterprise Service Manager 清单中删除相关资产，请使用以下语法：

      curl -k -v -X DELETE --header "X-Requested-With:XMLHttpRequest"
            --header "If-Match:tokenID" 
            --user admin:mysql 
            "https://servername:port/v4/inventory/AssetType/AssetID?
            related=agent,mysqlserver,ndbcluster,os"

例如，下面显示了一个带有返回数据的可删除请求，其中列出了一个可删除的代理、MySQL 实例、它用于监视的主机以及驻留在同一服务器上的另一个代理：

curl -k -v --user admin:mysql 
  "https://localhost:18443/v4/inventory/com.mysql.etools.inventory.model.agent.Agent/
  d71ff41c-affd-4ebe-966e-395e6f06b5e3/deletable?related=mysqlserver,os,agent"
  
  {
  "asset" : {
    "id" : "d71ff41c-affd-4ebe-966e-395e6f06b5e3",
    "assetClass" : "com.mysql.etools.inventory.model.agent.Agent"
  },
  "isDeletable" : true,
  "treeDeletable" : true,
  "problems" : [ ],
  "children" : [ {
    "asset" : {
      "id" : "sid:{S-1-5-21-700548433-2193620149-503502644}",
      "assetClass" : "com.mysql.etools.inventory.model.os.Host"
    },
    "isDeletable" : true,
    "treeDeletable" : true,
    "problems" : [ ],
    "children" : [ {
      "asset" : {
        "id" : "b68947f9-39f2-4003-981f-8c9cc7a7409f",
        "assetClass" : "com.mysql.etools.inventory.model.agent.Agent"
      },
      "isDeletable" : true,
      "treeDeletable" : true,
      "problems" : [ ],
      "children" : [ {
        "asset" : {
          "id" : "c14ee437-a615-11e4-8334-f8b156b72e61",
          "assetClass" : "com.mysql.etools.inventory.model.mysql.MysqlServer"
        },
        "isDeletable" : true,
        "treeDeletable" : true,
        "problems" : [ ]
      } ]
    } ]
  } ],
  "token" : "7048b6e53c81f549b55c5f3e861c2eee"

The following example shows a related DELETE request, deleting all assets listed as deletable in the deletable example:

curl -k -v -X DELETE --header "X-Requested-With:XMLHttpRequest" 
--user admin:mysql "https://localhost:18443/v4/inventory/com.mysql.etools.inventory.model.agent.Agent/
d71ff41c-affd-4ebe-966e-395e6f06b5e3?related=mysqlserver,os,agent"

The status code can be found in the following section of the return message, following the HTTP/1.1:

 HTTP/1.1 200
 Set-Cookie: JSESSIONID=8C0C2E1AFD45F170E7E41621F934723D; Path=/; Secure; HttpOnly
 Strict-Transport-Security: max-age=31536000 ; includeSubDomains
 Cache-Control: no-cache, no-store, max-age=0, must-revalidate
 Pragma: no-cache
 Expires: 0
 X-Content-Type-Options: nosniff
 Content-Type: application/json
 Transfer-Encoding: chunked
 Date: Tue, 24 Jul 2018 12:31:47 GMT

The following status codes are returned for deletable and DELETE requests: