Mar 10 2019
11:54 PM
- last edited on
Apr 07 2022
05:42 PM
by
TechCommunityAP
Mar 10 2019
11:54 PM
- last edited on
Apr 07 2022
05:42 PM
by
TechCommunityAP
Hi,
From our RP, we send resourceId along with other data to LA workspace through shoebox pipeline.
I notice that apart from the data RP sends, I see other extra metadata fields like tenant id, subscription Id.
Subscription name information is not available in AzureDiagnostics table.
However, when I checked the overview blade of LA workspace, I notice that subscription name is shown.
I am wondering if it is possible to fetch subscription name using LA RestAPI? If not LA, any other Azure resource Rest API would provide that? Any pointers would be helpful.
Mar 11 2019 09:17 AM
Two options:
1. Some tables have this data, I know if I run
//AzureNetworkAnalytics_CL search "< insert name of your subscription here>" | summarize by $table
I can see
let mysub = datatable (SubscriptionId:string, SubName:string) [ "fakesubid-12344", "Demo workdpace1", "fakesubid-12345", "Demo workspace2" ]; AzureDiagnostics | join (mysub) on SubscriptionId | where SubscriptionId =="fakesubid-12345" | project SubName, SubscriptionId