Skip to content

Instantly share code, notes, and snippets.

timestamp tag value questionable substituted annotated
2019-05-30T01:25:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 State: 249(Set: 0) False False False
2019-05-30T01:35:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 197.5291 False False False
2019-05-30T01:40:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 192.3548 False False False
2019-05-30T01:45:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 195.4681 False False False
2019-05-30T01:50:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 177.2453 False False False
2019-05-30T01:55:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 179.744 False False False
2019-05-30T02:00:00.000Z OSIDemo_Pump Station _Pump01.Bearing Temperature.258452c3-4a3b-5ecf-157a-34f81f110848 177.2966 False False
$destinationFolder = "C:\Users\student01.PISCHOOL\desktop\"
$fileName = "sample"
$suffix = ".csv"
$filePath = "$($destinationFolder)$($fileName)$($suffix)"
Add-Content -Path $filePath -Value 'timestamp,tag,value,questionable,substituted,annotated'
# Start Time and End Time to get Archive Data

Demo (Prepare)

Create an Ubuntu Workstation and use VSCode (Insiders) remote-ssh extension to SSH to it.

Install Azure CLI

# Install CLI
curl -sL https://aka.ms/InstallAzureCLIDeb | sudo bash

Demo (Prepare)

Introduce CloudShell

Install DirEnv in CloudShell

git clone https://github.com/direnv/direnv.git
cd direnv
version: '3'
services:
sai-sample:
image: "microsoft/aci-helloworld"
deploy:
replicas: 10
This is Release 1
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters":{
"prefix": {
"type": "string",
"metadata": {
"description": "Small unique string."
},
"minLength": 2,
# Install Chocolatey
Set-ExecutionPolicy Bypass -Scope Process -Force;
# Install AzureRM Powershell Module
Install-Module -Name Azure -Repository PSGallery -Force -AllowClobber
Install-Module -Name AzureRM -Repository PSGallery -Force -AllowClobber
Import-Module -Name Azure
Import-Module -Name AzureRM
@danielscholl
danielscholl / page2block.ps1
Last active June 21, 2018 21:33
PowerShell Script to convert a container of page blobs to block blobs
<#
.SYNOPSIS
Page Blob to Block Blob Copy Script
.DESCRIPTION
Using a Data Factory copy a blob from one place to another
** DOWNLOAD IT **
$url = "https://gist.githubusercontent.com/danielscholl/d9f26bb5ae13980ad5f09ece7582fccd/raw/fb3447098251838a9a5c9fdb94c745e86339cfca/page2block.ps1"
Invoke-WebRequest -Uri $url -OutFile page2block.ps1
#!/usr/bin/env bash
# Copyright (c) 2017, cloudcodeit.com
#
# Purpose: Create a App Service Web App
# Usage:
# web-app-git.sh <unique> <src_directory> <location>
###############################
## SCRIPT SETUP ##