We help IT Professionals succeed at work.

Auto Password script

johnnyjonathan
on
293 Views
Last Modified: 2013-11-10
Hi,
I'm looking to create an automatic way that will create a password using a script to output it in a message box and copy it to the clipboard.

The password must:
"Be at least 8 positions in length but up to 10.
"Contain at least one English letter and one digit character
"Should not contain a digit character in the first and last position!(0-9)
"Should not contain identical consecutive characters (aa, ##, 88.)
"Should not contain consecutive keyboard characters (qwer)

For Example:

Correct password will be  C0mputer
(8 letters, starts and ends with an English letter)

Incorrect password - Monitor1
(ends with a digit character)

Incorrect password - monitor
(there is no digit character, less than 8 positions in length.)
Comment
Watch Question

Author

Commented:
Forgot, also it cannot containt the word "help" or "desk"
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
>> "Should not contain consecutive keyboard characters (qwer)

This one's going to be just about impossible.  If that were a strict rule,
C0mputer

would not valid either because e and r are consecutive on the keyboard.

Check this article out for validating a password:
http://www.microsoft.com/technet/scriptcenter/funzone/games/solutions08/avbsol05.mspx

Regards,

Rob.

Author

Commented:
your right, maybe i'm getting too strict :)
anyway without this rule ?
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Yeah, the rest should be doable.....do you want to validate a user-inputted password, or do want a password automatically created?  The latter will be more difficult, but I have an idea of how to do it....

Regards,

Rob.

Author

Commented:
I'm looking for the latter, just a one click script that can auto generate the password according to the rules mentioned before.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
OK, finally got there.

Give this a shot.

Regards,

Rob.
' Basis from here:
'http://www.microsoft.com/technet/scriptcenter/funzone/games/solutions08/avbsol05.mspx
' Question link:
'http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_24276924.html
'
' Password rules:
' The password must: 
' "Be at least 8 positions in length but up to 10.
' "Contain at least one English letter and one digit character
' "Should not contain a digit character in the first and last position!(0-9)
' OMITTED: "Should not contain identical consecutive characters (aa, ##, 88.)
' The last rule was omitted due to the complexity of it.
 
Const MinLength = 8
Const MaxLength = 10
 
While ValidatePassword(strPassword) = False
	strPassword = GeneratePassword
Wend
MsgBox strPassword
 
Function GeneratePassword()
 
	strRndPwd = ""
	
	If MinLength = "" Or MaxLength = "" Then
		WScript.Echo "Min and max lengths are not defined. Please set MinLength and MaxLength globally."
		Exit Function
	End If
	
	Randomize
	intLength = Int((MaxLength - MinLength + 1) * Rnd + MinLength)
 
	Const AsciiLower = 32
	Const AsciiUpper = 126
 
	While Len(strRndPwd) <= intLength
		'Randomize
		strChr = Chr(Int((AsciiUpper - AsciiLower + 1) * Rnd + AsciiLower))
		strRndPwd = strRndPwd & strChr
	Wend
 
	GeneratePassword = strRndPwd
End Function
 
Function ValidatePassword(strValPwd)
	Set objRegEx = CreateObject("VBScript.RegExp")
	boolValid = True
	' Check the length requirement
	If Len(strValPwd) < MinLength Or Len(strValPwd) > MaxLength Then boolValid = False
	' Look for an english character
	If boolValid = True Then
		objRegEx.Pattern = "[a-z][A-Z]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit
	If boolValid = True Then
		objRegEx.Pattern = "[0-9]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit in the first or last position
	If boolValid = True Then
		strFirstChr = Left(strValPwd, 1)
		strLastChr = Right(strValPwd, 1)
		If IsNumeric(strFirstChr) Or IsNumeric(strLastChr) Then boolValid = False
	End If
	ValidatePassword = boolValid
End Function

Open in new window

Author

Commented:
it works great.
one note though, can you please let me know how i can turn off the special characters addition, and the CAPS letters in ABC, to make sure it will stay coordinated with future policy?

Author

Commented:
Also, sorry i forgot this, but it must start and end with a letter is there an option to set it?
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
OK, so by omitting special characters, do you basically want only lowercase letters, and digits available for use?  The ASCII table can be found here:
http://asciitable.com/

I can make the password only include characters from decimal codes 48 through 57 for digits, and 97 through 122 for lowercase letters.

Regards,

Rob.

Author

Commented:
That's correct, however like i said, it must start and end with a letter as well.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Works great! thank you

Author

Commented:
Works like a charm, tell me please, for the future, is there an option i can block specific words from appearing even by random?
 
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Yeah sure, if you make your Validate_Password like this, it will invalidate any passwords that match words in the array.

Regards,

Rob.
Function ValidatePassword(strValPwd)
	Set objRegEx = CreateObject("VBScript.RegExp")
	boolValid = True
	' Check the length requirement
	If Len(strValPwd) < MinLength Or Len(strValPwd) > MaxLength Then boolValid = False
	' Look for an english character
	If boolValid = True Then
		objRegEx.Pattern = "[a-z]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit
	If boolValid = True Then
		objRegEx.Pattern = "[0-9]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit in the first or last position
	If boolValid = True Then
		strFirstChr = Left(strValPwd, 1)
		strLastChr = Right(strValPwd, 1)
		If IsNumeric(strFirstChr) Or IsNumeric(strLastChr) Then boolValid = False
	End If
	' Prevent specific words from being the password
	Set objDict = CreateObject("Scripting.Dictionary")
	objDict.Add "password", 0
	objDict.Add "workman", 0
	objDict.Add "hospital", 0
	If objDict.Exists(strValPwd) = True the boolValid = False
	' Return the valid code
	ValidatePassword = boolValid
End Function

Open in new window

Author

Commented:
great, understood.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Although.....that won't actually stop passwords like
hospital1a

so, I've now changed it to an InStr match, so the word can *not* be anywhere in the whole password.

Regards,

Rob.
Function ValidatePassword(strValPwd)
	Set objRegEx = CreateObject("VBScript.RegExp")
	boolValid = True
	' Check the length requirement
	If Len(strValPwd) < MinLength Or Len(strValPwd) > MaxLength Then boolValid = False
	' Look for an english character
	If boolValid = True Then
		objRegEx.Pattern = "[a-z]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit
	If boolValid = True Then
		objRegEx.Pattern = "[0-9]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit in the first or last position
	If boolValid = True Then
		strFirstChr = Left(strValPwd, 1)
		strLastChr = Right(strValPwd, 1)
		If IsNumeric(strFirstChr) Or IsNumeric(strLastChr) Then boolValid = False
	End If
	' Prevent specific words from being the password
	arrWords = Array( _
		"help", _
		"desk", _
		"hospital" _
	)
	For Each strWord In arrWords
		If InStr(strValPwd, strWord) > 0 Then boolValid = False
	Next
	' Return the valid code
	ValidatePassword = boolValid
End Function

Open in new window

Author

Commented:
Thank you Rob,
any way i can export the password to the clipbrd as well ?
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Yeah sure, this should work.

Regards,

Rob.
' Basis from here:
'http://www.microsoft.com/technet/scriptcenter/funzone/games/solutions08/avbsol05.mspx
' Question link:
'http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_24276924.html
'
' Password rules:
' The password must: 
' "Be at least 8 positions in length but up to 10.
' "Contain at least one English letter and one digit character
' "Should not contain a digit character in the first and last position!(0-9)
' "No special characters - lower case letters and digits only
' "Must begin and end with a letter
' OMITTED: "Should not contain identical consecutive characters (aa, ##, 88.)
' The last rule was omitted due to the complexity of it.
 
Const MinLength = 8
Const MaxLength = 10
 
While ValidatePassword(strPassword) = False
	strPassword = GeneratePassword
Wend
 
CopyToClipboard strPassword
 
MsgBox strPassword & " has been copied to the clipboard."
 
Function GeneratePassword()
 
	strRndPwd = ""
	
	If MinLength = "" Or MaxLength = "" Then
		WScript.Echo "Min and max lengths are not defined. Please set MinLength and MaxLength globally."
		Exit Function
	End If
	
	Randomize
	intLength = Int((MaxLength - MinLength + 1) * Rnd + MinLength)
 
	Const AsciiLower = 32
	Const AsciiUpper = 126
 
	While Len(strRndPwd) <= intLength
		'Randomize
		strChr = Chr(Int((AsciiUpper - AsciiLower + 1) * Rnd + AsciiLower))
		If (Asc(strChr) >= 48 And Asc(strChr) <= 57) Or (Asc(strChr) >= 97 And Asc(strChr) <= 122) Then strRndPwd = strRndPwd & strChr
	Wend
 
	GeneratePassword = strRndPwd
End Function
 
Function ValidatePassword(strValPwd)
	Set objRegEx = CreateObject("VBScript.RegExp")
	boolValid = True
	' Check the length requirement
	If Len(strValPwd) < MinLength Or Len(strValPwd) > MaxLength Then boolValid = False
	' Look for an english character
	If boolValid = True Then
		objRegEx.Pattern = "[a-z]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit
	If boolValid = True Then
		objRegEx.Pattern = "[0-9]"
		Set colMatches = objRegEx.Execute(strValPwd)  
		If colMatches.Count = 0 Then boolValid = False
	End If
	' Look for a digit in the first or last position
	If boolValid = True Then
		strFirstChr = Left(strValPwd, 1)
		strLastChr = Right(strValPwd, 1)
		If IsNumeric(strFirstChr) Or IsNumeric(strLastChr) Then boolValid = False
	End If
	' Prevent specific words from being the password
	arrWords = Array( _
		"help", _
		"desk", _
		"hospital" _
	)
	For Each strWord In arrWords
		If InStr(strValPwd, strWord) > 0 Then boolValid = False
	Next
	' Return the valid code
	ValidatePassword = boolValid
End Function
 
Sub CopyToClipboard(strTextForClipboard)
	Set objIE = CreateObject("InternetExplorer.Application")
	objIE.Navigate("about:blank")
	objIE.document.parentwindow.clipboardData.SetData "text", strTextForClipboard
	objIE.Quit
End Sub

Open in new window

Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.