使用Powershell和Excel函数来新建特殊格式的随机密码

Junson142099

已于 2022-06-30 17:25:32 修改

阅读量604

点赞数

分类专栏： Powershell 文章标签： powershell

于 2021-07-07 12:03:31 首次发布

本文链接：https://blog.csdn.net/Junson142099/article/details/118543940

版权

PowerShell 随机密码安全易混淆字符排除密码生成

关键词由CSDN通过智能技术生成

Powershell 专栏收录该内容

6 篇文章

订阅专栏

此powershell脚本可以生成"abCD12@#"这种格式的随机密码，并且去掉了英文字母l，数字1等相似的字符，非常简单，需要其他格式的可以参考修改。

#Function: New Random Passwords
#Author: Junson142099
#Last Updated Date: July 7, 2021

$lowercase = "a","b","c","d","e","f","g","h","i","j","k","m","n","p","q","r","s","t","u","v","w","x","y","z"
#no l,o
 
$uppercase = "A","B","C","D","E","F","G","H","J","K","L","M","N","P","Q","R","S","T","U","V","W","X","Y","Z"
#no I,O

$number = "2","3","4","5","6","7","8","9"
#no 0,1
 
$symbol = "~","!","@","#","$","%","^","&","*","(",")"

$p1 = Get-Random -InputObject $lowercase
$p2 = Get-Random -InputObject $lowercase
$p3 = Get-Random -InputObject $uppercase
$p4 = Get-Random -InputObject $uppercase
$p5 = Get-Random -InputObject $number
$p6 = Get-Random -InputObject $number
$p7 = Get-Random -InputObject $symbol
$p8 = Get-Random -InputObject $symbol

$password = $p1 + $p2 + $p3 + $p4 + $p5 + $p6 + $p7 + $p8
Write-Output $password

Excel生成该格式随机字符串函数如下（去掉了l,o,I,O,0,1等容易混淆的字符）：

=MID("abcdefghijkmnpqrstuvwxyz",RANDBETWEEN(1,24),1)&MID("abcdefghijkmnpqrstuvwxyz",RANDBETWEEN(1,24),1)&MID("ABCDEFGHJKLMNPQRSTUVWXYZ",RANDBETWEEN(1,24),1)&MID("ABCDEFGHJKLMNPQRSTUVWXYZ",RANDBETWEEN(1,24),1)&MID("23456789",RANDBETWEEN(1,8),1)&MID("23456789",RANDBETWEEN(1,8),1)&MID("~!@#$%^&*()",RANDBETWEEN(1,11),1)&MID("~!@#$%^&*()",RANDBETWEEN(1,11),1)

函数解释：
MID(“abcdefghijkmnpqrstuvwxyz”,RANDBETWEEN(1,24),1)；
MID(text, start_num, num_chars)函数作用是从一个字符串中截取出指定数量的字符；
RANDBETWEEN(bottom,top)函数作用是返回位于两个指定数之间的一个随机整数，在这里"24"表示的是我前面"abcdefghijkmnpqrstuvwxyz"这串字符的个数。