#Gist This page includes notes about the installation and setup of Office Online Server
CONTOSO-DEV-SQL2
- Remove DEV-SQL2 from the DEV Farm through Central Admin.
{ | |
"$schema": "https://coriolis.io/schemas/ship-loadout/4.json#", | |
"name": "Alliance Chieftan 1", | |
"ship": "Alliance Chieftain", | |
"references": [ | |
{ | |
"name": "Coriolis.io", | |
"url": "https://coriolis.io/outfit/alliance_chieftain?code=A0potoFjlodtsjf47l7l1b1010100204030m044exB3x3w2bm7--.Iw1%2FADBZA%3D%3D%3D.AwRgTBoSLH8McIA%3D.H4sIAAAAAAAAA2P%2BJ8XAwPCXCUjwr%2Fj7%2F7%2FQHVYGBhF7dgYGiQig4H%2BOf8EwedYqFgYGtg%2B%2F%2Fv%2BX%2BPz7%2F3%2Flivf%2FgYCBAQCjsfn4QwAAAA%3D%3D&bn=Alliance%20Chieftan%201", | |
"code": "A0potoFjlodtsjf47l7l1b1010100204030m044exB3x3w2bm7--.Iw1/ADBZA===.AwRgTBoSLH8McIA=.H4sIAAAAAAAAA2P+J8XAwPCXCUjwr/j7/7/QHVYGBhF7dgYGiQig4H+Of8EwedYqFgYGtg+//v+X+Pz7/3/livf/gYCBAQCjsfn4QwAAAA==", | |
"shipId": "alliance_chieftain" |
{ | |
"$schema": "https://coriolis.io/schemas/ship-loadout/4.json#", | |
"name": "Mamba", | |
"ship": "Mamba", | |
"references": [ | |
{ | |
"name": "Coriolis.io", | |
"url": "https://coriolis.io/outfit/mamba?code=A0pothFaljdqsjf3-0v0v1717-----020349012i3x3w.Iw18WQ%3D%3D.AwRgTGzBW%2B60cIA%3D.H4sIAAAAAAAAA2P%2BJ8nAwPCXCUgwLvn0%2Fz%2F%2Fir%2F%2F%2F4t4APnKCswMDP%2F%2FMwAAYdl8DyIAAAA%3D&bn=Mamba", | |
"code": "A0pothFaljdqsjf3-0v0v1717-----020349012i3x3w.Iw18WQ==.AwRgTGzBW+60cIA=.H4sIAAAAAAAAA2P+J8nAwPCXCUgwLvn0/z//ir///4t4APnKCswMDP//MwAAYdl8DyIAAAA=", | |
"shipId": "mamba" |
{ | |
"$schema": "https://coriolis.io/schemas/ship-loadout/4.json#", | |
"name": "Aspblaster9000", | |
"ship": "Asp Explorer", | |
"references": [ | |
{ | |
"name": "Coriolis.io", | |
"url": "https://coriolis.io/outfit/asp?code=A0pitjFfljdgsof5------Snxs-020537v60k403x2i3w.IzAMIys8KA%3D%3D.AwRjwyLAmBmEMRUkA%3D%3D%3D.H4sIAAAAAAAAA2P6J8HAwPCXCUj8KQMS%2FAX%2F%2Fv8XARGiIqwMDBITGBkYlD2%2B%2FP%2F%2Fn%2FmfFEwl%2F4q%2F%2F%2F8L3QHKixzhBCqKAAr%2BZ%2FuXCJIHqmcQusDOwKAn8ef%2Ff0kVZqCUxL9YkBQrSEpAnYHBtEMYKPofyGUAAKOMp4yAAAAA&bn=Aspblaster9000", | |
"code": "A0pitjFfljdgsof5------Snxs-020537v60k403x2i3w.IzAMIys8KA==.AwRjwyLAmBmEMRUkA===.H4sIAAAAAAAAA2P6J8HAwPCXCUj8KQMS/AX//v8XARGiIqwMDBITGBkYlD2+/P//n/mfFEwl/4q///8L3QHKixzhBCqKAAr+Z/uXCJIHqmcQusDOwKAn8ef/f0kVZqCUxL9YkBQrSEpAnYHBtEMYKPofyGUAAKOMp4yAAAAA", | |
"shipId": "asp" |
ID | Parent | ||||||
---|---|---|---|---|---|---|---|
EJXYVVPGMKJMKYUK | |||||||
IBPDEOFAMMPEQXCY | EJXYVVPGMKJMKYUK | ||||||
BZENSGDSKZOTKMKA | IBPDEOFAMMPEQXCY | ||||||
FADPHYHRHCPQRLQA | |||||||
JCKGBXNGKXNWDQOE | FADPHYHRHCPQRLQA | ||||||
LDTHJBETLOMGIYSQ | FADPHYHRHCPQRLQA | ||||||
DOLYLNQVEUPBRYZE | LDTHJBETLOMGIYSQ | ||||||
LNTOQJQUFCSMYCKW | |||||||
VYRFVSWBMOAIRKCQ | LNTOQJQUFCSMYCKW |
Function Get-ParentRows { | |
<# | |
.SYNOPSIS | |
Returns rows that have no Parent ID and where Comments is not blank | |
#> | |
[CmdletBinding()] | |
param ( | |
[Parameter(Mandatory = $true, ValueFromPipeline = $true)] | |
[Array]$CSVData |
{\rtf1\ansi \deff4\deflang1033{\fonttbl{\f4\froman\fcharset0\fprq2 Times New Roman;}{\f5\fswiss\fcharset0\fprq2 Arial;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0; | |
\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128; | |
\red192\green192\blue192;}{\stylesheet{\widctlpar \f4\fs20 \snext0 Normal;}{\*\cs10 \additive Default Paragraph Font;}}{\info{\author Kotus}{\operator SEWP 3.0 Development}{\creatim\yr1998\mo8\dy30\hr23\min30}{\revtim\yr1998\mo12\dy18\hr13\min13} | |
{\version2}{\edmins104}{\nofpages18}{\nofwords4155}{\nofchars23686}{\*\company }{\vern57443}}\paperw11909\paperh16834\margl1080\margr1080\margt1080\margb1080 \widowctrl\ftnbj\aenddoc\hyphcaps0 \fet0\sectd \linex0\headery706\footery706\colsx709 | |
{\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\p |
USE AWDataWarehouse | |
GO | |
-- Create DimDate dimension table | |
CREATE TABLE [dbo].[DimDate]( | |
[DateKey] [int] NOT NULL PRIMARY KEY NONCLUSTERED, | |
[FullDateAlternateKey] [date] NOT NULL, | |
[DayNumberOfWeek] [tinyint] NOT NULL, | |
[DayNameOfWeek] [nvarchar](10) NOT NULL, | |
[DayNumberOfMonth] [tinyint] NOT NULL, |
USE AWDataWarehouse | |
GO | |
-- Populate DimDate dimension table with values from 1/1/2000 to 1/1/2003 | |
-- declare variables to hold the start and end date | |
DECLARE @StartDate datetime | |
DECLARE @EndDate datetime | |
--- assign values to the start date and end date we | |
-- want our reports to cover (this should also take |