I'm looking for a solution to store audit logs for my internal web application hosted on Azure. I want to avoid creating any external dependencies like using MongoDB. Can anyone suggest software or methods specifically suited for this purpose that can be easily integrated with Azure web apps?
3 Answers
Just a heads up, if you want to store logs in a NoSQL format for flexibility (like JSON), Log Analytics might not be the best fit since it’s more SQL/table-oriented. You might want to explore other NoSQL databases offered by Azure that can accommodate changing structures in your logs.
Exactly, I need that flexibility too! Any alternatives you recommend?
You should consider using Azure Log Analytics Workspace for this. It's pretty powerful, but keep in mind that the costs can add up quickly if you're not careful with the amount of logging you do. KQL (Kusto Query Language) is fantastic for querying your logs once they're stored there. Just make sure to fine-tune what you log to keep expenses manageable!
Yeah, it's definitely one way to go. Just remember, too much logging can lead to higher bills.
I agree, KQL is great but the costs can be a concern.
If you're looking for a cheaper alternative, you might want to write compressed Parquet files directly to Azure Blob Storage. This can help keep costs down, especially if you use automated tiering to manage your storage efficiently. The choice between these options really depends on how often you'll need to query the logs and the complexity of your queries.
Yeah, I need to be able to adjust the schema of the logs easily as well.