aaronhoffman

-- more info http://aaron-hoffman.blogspot.com/2017/02/iphone-text-message-sqlite-sql-query.html
select
 m.rowid
,coalesce(m.cache_roomnames, h.id) ThreadId
,m.is_from_me IsFromMe
,case when m.is_from_me = 1 then m.account
 else h.id end as FromPhoneNumber
,case when m.is_from_me = 0 then m.account
 else coalesce(h2.id, h.id) end as ToPhoneNumber
,m.service Service

austind

Function Get-CiscoManufactureDate {
<#
    .SYNOPSIS
    Parses a modern Cisco serial number into an approximate date of
    manufacture.

    .DESCRIPTION
    Modern Cisco serial numbers encode both the year and the week of
    manufacture. Get-CiscoManufactureDate returns a corresponding DateTime
    object given a Cisco serial number, accurate to within about 7 days

chrisdiana

# Export as Text Table
aws --region XXXXXXXXX cognito-idp list-users --user-pool-id XXXXXXXXXXXXX --output table > ~/users.txt

# Export as JSON
aws --region XXXXXXXXX cognito-idp list-users --user-pool-id XXXXXXXXXXXXX --output json > ~/users.json

# Export User Pool with more than 60 users (pagination)
aws --region XXXXXXXXX cognito-idp list-users --user-pool-id XXXXXXXXXXXXX --pagination-token INCREDIBLYLONGSTRINGHERE --output json > ~/users-2.json

jedisct1

#include <stdio.h>
#include <stdlib.h>
#include <stdint.h>
#ifdef _MSC_VER
#include <intrin.h> /* for rdtscp and clflush */
#pragma optimize("gt",on)
#else
#include <x86intrin.h> /* for rdtscp and clflush */
#endif

alan-finn

if ($null -eq (Get-Module -Name AWSPowerShell)) {
  Import-Module AWSPowerShell
}

$AwsDnsBucketName = "NAME_OF_AWS_BUCKET"
$AwsCredProfileName = "NAME_OF_AWS_PROFILE"
$SmtpServer = "SMTP_SERVER"
$FromAddress = "FROM_ADDRESS"
$ToAddress = "RECIPIENT_ADRESS"