Share via

Azure Azure Cache for Redis - KQL queries about service Firewall

Bart Olejnik 120 Reputation points
2023-08-02T09:24:09.86+00:00

Hi all,

I'm currently preparing KQL querises for Azure Cache for Redis which check compliance with my security requirements. One of the requirement is to check IP adressess added to the Service Firewall (where publicNetworkAccess = Enabled)

User's image

Unfortunately these values are not presents in the default JSON

User's image

resources
| where type =~ 'Microsoft.Cache/Redis'

do you know how can I listed such of entries using KQL ? (which resources I should use)

ps. I know that I can use API but for this specific case I would like to use KQL.

https://learn.microsoft.com/en-us/rest/api/redis/firewall-rules/create-or-update?tabs=HTTP

https://learn.microsoft.com/en-us/azure/templates/microsoft.cache/redis/firewallrules?pivots=deployment-language-bicep

I will be gratefull for your help.

Best regards

Bartek

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,900 questions
Azure Cache for Redis
Azure Cache for Redis
An Azure service that provides access to a secure, dedicated Redis cache, managed by Microsoft.
222 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,901 Reputation points Microsoft Employee
    2023-08-15T18:10:47.4666667+00:00

    Bart Olejnik

    Sorry for the delay in response to your previous comment.

    Firewall rules are defined as child resources under the cache resource, of "type": "Microsoft.Cache/Redis/firewallRules".

    resources

    | where type = 'Microsoft.Cache/Redis/firewallRules'

    Regards,

    Oury