Forum Discussion
SergioT1228
Feb 28, 2022Brass Contributor
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