从Azure存储WADSLogTable和WADWindowsEventLogsTable中删除记录

Question

将在.NET中以编程方式作为问题状态执行。我应该查看哪些图书馆？链接到代码示例非常感谢。

谢谢。

Answer 1

您可以引用下面的简单示例，它根据时间戳截断表，然后扫描表以获取数据。

    public void TruncateDiagnostics(CloudStorageAccount storageAccount, DateTime keepThreshold)
    {
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            CloudTable cloudTable = tableClient.GetTableReference("WADLogsTable");

            TableQuery query = new TableQuery();
            query.FilterString = string.Format("Timestamp lt datetime'{0:yyyy-MM-ddTHH:mm:ss}'", keepThreshold);
            var items = cloudTable.ExecuteQuery(query).ToList();

            Dictionary<string, TableBatchOperation> batches = new Dictionary<string, TableBatchOperation>();
            foreach (var entity in items)
            {
                TableOperation tableOperation = TableOperation.Delete(entity);

                if (!batches.ContainsKey(entity.PartitionKey))
                {
                    batches.Add(entity.PartitionKey, new TableBatchOperation());
                }

                batches[entity.PartitionKey].Add(tableOperation);
            }

            foreach (var batch in batches.Values)
            {
                cloudTable.ExecuteBatch(batch);
            }
    }

您可以从这个线程Windows Azure - Cleaning Up The WADLogsTable获得更多的示例。