Skip to content

Instantly share code, notes, and snippets.

@SQLDBAWithABeard

SQLDBAWithABeard/dbatools.ipynb

Created February 7, 2020 10:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SQLDBAWithABeard/c67b34e555e0e2f979c458a4d423c932 to your computer and use it in GitHub Desktop.
Save SQLDBAWithABeard/c67b34e555e0e2f979c458a4d423c932 to your computer and use it in GitHub Desktop.
Download ZIP
.NET Notebooks
Display the source blob
Display the rendered blob
Raw
dbatools.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# A quick .NET notebook for exploring dbatools\n",
"\n",
"Just to see what works :-)\n",
"\n",
"![First Power Bi](.\\images\\dbatools.png )\n",
"# Setting up the containers for the rest of the dbachecks notebooks\n",
"\n",
"To be able to follow along with the rest of the notebooks, you will need to set up two containers. \n",
"\n",
"This notebook will enable you to do that.\n",
"\n",
"You will need to have Docker installed. The image is based on the SQL Server 2019 image so you will need to have docker set to use Linux Containers. Right click on the Docker icon in the notification area and if it says \"Switch to Linux Containers\" click to switch and wait for Docker to restart. \n",
"\n",
"![Switch To Linux Containers](.\\images\\switchtolinuxcontainers.png )\n",
"\n",
"You will be able to run all of the code in the notebooks by creating the folder, credential and containers in this notebook and then you can click on the play button in each code block to run the code. Note - There are a few code blocks with the results already included which should not be run. They are to show you the results of a command that cannot be run against containers (setting up configuration for domain accounts for example)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Create the folders and the credential\n",
"\n",
"The code below will create a directory called dbachecks-demo in your Documents folder and save a credential file for logging into the containers. You can alter the directory created by altering the $FolderPath but you will have to do this in every notebook."
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre>Creating Directory C:\\Users\\mrrob\\Documents\\dbachecks</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>Path C:\\Users\\mrrob\\Documents\\dbachecks exists already</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>Creating a credential file for the containers - Please don&#39;t do this in production</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>Credential file created</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\n",
"\n",
"########################################################\n",
"Write-Output \"Creating Directory $FolderPath\"\n",
"if(Test-Path $FolderPath){\n",
" Write-Output \"Path $FolderPath exists already\"\n",
"}else {\n",
" New-Item $FolderPath -ItemType Directory\n",
"}\n",
"Write-Output \"Creating a credential file for the containers - Please don't do this in production\"\n",
"\n",
"$sqladminPassword = ConvertTo-SecureString 'dbatools.IO' -AsPlainText -Force \n",
"$cred = New-Object System.Management.Automation.PSCredential ('sqladmin', $sqladminpassword)\n",
"$Cred | Export-Clixml -Path $FolderPath\\sqladmin.cred\n",
"Write-Output \"Credential file created\""
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Containers\n",
"\n",
"We are going to create two SQL 2019 containers using the sqldbawithabeard\\dbachecks [image from the Docker Hub](https://hub.docker.com/repository/docker/sqldbawithabeard/dbachecksdemo). \n",
"\n",
"Please copy the docker-compose.yml file from the folder that the Notebooks are in into the directory that was created above.\n",
"\n",
"The first time it is going to pull the image sqldbawithabeard/dbachecksdemo from the Docker Hub. If you wish to do this first, you can run \n",
"\n",
"`docker pull sqldbawithabeard/dbachecksdemo`"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre>dbachecks_SQL2019_1 is up-to-date</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>dbachecks_SQL2019-1_1 is up-to-date</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\n",
"Set-Location $FolderPath\n",
"docker-compose up -d"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"All being well, you wil have something that looks like\n",
"\n",
"\n",
"![DockerCompose](.\\images\\containers.png )\n",
"\n",
"Now we can start exploring with dbatools :-)\n",
"\n",
"If you have not installed dbatools, it can be got from the PowerShell Gallery using `Install-Module dbatools` the code below will check for the module and either install it in your user profile or update it and Import it"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre>Updating dbatools</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"if(Get-Module dbatools -ListAvailable){\n",
"Write-Output \"Updating dbatools\"\n",
"Update-Module dbatools\n",
"}else {\n",
"Write-Output \"Installing dbatools in your user profile\"\n",
"Install-Module dbatools -Scope CurrentUser\n",
"}\n",
"Import-Module dbatools"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now that is done, we can make a connection to our instances and see if we can connect to them"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [],
"source": [
"$FolderPath = $Env:USERPROFILE + '\\Documents\\dbachecks'\n",
"$SqlInstances = 'localhost,15592','localhost,15593'\n",
"$SqlCredential = Import-Clixml -Path $FolderPath\\sqladmin.cred\n",
"\n",
"$SQL1 = Connect-DbaInstance -SqlInstance $SqlInstances[0] -SqlCredential $SqlCredential\n",
"$SQL2 = Connect-DbaInstance -SqlInstance $SqlInstances[1] -SqlCredential $SqlCredential"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Maybe get the logins on SQL1"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>ComputerName InstanceName SqlInstance Name LoginType CreateDate LastLogin</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>------------ ------------ ----------- ---- --------- ---------- --------- </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 ##MS_PolicyEventProcessingLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 ##MS_PolicyTsqlExecutionLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 akamman SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 alevy SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp1 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp2 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp3 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp4 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp5 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp6 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp7 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp8 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 BUILTIN\\Administrators WindowsGroup 24/09/2019 14:23:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 clemaire SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 csilva SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 fatherjack SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 gsartori SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 jamrtin SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 NT AUTHORITY\\NETWORK SERVICE WindowsUser 21/12/2019 14:33:37 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 NT AUTHORITY\\SYSTEM WindowsUser 21/12/2019 14:33:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 OldSa SqlLogin 08/04/2003 09:10:35 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting1 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting2 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting3 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting4 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 smelton SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 soneill SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 sqladmin SqlLogin 21/12/2019 14:33:50 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support1 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support2 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support3 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support4 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support5 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support6 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 tboggiano SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 thebeard SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 wdurkin SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"Get-Dbalogin -SqlInstance $sql1 | Format-Table"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Of course, you are not limited to just one instance with dbatools. Lets get the databases on all instances"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>ComputerName InstanceName SqlInstance Name Status IsAccessible RecoveryModel LogReuseWaitStatus SizeMB</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>------------ ------------ ----------- ---- ------ ------------ ------------- ------------------ ------</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 master Normal True Simple Nothing 8.5625</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 tempdb Normal True Simple Nothing 40</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 model Normal True Full Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 msdb Normal True Simple 13 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 AdventureWorks2017 Normal True Simple Nothing 336</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 WideWorldImporters Normal True Simple Nothing …140625</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Northwind Normal True Simple Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 pubs Normal True Simple Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 master Normal True Simple Nothing 8.5625</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 tempdb Normal True Simple Nothing 40</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 model Normal True Full Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 msdb Normal True Simple 13 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 AdventureWorks2017 Normal True Simple Nothing 336</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 WideWorldImporters Normal True Simple Nothing …140625</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Northwind Normal True Simple Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 pubs Normal True Simple Nothing 16</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"Get-DbaDatabase -SqlInstance $SQL1 , $SQL2 | Format-Table"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"or maybe all of the logins"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>ComputerName InstanceName SqlInstance Name LoginType CreateDate LastLogin</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>------------ ------------ ----------- ---- --------- ---------- --------- </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 ##MS_PolicyEventProcessingLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 ##MS_PolicyTsqlExecutionLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 akamman SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 alevy SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp1 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp2 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp3 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp4 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp5 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp6 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp7 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 beardapp8 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 BUILTIN\\Administrators WindowsGroup 24/09/2019 14:23:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 clemaire SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 csilva SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 fatherjack SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 gsartori SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 jamrtin SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 NT AUTHORITY\\NETWORK SERVICE WindowsUser 21/12/2019 14:33:37 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 NT AUTHORITY\\SYSTEM WindowsUser 21/12/2019 14:33:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting1 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting2 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting3 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Reporting4 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 smelton SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 soneill SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 sqladmin SqlLogin 21/12/2019 14:33:50 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support1 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support2 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support3 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support4 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support5 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 Support6 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 tboggiano SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 thebeard SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER f348131a8cc0 wdurkin SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 ##MS_PolicyEventProcessingLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 ##MS_PolicyTsqlExecutionLogin## SqlLogin 24/09/2019 14:21:53 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 akamman SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 alevy SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp1 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp2 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp3 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp4 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp5 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp6 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp7 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 beardapp8 SqlLogin 21/12/2019 14:34:00 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 BUILTIN\\Administrators WindowsGroup 24/09/2019 14:23:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 clemaire SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 csilva SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 fatherjack SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 gsartori SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 jamrtin SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 NT AUTHORITY\\NETWORK SERVICE WindowsUser 21/12/2019 14:33:37 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 NT AUTHORITY\\SYSTEM WindowsUser 21/12/2019 14:33:37 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Reporting1 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Reporting2 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Reporting3 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Reporting4 SqlLogin 21/12/2019 14:34:02 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 smelton SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 soneill SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 sqladmin SqlLogin 21/12/2019 14:33:50 07/02/2020 …</pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support1 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support2 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support3 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support4 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support5 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 Support6 SqlLogin 21/12/2019 14:34:01 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 tboggiano SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 thebeard SqlLogin 21/12/2019 14:33:59 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre>localhost MSSQLSERVER e4053cd3e5f8 wdurkin SqlLogin 21/12/2019 14:33:58 </pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<pre></pre>\r\n"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"Get-DbaLogin -SqlInstance $SQL1 , $SQL2 -ExcludeSystemLogin | Format-Table"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": ".NET (PowerShell)",
"language": "PowerShell",
"name": ".net-powershell"
},
"language_info": {
"file_extension": ".ps1",
"mimetype": "text/x-powershell",
"name": "PowerShell",
"pygments_lexer": "powershell",
"version": "7.0"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment