Not sure this is the correct Category, but going to give it a try.
I am attempting to locate AWS Resources that DO NOT have a required set of Tags applied at the Resource level. I have found a question posed by @KokFen.Chia asking a similar question but no responses as yet.
I can run a basic NRQL query to find all that I would like IF the Tag DOES in fact exist, but I would like a report or dashboard showing me if a Tag is completely missing, or is somehow incorrect. An implicit missing state is fine, say if a Tag exists but the spelling or capitalization is off, then I would like to know about it.
EC2 Instances should have Tags for “Cost center” and “Project”, for example. If an existing or new EC2 Instance comes online without a “Cost center” tag, or if the tag key is something different than “Cost center” (“Cost Center” for example) than I would like this to appear in my dashboard/query.
My existing query is similar to the following, but this returns only if the Tag does exist, I need to know when this Tag is missing. Changing “IS NOT NULL” to “IS NULL” changes the query output but not in a way that helps with this use case.
FROM SystemSample SELECT hostname,awsAccountId,ec2PrivateIpAddress WHERE ec2Tag_Cost center
IS NOT NULL LIMIT MAX
Thanks in advance!