Forum Discussion

SergioT1228's avatar
SergioT1228
Brass Contributor
Feb 28, 2022

Help with Replace SubID with SubName

Hello, I need to replace the SubscriptionID with the SubscriptionName:

 

 

 

securityresources
| where type == "microsoft.security/securescores"
| extend secureScore = round(100 * bin((todouble(properties.score.current))/ todouble(properties.score.max), 0.001))
| where secureScore > 0
| project secureScore, subscriptionId
| order by secureScore asc

 

 

So in the project, I'd like to have something like, if subscriptionID = 60b23451-dr1d-4f66-bca6-9b5a760ad546, display ENT-Prod-01.

 

This will show my Secure Score with the Sub. Name.

 

Thanks for the help,

Serge

No RepliesBe the first to reply

Resources