Google sheet formula to convert a ISO86001 string to a date time:
Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)
Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))
Output: (a properly-formatted datetime)
Mathew Werber matwerber1
matwerber1
/ athena-query-for-cloudtrail-route53-dns-changes.sql
Last active
October 15, 2023 04:42
Example SQL to search CloudTrail Logs stored in S3 using Amazon Athena for any changes to Route 53 DNS records#
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Query assumes your Athena table is partitioned with a "day" column as described here: | |
| -- https://www.linkedin.com/pulse/using-athena-partition-projection-query-cloudtrail-other-kinsman/ | |
| with detail AS ( | |
| SELECT | |
| day, | |
| eventtime as timestamp, | |
| account, | |
| awsregion as region, | |
| eventid, |
matwerber1
/ google-sheet-formula-parse-iso86001-date-strings.md
Created
July 30, 2022 03:28
Google Sheet Formula to convert ISO86001 date from string to usable timestamp data type.
matwerber1
/ ec2-node-amzn.sh
Created
September 26, 2018 02:57
— forked from ogckw/ec2-node-amzn.sh
ec2-amazon-linux-node-userdata
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Program: | |
| # EC2 initially install node.js, git for development environment. | |
| # You can modify nodev and nvmv for changing node and nvm version. | |
| # Set permission to ec2-user install above. | |
| # History: | |
| # 2017/07/25 Hans First release | |
| home=/home/ec2-user | |
| nodev='8.11.2' | |
| nvmv='0.33.11' |
NewerOlder