How do I look up my AWS Account Names?

Hello! I’m new to NewRelic. We have AWS integration turned on, in our NewRelic account. How do I look up the NewRelic ID and human-readable name of each AWS account?

I tried:

FROM FinanceSample select providerAccountId,providerAccountName

but that only shows one AWS account. (I’ve tried it twice, and it shows a different AWS account each time.)

I want to see all the accounts.

Hi, @atsalolikhin: Try this:

FROM FinanceSample 
SELECT count(*) 
SINCE 1 day ago 
FACET providerAccountId, providerAccountName 
LIMIT MAX
2 Likes

That did it! Thanks, @philweber! :smiley:

1 Like

YAY!! That’s awesome. Thanks for sharing :star_struck: