KQL Search

Query Details

HomeAI ToolsDevice Query

Parsing Subscription Inventory Logs

Query

SubscriptionInventory_CL
| project-rename
    ResourceId = id_s,
    AuthorizationSource = authorizationSource_s,
    ResourceName = displayName_s,
    State = state_s,
    LocationPlacementId = subscriptionPolicies_locationPlacementId_s,
    QuotaId = subscriptionPolicies_quotaId_s,
    SpendingLimit = subscriptionPolicies_spendingLimit_s

Explanation

This query is pulling data from a log named 'SubscriptionInventory_CL'. It is then renaming several fields in the data for easier understanding or further processing. The 'id_s' field is being renamed to 'ResourceId', 'authorizationSource_s' to 'AuthorizationSource', 'displayName_s' to 'ResourceName', 'state_s' to 'State', 'subscriptionPolicies_locationPlacementId_s' to 'LocationPlacementId', 'subscriptionPolicies_quotaId_s' to 'QuotaId', and 'subscriptionPolicies_spendingLimit_s' to 'SpendingLimit'.

Details

Jose Sebastián Canós profile picture

Jose Sebastián Canós

Released: September 7, 2023

Tables

SubscriptionInventory_CL

Keywords

SubscriptionInventory,ResourceId,AuthorizationSource,ResourceName,State,LocationPlacementId,QuotaId,SpendingLimit

Operators

project-rename

Actions