Kraken

0.2

Kraken is a PowerShell Module which collects useful sql server metadata information for auditing and reporting purposes. It executes a series of lightweight, non-intrusive sql server queries and stores the information in your repository database. It is backward compatible down to SQL Server 2008 R2

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name Kraken -RequiredVersion 0.2

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name Kraken -Version 0.2

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) Daniel Berber. All rights reserved.

Package Details

Author(s)

  • Daniel Berber

Tags

PSInsight REST

Dependencies

FileList

  • Kraken.nuspec
  • Kraken.config.json
  • Kraken.psd1
  • Kraken.psm1
  • LICENSE
  • README.md
  • .git\COMMIT_EDITMSG
  • .git\config
  • .git\description
  • .git\FETCH_HEAD
  • .git\HEAD
  • .git\index
  • .git\ORIG_HEAD
  • .git\hooks\applypatch-msg.sample
  • .git\hooks\commit-msg.sample
  • .git\hooks\fsmonitor-watchman.sample
  • .git\hooks\post-update.sample
  • .git\hooks\pre-applypatch.sample
  • .git\hooks\pre-commit.sample
  • .git\hooks\pre-push.sample
  • .git\hooks\pre-rebase.sample
  • .git\hooks\pre-receive.sample
  • .git\hooks\prepare-commit-msg.sample
  • .git\hooks\update.sample
  • .git\info\exclude
  • .git\logs\HEAD
  • .git\logs\refs\heads\master
  • .git\logs\refs\remotes\origin\master
  • .git\objects\02\f690ffd91efb4727e6f763d5dfd0be933d1119
  • .git\objects\05\7dcb00dcc397574ca4e7b3d6b66abfc3c28d05
  • .git\objects\07\79dce2fb8e75bcdc8918aebc9fde98e4c8f87d
  • .git\objects\09\43cf7c1c4a71b40cacfe5c75cb089fe3b59eb1
  • .git\objects\0b\94b03bed73d235196515c1a142e2c9d6724919
  • .git\objects\12\5da7417f410d3150442571318b2992c02c282e
  • .git\objects\16\5e6a689d586db0d005bca126b28921dcc6ec7d
  • .git\objects\21\b574ef0d709087c026267109ccdb491320761d
  • .git\objects\22\a7383568806b25c658f3e1da22920bfebddf45
  • .git\objects\23\33c1afbf8ece6ea4476dd2191a15256bf06622
  • .git\objects\24\15f6e830421ac8ea388864372590df83e7413b
  • .git\objects\25\4b244b0c38cef7b8f9d5dd506eaf46b7764973
  • .git\objects\2b\b4cd61cee4b126dc8781fa699b02c2a2ee32cd
  • .git\objects\2c\3336f2188ad96bc1b9b0ed69d0b67378fc9540
  • .git\objects\2c\3afd6e00ff17a5d8a30b11002b0c584be2c286
  • .git\objects\2d\f18a399cb5108800d2a20b792dc90a270edfca
  • .git\objects\33\8503428b2e9abb2ac4bc38c7ce809bca05d8ca
  • .git\objects\36\6dc36ca2c0bbd5197b7fcf762dcad779fb3274
  • .git\objects\37\e1ca6cdf5c66e6076941e0babaf34106aa8449
  • .git\objects\3a\176737b35f3ef5f1666799848b479dae6ec42c
  • .git\objects\3c\9ef46f48cfa55c1ee185bb61d5a241be8e582b
  • .git\objects\40\575cc56fb80bfacfa7946588f229b4b1a62258
  • .git\objects\41\054cfe7952733c5c871ad6e6e8898321122d57
  • .git\objects\45\c3632878d642ae15f5a50910984e262c08d36f
  • .git\objects\47\1dfde6fd931e577d05600db0fabbcaa3f23df0
  • .git\objects\48\a1f962a4603e338f09a98f4b7568893dc3dda2
  • .git\objects\4e\b3700480997f870d9d3fdc76422c8250699b0b
  • .git\objects\50\7e90a78a811c3addcca8d873363c8c330a99d9
  • .git\objects\52\8e9ac354a0f542be627ef687f530ba07b96124
  • .git\objects\53\b4137246744a77e278a4ef1f4006aa066ddf44
  • .git\objects\56\95e0181f77fe4c55fe20e468e68e2460e6714e
  • .git\objects\56\97b2dcfe946908f111031e0ec718b6efdd615e
  • .git\objects\57\7db1c691144a3468b0ddbd275f4338039352c1
  • .git\objects\59\b9f6b727eab143d7bc7cfaf7a648e9dca8208c
  • .git\objects\5b\81b1fab34cb8cd22996a4339237845ebebf031
  • .git\objects\63\aaea3600558a5fec44b6f11f37e1fd26c1226c
  • .git\objects\66\54b584973c4db2b68b554134c602f3d0ae2d67
  • .git\objects\67\e792b9aa307bd509ad70c49b0c38c606b58af2
  • .git\objects\69\9f52764d9148394d4dde6a6d586323573db38e
  • .git\objects\6e\8d882d84bf54abbfaed8c28427af3b6431e5b8
  • .git\objects\6f\9077c91ebdb2a0fe98bba79327dce534537e4a
  • .git\objects\6f\f6fe5d45a57161250f0d1be6b584d10fe731da
  • .git\objects\75\f0c4f1a1804cdc9ca7c96ba7ab2ef7fb90d509
  • .git\objects\76\3fea2fba55a4e6d2f15960129affdd4bb6a0dd
  • .git\objects\78\5886b26dfe071d7d66361a8d6823ef7b120c88
  • .git\objects\7a\03c5045a09143e54266b8bc418e354309fe410
  • .git\objects\7a\e8434121ae372d63187e38d6f178a1aa304eda
  • .git\objects\80\1d3770eb2133eedef8731051792af72f444673
  • .git\objects\83\43b7ab25f2d0ace6436369ca8a878cc26b220e
  • .git\objects\83\679a018ea695e5f26c2237be793c321d4087af
  • .git\objects\86\adc1028e3e4ba9df55f14feb017c2d70180f1c
  • .git\objects\86\be83a8a82c253a9c0a2836ecf326cafd41d313
  • .git\objects\87\a87ecd0814688051f2f453c25e5dd240819597
  • .git\objects\88\30bd3775ce78a5b8381d4ec556203fd822879a
  • .git\objects\8a\409ae95382e1d9036d873fa23e000ba0fa5ae0
  • .git\objects\8e\b925296d8463db4ed7b66ced4725092c3d1b39
  • .git\objects\93\4d83900b802f86ace1875bcf36b917eeec1f4f
  • .git\objects\94\299435618b4afd811e906d38584e8bf32f8877
  • .git\objects\94\83932f4093b6ef808a11fd116451fbdabc2935
  • .git\objects\94\8ecac534192cb7d7bf05780bc4728895924fbb
  • .git\objects\95\1c59620a88a64adf6f5ad919375829d3c43093
  • .git\objects\96\266b01dbdcbe727128fcc117aff40bb4fa33d1
  • .git\objects\96\cf35f837cd03e5f92fc499b86be98a4f148108
  • .git\objects\97\baa7af7b8889bfa37ae330fdcc21a3cec8f20a
  • .git\objects\97\babbb7011a962ea4e361662ac5c1adf3247e03
  • .git\objects\9f\de1655ad26b17582dab492caf8987403eca0ba
  • .git\objects\a0\ac377f9681823b723a86e30626f5c6b68026b8
  • .git\objects\a1\77e171f264a2c1702fcc1ecf6f55d58ed2aff8
  • .git\objects\a2\8cf7b5119ab62a96771fd66600c002d6485d93
  • .git\objects\a3\fca301d3cbe33e93dcbc9bf313a0c778e6a159
  • .git\objects\a4\11928c4d75beaf58c5c8e4b23a95cb56392835
  • .git\objects\a4\9bdaf65fd9ce3c1f6cd5beb8069d454b70caf7
  • .git\objects\a4\f895dbece638a1b317dd7c4b382e5212dbbebc
  • .git\objects\b5\45aa02946f7580625e69146b75fc398b1483e8
  • .git\objects\b5\cc137403cd38ef52f0bab05d149cf78e407de0
  • .git\objects\b5\dace6f7c389acc9ba4e30bc4fe5177ad00cec9
  • .git\objects\ba\b88f9269abc36617e5238d77c55b7aef738259
  • .git\objects\bc\6a274cb7f207c6af5e9027dc931bedd155722a
  • .git\objects\bd\6ac6638bced4a925dcc47299c8d4496a5d5ae4
  • .git\objects\c4\c29939b3fed1735fc3ca2ddeadc77d5221beb5
  • .git\objects\c5\2d65470d6b31cfdd1c8b82aa7332d68f69135b
  • .git\objects\c5\a5955596ac7c334bfb8fd6e5e79ac14fff9235
  • .git\objects\d0\be1f9b5fb56e84451c2db082bbf4ca6b3fa3db
  • .git\objects\d2\e9e6d2d265f36d37b33520af51e0606c955386
  • .git\objects\d6\714751dee06342a96a788526c042781b9b7c63
  • .git\objects\da\8365cc9bb5ebe2f97d6b17094e1663d882a8a0
  • .git\objects\df\e0770424b2a19faf507a501ebfc23be8f54e7b
  • .git\objects\e2\b37c80cb1df676c341f61e803f73f4bd96683c
  • .git\objects\e7\393eb886e947819a4edeb9cdd05108aa246b8f
  • .git\objects\e8\7836c702e922760b7d0612e1b2a97b6f27ed94
  • .git\objects\ee\cb19b6331e12df934edd83e28c08a3d3fbb0b5
  • .git\objects\ef\ff67034a78795f9ab732a8396aed852f33f189
  • .git\objects\f3\273541d33e5afe74c63e5ce308d6e620515902
  • .git\objects\f7\a7cca1b294c041b569c4b582da4b816e4b90c2
  • .git\objects\f8\7b45aa5921bfa12c3ebc99db180fecdc7329a7
  • .git\objects\f9\9174ac6522d4c5da2dd557bf3d458d33eabe97
  • .git\objects\fb\da6a9768da64d87d7849a8cf1c06ca8dbf3b27
  • .git\objects\fd\1fe1bfef6aeaabc48d9e5f2158efc5fb763ebd
  • .git\objects\fe\d8a591b0d2c352ed32e51800ff0c7589c8385d
  • .git\objects\fe\dc148191a80501743386dd98d78b340f41ea0b
  • .git\refs\heads\master
  • .git\refs\remotes\origin\master
  • .vscode\launch.json
  • Private\Get-ConnectionString.ps1
  • Private\Get-Job.ps1
  • Private\Get-SQLInstance.ps1
  • Private\Invoke-SqlCmd2.ps1
  • Private\Update-RunCount.ps1
  • Private\Write-JobMessage.ps1
  • Private\SQLScripts\Get-AGDatabases.sql
  • Private\SQLScripts\Get-AvailabilityGroups.sql
  • Private\SQLScripts\Get-AvailabilityReplicas.sql
  • Private\SQLScripts\Get-Backups.sql
  • Private\SQLScripts\Get-ConnDetails.sql
  • Private\SQLScripts\Get-DatabaseFiles.sql
  • Private\SQLScripts\Get-Databases.sql
  • Private\SQLScripts\Get-DatabaseSize.sql
  • Private\SQLScripts\Get-Hadr_Cluster.sql
  • Private\SQLScripts\Get-Hadr_Cluster_Members.sql
  • Private\SQLScripts\Get-Hadr_Cluster_Networks.sql
  • Private\SQLScripts\Get-Job.sql
  • Private\SQLScripts\Get-ListenerInfo.sql
  • Private\SQLScripts\Get-OSInfo.sql
  • Private\SQLScripts\Get-Registry.sql
  • Private\SQLScripts\Get-ServerProperties.sql
  • Private\SQLScripts\Get-Server_Role_Membership.sql
  • Private\SQLScripts\Get-SQLInstance.sql
  • Private\SQLScripts\Get-SQL_Logins.sql
  • Private\SQLScripts\Get-SysConfigurations.sql
  • Private\SQLScripts\Get-Volumes.sql
  • Private\SQLScripts\Set-DBSchema.sql
  • Private\SQLScripts\Update-RunCount.sql
  • Public\Invoke-TheKraken.ps1
  • Public\Set-DBSchema.ps1
  • Public\Set-DBSettings.ps1

Version History

Version Downloads Last updated
1.0.17 41 5/4/2023
1.0.16 17 3/16/2023
1.0.15 20 12/5/2022
1.0.14 29 5/12/2022
1.0.13 137 8/11/2021
1.0.12 17 8/5/2021
1.0.11 20 7/27/2021
1.0.10 45 2/24/2021
1.0.9 16 2/23/2021
1.0.8 27 9/25/2020
1.0.7 19 8/28/2020
1.0.6 12 8/27/2020
1.0.5 13 8/27/2020
1.0.4 13 8/10/2020
1.0.3 13 8/6/2020
1.0.2 17 8/4/2020
1.0.1 13 8/3/2020
1.0.0 15 8/3/2020
0.2 (current version) 15 7/31/2020
0.1 16 7/30/2020
Show less