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
Protocol Host Url Bytes | |
HTTPS kloud1.sharepoint.com /default.aspx 141,882 | |
HTTPS kloud1.sharepoint.com /SiteAssets/Kloud-Logo-Intranet.jpg?rev=37 29,667 | |
HTTPS kloud1.sharepoint.com /_layouts/15/images/loadingcirclests16.gif?rev=37 420 | |
HTTPS cdn.sharepointonline.com /10216/_layouts/15/16.0.2916.1214//online/scripts/sposuitenav.js 5,091 | |
HTTPS cdn.sharepointonline.com /10216/_layouts/15/16.0.2916.1214/1033/strings.js 41,510 | |
HTTPS prod.msocdn.com /3.06.5330.0/en-US/JSC/Shell15Bundle.js 63,492 | |
HTTPS prod.msocdn.com /3.06.5330.0/en-US/css/O365Shell15.css 3,946 | |
HTTPS cdn.sharepointonline.com /10216/_layouts/15/16.0.2916.1214/sp.core.js 15,203 | |
HTTPS prod.msocdn.com /3.06.5330.0/en-US/css/icons/O365Icons.eot? 14,693 |
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
"C:\Program Files (x86)\Windows Kits\8.1\bin\x64\makecert" -r -pe -n "CN=Petes Root Authority" -ss CA -sr CurrentUser -a sha1 -sky signature -cy authority -sv CA.pvk CA.cer |
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
"C:\Program Files (x86)\Windows Kits\8.1\bin\x64\makecert" -pe -n "CN=tenant.sharepointonline.com" -a sha1 -sky Exchange -eku 1.3.6.1.5.5.7.3.1 -ic CA.cer -iv CA.pvk -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12 -sv tenant.sharepointonline.com.pvk tenant.sharepointonline.com.cer | |
"C:\Program Files (x86)\Windows Kits\8.1\bin\x64\pvk2pfx" -pvk tenant.sharepointonline.com.pvk -spc tenant.sharepointonline.com.cer -pfx tenant.sharepointonline.com.pfx |
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
"C:\Program Files (x86)\Windows Kits\8.1\bin\x64\makecert" -pe -n "CN=cdn.sharepointonline.com" -a sha1 -sky Exchange -eku 1.3.6.1.5.5.7.3.1 -ic CA.cer -iv CA.pvk -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12 -sv cdn.sharepointonline.com.pvk cdn.sharepointonline.com.cer | |
"C:\Program Files (x86)\Windows Kits\8.1\bin\x64\pvk2pfx" -pvk cdn.sharepointonline.com.pvk -spc cdn.sharepointonline.com.cer -pfx cdn.sharepointonline.com.pfx |
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
<rewrite> | |
<rules> | |
<rule name="ReverseProxyInboundRule1" enabled="true" stopProcessing="true"> | |
url="(.*)" /> | |
<conditions trackAllCaptures="true"> | |
https?)://" /> | |
<add input="{HTTP_HOST}" pattern="^(.*)" /> | |
</conditions> | |
<action type="Rewrite" url="{C:1}://{C:2}/{R:1}" /> | |
</rule> |
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
$subscriptionName = <subscriptonname> | |
$storageLocation = <vhdstorage> | |
Set-AzureSubscription -SubscriptionName $subscriptionName -CurrentStorageAccountName $storageLocation | |
Select-AzureSubscription -SubscriptionName $subscriptionName | |
$username = <username> | |
$password = <password> | |
$secpasswd = ConvertTo-SecureString $password -AsPlainText -Force | |
$vmPrefix = “O365Accel” | |
$vmImageLocation = "http://" $storageLocation ".blob.core.windows.net/vhd" |
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
<?xml version="1.0" encoding="UTF-8"?> | |
<configuration> | |
<system.webServer> | |
<rewrite> | |
<rules> | |
<rule name="ReverseProxyInboundRule1" enabled="true" stopProcessing="true"> | |
<match url="(.*)" /> | |
<conditions trackAllCaptures="true"> | |
<add input="{CACHE_URL}" pattern="^(https?)://" /> | |
<add input="{HTTP_HOST}" pattern="^(.*sharepoint.*|.*msocdn.*)" /> |
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
let | |
PortfolioSource = Excel.CurrentWorkbook(){[Name="Portfolio"]}[Content], | |
#"sParam" = Text.Combine(Table.ToList(Table.SelectColumns(PortfolioSource, "Symbol")),","), | |
#"Fields" = Excel.CurrentWorkbook(){[Name="FieldLookup"]}[Content], | |
#"DisplayFields" = Table.SelectRows(#"Fields",each [Display]=true), | |
#"fParam" = Text.Combine(Table.ToList(Table.SelectColumns(#"DisplayFields", "f")),""), | |
#"DisplayColumns" = Table.ToList(Table.SelectColumns(#"DisplayFields", "Name")), | |
#"TypeNames" = Table.SelectRows(Table.SelectColumns(#"DisplayFields", {"Name","Type"}), each [Type]="number"), |
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
let | |
Source = Csv.Document(Web.Contents("http://ichart.finance.yahoo.com/table.csv?s=CPU.AX&a=00&b=4&c=2014&d=07&e=01&f=2015&g=d&ignore=.csv"),[Delimiter=",",Encoding=1252]), | |
#"First Row as Header" = Table.PromoteHeaders(Source), | |
#"Changed Type" = Table.TransformColumnTypes(#"First Row as Header",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Volume", Int64.Type}, {"Adj Close", type number}}) | |
in | |
#"Changed Type" |
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
# Map 1-based optional input ports to variables | |
dataset1 <- maml.mapInputPort(1) # class: data.frame | |
# Sample operation | |
dataset1$AgeGroup <- ifelse(dataset1$Age < 16, "Young", ifelse(dataset1$Age > 60, "Old", "Middle")) | |
# Select data.frame to be sent to the output Dataset port | |
maml.mapOutputPort("dataset1"); |
OlderNewer