PowerShell Script SSN and CC

Question

I am looking for a PowerShell script that will search mapped drives for files that contain CC and SSN info.

Answer 1

Hello there,

Found this script online and might be useful for you,

Install-Module PSExcel
Import-Module PSExcel

$cardRegex = "(^4[0-9]{12}(?:[0-9]{3})?$)|(^(?:5[1-5][0-9]{2}|222[1-9]|22[3-9][0-9]|2[3-6][0-9]{2}|27[01][0-9]|2720)[0-9]{12}$)|(3[47][0-9]{13})|(^3(?:0[0-5]|[68][0-9])[0-9]{11}$)|(^6(?:011|5[0-9]{2})[0-9]{12}$)|(^(?:2131|1800|35\d{3})\d{11}$)"

Get-ChildItem -Recurse -File "*.xlsx" | ForEach-Object {Search-CellValue -Path $.FullName -FilterScript {if($ -match "-"){$.replace("-","") -match $cardRegex}else{$ -match $cardRegex}}}

I hope this information helps. If you have any questions please let me know and I will be glad to help you out.

-----------------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept it as an answer--

Answer 2

Hi @Stephen Ruberti

You can use this guide to search for CC and SSN info (inside of files):

Use an Easy PowerShell Command to Search Files for Information

https://devblogs.microsoft.com/scripting/use-an-easy-powershell-command-to-search-files-for-information/

--------------------------------------

If this is helpful please accept answer.

Answer 3

A regex that works for SSN is $SSNRegex = "^(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}$".

A regex to detect credit card numbers? Good luck! Which cards? Are you going to be able to keep up with new cards, cards that go out of business, and new number patterns that are introduced?

You should start with a web search for "regex to find credit card number". You'll find examples and explanations of some of the difficulties in making sure you aren't find numbers that look like a credit card number.

I remember doing something like this years ago and found thousands credit card numbers that just happened to be part numbers from manufacturers and equipment suppliers!