Kraken

1.0.4

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 1.0.4

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

Install-PSResource -Name Kraken -Version 1.0.4

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\08\157f367a90a30bbd18ec09b6fa1ae95c05916f
  • .git\objects\08\654c03bf167ea4a30c73748232bce241dbc35d
  • .git\objects\09\43cf7c1c4a71b40cacfe5c75cb089fe3b59eb1
  • .git\objects\0b\36bff286822297d9e1cddd29391472f9560cf0
  • .git\objects\0b\94b03bed73d235196515c1a142e2c9d6724919
  • .git\objects\12\5da7417f410d3150442571318b2992c02c282e
  • .git\objects\15\37a944b50213b65da56927ebeadd0f13f4cd0b
  • .git\objects\16\5e6a689d586db0d005bca126b28921dcc6ec7d
  • .git\objects\18\a4cb19db85df8c512344a42e152dec6dd39ea8
  • .git\objects\1c\2c334d828936b0e137ad8883b5a736bdebfc8f
  • .git\objects\21\b574ef0d709087c026267109ccdb491320761d
  • .git\objects\22\a7383568806b25c658f3e1da22920bfebddf45
  • .git\objects\23\33c1afbf8ece6ea4476dd2191a15256bf06622
  • .git\objects\24\15f6e830421ac8ea388864372590df83e7413b
  • .git\objects\24\ee1ac115c0db8a75e0a3ed2668116fc23ea27c
  • .git\objects\25\4b244b0c38cef7b8f9d5dd506eaf46b7764973
  • .git\objects\2b\b4cd61cee4b126dc8781fa699b02c2a2ee32cd
  • .git\objects\2c\3336f2188ad96bc1b9b0ed69d0b67378fc9540
  • .git\objects\2c\3afd6e00ff17a5d8a30b11002b0c584be2c286
  • .git\objects\2d\091cc8a95b4789a8d05301121c4fe81da809df
  • .git\objects\2d\f18a399cb5108800d2a20b792dc90a270edfca
  • .git\objects\31\e3cb8f33c60cc8a6fa921b5db9d4c176926bab
  • .git\objects\33\34e9f82aaa183d2af72056b7e44852bd785b0f
  • .git\objects\33\8503428b2e9abb2ac4bc38c7ce809bca05d8ca
  • .git\objects\36\6dc36ca2c0bbd5197b7fcf762dcad779fb3274
  • .git\objects\37\e1ca6cdf5c66e6076941e0babaf34106aa8449
  • .git\objects\39\a4c8600be072cd2224239720b5525177e2fc5a
  • .git\objects\3a\176737b35f3ef5f1666799848b479dae6ec42c
  • .git\objects\3c\9ef46f48cfa55c1ee185bb61d5a241be8e582b
  • .git\objects\3d\81e22c5532ad34b0781ace1583086e522e789f
  • .git\objects\3d\acc5ba628f7c69e91f0196851836cfd29116d1
  • .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\0aa0224062dff43f2bd9c2efb4e87312696079
  • .git\objects\50\7e90a78a811c3addcca8d873363c8c330a99d9
  • .git\objects\52\8e9ac354a0f542be627ef687f530ba07b96124
  • .git\objects\53\b4137246744a77e278a4ef1f4006aa066ddf44
  • .git\objects\55\1424eb65e3a6e2a43cfa99c1af0ad605d51499
  • .git\objects\55\5d8dcdfa412835438728b1dd360f118b37f758
  • .git\objects\55\c560b7d116adbd29639c95c4c49593d298882b
  • .git\objects\56\95e0181f77fe4c55fe20e468e68e2460e6714e
  • .git\objects\56\97b2dcfe946908f111031e0ec718b6efdd615e
  • .git\objects\56\f1d4b7d6824cf7c0b3c0e2050cccb534b8d413
  • .git\objects\57\7db1c691144a3468b0ddbd275f4338039352c1
  • .git\objects\57\8f04613e7dd73df3b72e230a5fbcc72a606108
  • .git\objects\59\b9f6b727eab143d7bc7cfaf7a648e9dca8208c
  • .git\objects\5a\8b39a74529d06fb629545ccb9d1ad75048aef5
  • .git\objects\5b\81b1fab34cb8cd22996a4339237845ebebf031
  • .git\objects\5b\c3b28b266e8d9ac2027b03d4cae45ade233c5a
  • .git\objects\5d\b0463bf2c45f0eefca86df7786b1bb989c9e92
  • .git\objects\5f\961435835d06bd69a38557f3b9519fc6ff6372
  • .git\objects\63\aaea3600558a5fec44b6f11f37e1fd26c1226c
  • .git\objects\65\e6a33f5d2505f0cd2789fd929a8b42757c4450
  • .git\objects\66\54b584973c4db2b68b554134c602f3d0ae2d67
  • .git\objects\66\ce142585894617a6257cc81e3e474574e0bffa
  • .git\objects\66\db82264579724af6a28143ef0daae82da30669
  • .git\objects\67\e792b9aa307bd509ad70c49b0c38c606b58af2
  • .git\objects\69\9f52764d9148394d4dde6a6d586323573db38e
  • .git\objects\6e\1725be27c0b233f5b3d2d155634382d2827dcd
  • .git\objects\6e\8d882d84bf54abbfaed8c28427af3b6431e5b8
  • .git\objects\6f\9077c91ebdb2a0fe98bba79327dce534537e4a
  • .git\objects\6f\eb37aa2e3a1971147e1bd7e89dd587ba696597
  • .git\objects\6f\f6fe5d45a57161250f0d1be6b584d10fe731da
  • .git\objects\75\29e1650848b19355159af4dc50c01697c7d022
  • .git\objects\75\eecee5fda8e601ce1e9a755170f925be53be5a
  • .git\objects\75\f0c4f1a1804cdc9ca7c96ba7ab2ef7fb90d509
  • .git\objects\76\3fea2fba55a4e6d2f15960129affdd4bb6a0dd
  • .git\objects\76\e7d4f77cd4ec1a0c9a7db6537e9153775b07de
  • .git\objects\78\5886b26dfe071d7d66361a8d6823ef7b120c88
  • .git\objects\7a\03c5045a09143e54266b8bc418e354309fe410
  • .git\objects\7a\e8434121ae372d63187e38d6f178a1aa304eda
  • .git\objects\7e\a785af79087fb4d9c00be2fccb7fb4ecb7ef3d
  • .git\objects\7f\243041819b23f9c012dd3b72019ef7455361e5
  • .git\objects\80\1d3770eb2133eedef8731051792af72f444673
  • .git\objects\82\c9fa4bfa67c4e3a0d72e67ce0e7c186d729691
  • .git\objects\83\43b7ab25f2d0ace6436369ca8a878cc26b220e
  • .git\objects\83\679a018ea695e5f26c2237be793c321d4087af
  • .git\objects\84\f9f03a59c8f5fdf98e86d5f49cc5c400988af3
  • .git\objects\86\99c0ebcdea9e44723d5a683662b06788461f8c
  • .git\objects\86\adc1028e3e4ba9df55f14feb017c2d70180f1c
  • .git\objects\86\be83a8a82c253a9c0a2836ecf326cafd41d313
  • .git\objects\87\015f5230f44b60a48ad410a7cce85660227e4d
  • .git\objects\87\a87ecd0814688051f2f453c25e5dd240819597
  • .git\objects\88\30bd3775ce78a5b8381d4ec556203fd822879a
  • .git\objects\89\908f0333770c01bd33fc2f2f37c119869b91cb
  • .git\objects\8a\409ae95382e1d9036d873fa23e000ba0fa5ae0
  • .git\objects\8c\33d745b0546fe21c93e073f64328ea841cada1
  • .git\objects\8c\6d337b13c2dac3a5fbec8509b1fd0cc1fd0b76
  • .git\objects\8d\ff72817d9d4593f8afc6825821a93c1f2afd3f
  • .git\objects\8e\96e21d81f1989c2587323a6568afe54b1c3417
  • .git\objects\8e\b925296d8463db4ed7b66ced4725092c3d1b39
  • .git\objects\92\ad646cdb9c97a2c0c807081945773ef14f837b
  • .git\objects\93\4d83900b802f86ace1875bcf36b917eeec1f4f
  • .git\objects\94\299435618b4afd811e906d38584e8bf32f8877
  • .git\objects\94\3e2ae10c3d38d42a75d97692f9bc6b10a0ebcf
  • .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\99\711872d03735fcd66a4de94998dc8074f42aac
  • .git\objects\9d\b1421926e67394e5af2e19698bc6eb37252ed9
  • .git\objects\9e\213b1b5f9c23145d5155566e2bcec25420d547
  • .git\objects\9e\80107919a6e2ab759a00eb12e48876663727ba
  • .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\a6\18c354e42c91eb3b81921fc5c3527f95eb4225
  • .git\objects\a6\dc415504764b105364b31e07df544151a24a31
  • .git\objects\a9\e0797317760d864c301f83dd055f0fc2a1592f
  • .git\objects\aa\ae2b6b6112fe9c4e3f518c827bb99302261d17
  • .git\objects\ab\9978285059c92bae92433e16fc780d6e809e24
  • .git\objects\ac\a27e5e855334b23b82999a9b4b4ffa983fa1f2
  • .git\objects\b0\9e755e4a6e22dcef407d699fedc162adf42153
  • .git\objects\b2\ff1683e371c40aaeca07ca05ffd893792c2232
  • .git\objects\b5\45aa02946f7580625e69146b75fc398b1483e8
  • .git\objects\b5\cc137403cd38ef52f0bab05d149cf78e407de0
  • .git\objects\b5\dace6f7c389acc9ba4e30bc4fe5177ad00cec9
  • .git\objects\b6\2a41381c9b075b3c6c87be87deb69d7c293a9f
  • .git\objects\ba\178d4a49115a98b3373156d4aea0f5d17dc595
  • .git\objects\ba\665e198375c9e89db5186ee12f4cf182e73e8e
  • .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\c7\f6878ffd9840e41cae714a18ec2004cac2ce04
  • .git\objects\cb\beca38b8c180da8beef3a959082c6acc95596e
  • .git\objects\cd\44cee5deef6076e2931c4bedf453fb082e2dd3
  • .git\objects\d0\be1f9b5fb56e84451c2db082bbf4ca6b3fa3db
  • .git\objects\d2\e9e6d2d265f36d37b33520af51e0606c955386
  • .git\objects\d6\714751dee06342a96a788526c042781b9b7c63
  • .git\objects\da\8365cc9bb5ebe2f97d6b17094e1663d882a8a0
  • .git\objects\de\c8af60d6dc84685b426422d96d13c870035052
  • .git\objects\df\e0770424b2a19faf507a501ebfc23be8f54e7b
  • .git\objects\e0\833a8c14f9b1e881aa97febc108613b68a5056
  • .git\objects\e2\b37c80cb1df676c341f61e803f73f4bd96683c
  • .git\objects\e6\936c6942ad45e08fd7d205427ec29d76b9b55f
  • .git\objects\e7\393eb886e947819a4edeb9cdd05108aa246b8f
  • .git\objects\e7\557fe58566c5e102141ae7d35b6c960c15504a
  • .git\objects\e8\7836c702e922760b7d0612e1b2a97b6f27ed94
  • .git\objects\ee\cb19b6331e12df934edd83e28c08a3d3fbb0b5
  • .git\objects\ef\39f3e8827c20ff1a5f86ed3e894f1ec9463a15
  • .git\objects\ef\ff67034a78795f9ab732a8396aed852f33f189
  • .git\objects\f1\c81831334065b8e3a9ff3a5078321e287b3800
  • .git\objects\f2\36b1e024e0c745efbcc30f410049cc7299805a
  • .git\objects\f3\206568897633c28d7a122843df21492e3ce965
  • .git\objects\f3\273541d33e5afe74c63e5ce308d6e620515902
  • .git\objects\f7\a7cca1b294c041b569c4b582da4b816e4b90c2
  • .git\objects\f7\fcf2dc9c4157c9ab54f2329ee91b462600d53d
  • .git\objects\f8\7b45aa5921bfa12c3ebc99db180fecdc7329a7
  • .git\objects\f9\7b68516bf41ceb800005e510bddb6b57a28805
  • .git\objects\f9\9174ac6522d4c5da2dd557bf3d458d33eabe97
  • .git\objects\fa\54d1f28469ac6cfaaa57245f9caf8f8f5776cb
  • .git\objects\fb\da6a9768da64d87d7849a8cf1c06ca8dbf3b27
  • .git\objects\fd\092f62adc4b1e2c9ca681fcae26732e17e6062
  • .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\Write-WrappedSqlTableData.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 59 5/4/2023
1.0.16 20 3/16/2023
1.0.15 23 12/5/2022
1.0.14 32 5/12/2022
1.0.13 140 8/11/2021
1.0.12 20 8/5/2021
1.0.11 23 7/27/2021
1.0.10 48 2/24/2021
1.0.9 19 2/23/2021
1.0.8 30 9/25/2020
1.0.7 22 8/28/2020
1.0.6 15 8/27/2020
1.0.5 16 8/27/2020
1.0.4 (current version) 16 8/10/2020
1.0.3 16 8/6/2020
1.0.2 20 8/4/2020
1.0.1 16 8/3/2020
1.0.0 18 8/3/2020
0.2 18 7/31/2020
0.1 19 7/30/2020
Show less