powershell-modules's People
Forkers
beachandbytes freeman3389 sechacking jbarcia codeliker r1chchapp3rs amours shiham101 teh30p nbkku7q russelv101 dsbert leighfavell jajp777 c0ns0le opexxx codydude tale-dejan gbkim1988 tardummy01 arryboom dexmay jimbobmcgee danidaraban05 jeisbrener virsystem wilbertvanloon jgigler trendmicrogiss jamal27 binihao5bei noobzero m3crast valexan amtherwi janosberke airtau tyekrgk h1d3r mvkozlov spyccc gooyaweb tenek52 omunroe-com superaswan besimaltnok kslinf aczamata derregenbogen fengtengda ssg-randy-knight bugal stummsft copper3479 bluefoxpl panovski001 liuliu663 alhandra folimpus marciopocebon vladislav-nazarov xeno6696 xazizx84 jcallinan mtrutledge thedwindlingdba sidiqahmed drewcranmer 5l1v3r1 marcioalima bsutradhar mrcarter2959 shantanu561993 rtompsam dcslewis majunyang speedy32129 lamkeysing92 bazagorizont avkrasnov81 rezwan1985 flywithoutwings klamberth27 hasanakgoz sapphiressss nickjrr powershellvb chitfknc zebraroma haarisabbasi azurecloudmonk arraymy alexeysorok lambdaeasy gaydamatar audomaro bahrommurodov sachinshera crbrax22 mateo-sorrochepowershell-modules's Issues
len(varbinary) cuts the smk, use datalength instead
My smk just got cut by the len() function. You have to use datalength() instead in both queries.
valclass=28 and valnum=2 seems to NOT exists
DAC connection to either SQL 2012 or 2016
use master
select * from sys.sysobjvalues
There simply are NO valclass=28 entries
Decoding Credentials
Get the following error:
PS C:\Windows\system32> Get-MSSQLAllCredentials
Exception calling "Close" with "0" argument(s): "Padding is invalid and cannot be removed."
At line:33 char:33
+ { if ($null -ne $Local:BROut) {$BROut.Close()};
+ ~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : CryptographicException
Will see if I can follow manual steps but wont be able to share the value :)
Get-MSSQLCredentialPasswords - Empty result on SQLServer 2008
I came from this post, and Get-MSSQLCredentialPasswords does not return anything.
After I while I found the following query returns empty result:
$SqlCmd = "SELECT name,credential_identity,substring(imageval,5,$ivlen) iv, substring(imageval,$($ivlen+5),len(imageval)-$($ivlen+4)) pass from master.sys.credentials cred inner join master.sys.sysobjvalues obj on cred.credential_id = obj.objid where valclass=28 and valnum=2"
Any ideas? I got no exceptions or errors.
Default database for DAC
If the user you are using for the DAC does not have the default database set to master, the SQL query "SELECT substring(crypt_property,9,len(crypt_property)-8) FROM sys.key_encryptions WHERE key_id=102 and (thumbprint=0x03 or thumbprint=0x0300000001)" returns empty resultset.
Please add catalog name to the from clause: ...FROM master.sys.key_encryptions ...
Script will error out in shared cluster environment.
The script will fail if running on a shared cluster running sql server as FCI. For a shared cluster the computer and cluster names are different.
Invalid pseudocolumn "$ivlen" on SQl Server 2016
running the query “SELECT name,credential_identity…” over a DAC connection
against SQL Server 2016 CU6
Msg 126, Level 15, State 1, Line 2
Invalid pseudocolumn "$ivlen".
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.