Forum Discussion

Vino55's avatar
Vino55
Icon for Microsoft rankMicrosoft
Jan 30, 2019

How to delete table under CustomLogs ingested using HTTP Datacollector API?

Hi,

 

How to delete the customLog table ? 

I have created a custom log table using HTTP Datacollector API. How do I delete the table later?

I even could not see my custom log table under Advanced settings -> Data -> Custom Logs.

However I can query on the custom log table in Log search.

Also, What is the retention policy of the data ingested using HTTP Datacollector API?

 

Thanks.

 

  • Hi,

    First the retention policy of custom data is the retention policy of any data in your Log Analytics workspace. By default workspace have retention of 31 days but that is configurable setting so it depends on what you have changed it to if you had at all. You can remove the custom log from Log Analytics blade - > Advanced Settings - > Data -> Custom Fields. There you can see all your custom fields for your custom log data. Once you remove the custom fields for the custom log, when you query the custom log you will get only records with Time Generated. Deleting data from Log Analytics is also possible but be careful. Read the instructions carefully:

    https://docs.microsoft.com/en-us/azure/azure-monitor/platform/personal-data-mgmt

     

    The menu that you are describing is for custom logs feature but not for logs from Ingestion API.

    • Craig635's avatar
      Craig635
      Icon for Microsoft rankMicrosoft
      Great find but when deleting the log using that API the old data still exists if I create the table again.
      • mcripps's avatar
        mcripps
        Copper Contributor

        Craig635 

        How long did you wait before re-creating?  I think I noticed this too, but if I waited long enough, it was gone for good.

  • Hi,

    First the retention policy of custom data is the retention policy of any data in your Log Analytics workspace. By default workspace have retention of 31 days but that is configurable setting so it depends on what you have changed it to if you had at all. You can remove the custom log from Log Analytics blade - > Advanced Settings - > Data -> Custom Fields. There you can see all your custom fields for your custom log data. Once you remove the custom fields for the custom log, when you query the custom log you will get only records with Time Generated. Deleting data from Log Analytics is also possible but be careful. Read the instructions carefully:

    https://docs.microsoft.com/en-us/azure/azure-monitor/platform/personal-data-mgmt

     

    The menu that you are describing is for custom logs feature but not for logs from Ingestion API.

Resources