Chris Mague c64b9b7d39 handle errors with not really online regions yet | 6 years ago | |
---|---|---|
lib | 6 years ago | |
models | 6 years ago | |
spec | 7 years ago | |
tasks | 6 years ago | |
web | 6 years ago | |
.gitignore | 6 years ago | |
.rubocop.yml | 7 years ago | |
.ruby-gemset | 7 years ago | |
.ruby-version | 6 years ago | |
Gemfile | 6 years ago | |
QUERIES.md | 6 years ago | |
README.md | 6 years ago | |
Rakefile | 6 years ago | |
config.ru | 6 years ago | |
config.yaml.example | 6 years ago |
To audit resources to ensure that they are properly tagged run
rake audit_all
See the tag_policy section of the config.yaml.example file for ideas
1) Download and run neo4j container
docker run --rm \
--publish=7474:7474 --publish=7687:7687 \
-e NEO4J_AUTH='none' \
neo4j:3.1.4
2) Copy the config.yaml.example file to config.yaml and add in account information
cp config.yaml.example config.yaml
3) Run bundler
bundle install
4) Run the data loader
rake load_data:all
5) Point your web browswer at http://localhost:7474
All S3 buckets by size
MATCH (n:Bucket)-[o:owner]-(a:AwsAccount) RETURN n.name, n.size, a.name ORDER by n.size DESC
List out all subnets by instance count
MATCH (i: Node)-[r:subnet]-(s:Subnet)-[q:subnet]-(v:Vpc)-[o:owned]-(a:AwsAccount) WITH s, v, a, count(i) as nc RETURN s.cidr, v.name, a.name, nc ORDER by nc DESC
Find all non-default VPCs ordered by instance count
MATCH (n:Vpc) OPTIONAL MATCH (n)<-[:subnet]-(:Subnet)<-[:subnet]-(x:Node) WITH count(x) as node_count, n WHERE n.default="false" RETURN n.name, n.default, node_count ORDER by node_count DESC