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)
#!/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' |
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)
-- 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, |
CLUSTER="your_cluster_name" | |
REGION="cluster_region" | |
PRIVATE_SUBNETS="subnet-someSubnet123,subnet-someOtherSubnet456" | |
TASK_SECURITY_GROUP="security-group-for-ECS-task-ID" | |
PUBLIC_IP_SETTING="DISABLED" | |
TASK_CONTAINER_NAME_FOR_ECS_EXEC="container-name-for-ecs-exec" | |
# Run a Fargate task with ECS Exec enabled: | |
RUN_TASK_RESULT=$( | |
aws ecs run-task \ |
-- I was helping a company using Google Workspace for email, and they were having challenges | |
-- with email deliverability due to domain reputation. While it's true that gmail provides | |
-- provides detailed logs, I found their docs to be only marginaly helpful and lacking | |
-- more robust, real-world ways to interpret the data. I also struggled to find quality examples | |
-- when searching unofficial sources (blogs, etc.). | |
-- | |
-- The query below is my best effort attempt to translate gmail logs into something half-way usable. | |
-- I'd be shocked if there weren't mistakes or areas for improvement, but either way, sharing in | |
-- the hope that it at least helps give a jumping-off point for anyone else that finds themselves | |
-- saying "OK, I enabled Gmail Logs for BigQuery.... now what?". |
astroid==2.15.6 | |
autoflake==2.2.1 | |
autopep8==2.0.4 | |
boto3==1.28.52 | |
botocore==1.31.52 | |
certifi==2023.7.22 | |
chardet==5.2.0 | |
charset-normalizer==3.2.0 | |
contourpy==1.1.1 | |
coverage==7.3.1 |
/* eslint-disable no-prototype-builtins */ | |
var express = require('express'); | |
var ip = require("ip"); | |
var fetchTimeout = require('fetch-timeout'); | |
/* | |
This app creates a simple HTTP listener and responds to GET / requests by | |
displaying basic info about the container (e.g. IP address) and, optionally, | |
ECS metadata if the container is running on EC2 or Fargate via ECS. |
# Example command | |
eksctl create iamidentitymapping \ | |
--cluster YOUR_CLUSTER_NAME \ | |
--arn arn:aws:iam::999999999999:role/AWSReservedSSO_YOUR-ROLE_NAME_xxxxxxxxxxxc \ | |
--username cluster-admin \ | |
--group system:masters |