cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #389: Password and Security Violations

AYXAcademy
Alteryx

Challenge #389: Password and Security Violations

WC_Banner_V2.png

Hi Maveryx,

 

A solution to last week’s challenge can be found here.

 

This challenge comes to us from @NicoleJohnson 

WC389_Image.jpg

Thank you for your contribution, Nicole!

 

Picture yourself as an auditor within a prominent financial institution. Your primary duty involves performing meticulous security audits across various software applications. This entails deciphering the extent of access granted to individual users based on the last password update and identifying instances of any breaches in security protocols.

 

In this challenge, your task is to determine the number of password and security violations attributable to each user. The dataset you are working with contains data for three distinct users. However, there is a slight complication: all the pertinent information is consolidated within a single column.

Hint: The number of password or security violations is indicated in parentheses following PSWD-VIO and SEC-VIO. For example, PSWD-VIO(2) indicates the user has two password violations and SEC-VIO(3) indicates the user has three security violations.

 

Attachment
Download this attachment
Attachment
Download this attachment

Re: Challenge #389: Password and Security Violations

Hey @braveraj j, there might be a fancier way to solve this, BUT you nailed the task with your skills, and that's the beauty of Designer – it's democratic.

You can tackle the same problem with just one or two tools or use many tools and still achieve the same result!

Your solution is awesome, by the way!

Truly inspiring!

 

Sylvia

Re: Challenge #389: Password and Security Violations

@patrick_digan , seriously? Only two tools???? 

You absolutely aced it! I love the formulas you applied; I never even considered that approach.

Thanks a bunch for sharing!

 

Sylvia

Re: Challenge #389: Password and Security Violations

It is @Qiu !

Thanks for sharing! 

 

Sylvia

Highlighted
PhilipMannering
16 - Nebula

Re: Challenge #389: Password and Security Violations

My solution

Spoiler
2023-09-19_17-35-59.png

And in the Python Tool,

Spoiler
2023-09-19_17-35-32.png
a640687
Asteroid

Re: Challenge #389: Password and Security Violations

Spoiler
389.PNG
Attachment
Download this attachment
vladimirt94
Meteor

Re: Challenge #389: Password and Security Violations

Maybe too many tools, could parse in just one formula. 

Spoiler
Screenshot 2023-09-19 163251.png
Attachment
Download this attachment

Re: Challenge #389: Password and Security Violations

You rock @PhilipMannering!

DaisukeTsuchiya
14 - Magnetar

Re: Challenge #389: Password and Security Violations

Spoiler
スクリーンショット 2023-09-20 122207.jpg

Attachment
Download this attachment
alacoume
Comet

Re: Challenge #389: Password and Security Violations

My solution:

Spoiler
Challenge289.jpg

Attachment
Download this attachment
TurboToad
11 - Bolide

Re: Challenge #389: Password and Security Violations

My solution, always enjoy a good regex problem!

 

Spoiler
389.PNG
Attachment
Download this attachment