87|ALTERYX – Password Cracker


This was a fun one!
Passwords_JamesGerstner.yxmd (26.0 KB)
I used some suggestions from students in this thread to come up with other password options (i.e. using names, using ChatGPT to help make a list). Thanks for the challenge!

1 Like


I wasn’t sure if we still wanted the plain text of the passwords too, so I used the formula to add them as an additional column, just so I could have both.

Great practice! The first thing I did was hash the most common passwords found on the “Most Common Passwords” Excel file. I completed this by using a formula tool, which took the passwords and converted it into a hashed password. Then, I joined these new hashes with those found in the “Passwords” Excel file, which contained all of the user names and passwords. From there, I filtered out the duplicates to find unique users whose passwords had been cracked as well as the unique passwords cracked.
In the second portion, I took information from the student database and hashed out specific strings that I believed could be a password. Then, like above, I hashed these passwords using the formula tool and joined those hashes with the passwords found in the database.
Blobs.yxmd (14.5 KB)
image

1 Like

Challenge87.yxmd (13.9 KB)


I loved this challenge! It is amazing what Alteryx can do. This challenge would’ve been really helpful for me a few weeks ago, but I’m glad I can do it now. It reinforced what I learned during the Hackathon.


Turns out 1113 of the users are using one of the 200 most common passwords. A little concerning.


This was a fun challenge. It’s been awhile since I’ve used the blob tool.

Time to Complete: 15 minutes
Rating: Pretty easy
This was a fun challenge that helped me learn new formulas/tools!

Time to complete : 20 mins
Difficulty: beginner
Notes: Very fun and a great way to learn about the blob convert


tool

Time to complete : 25 mins
Difficulty: beginner/medium

Notes: Interesting to learn about the blob convert

1 Like

Time: 30 Min
Difficulty: Beginner/Medium

Time: 35 Minutes
Difficulty: Beginner

Time to Complete: 30 minutes
Level: Hard

1 Like

Time to complete: 25 minutes
Level: Intermediate because of unfamiliarity

Time to complete: 15 Minutes
Difficulty: Beginner

Time to complete: 20 minutes
Level: Beginner
Comments: I think I did this right but was unsure as I have never heard of these blob tools before. I think it worked but I was unsure how to incorporate the other student information on there.

1 Like

New Workflow3.yxmd (6.6 KB)
I enjoyed this one.
Time: 15 minutes
Challenge: Moderate

15 minutes
Beginner

1 Like


Time to Complete: 5 mins
Beginner