Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Mask SSN in Helpdesk 6.x Incident Rule

Created: 04 Jun 2012 • Updated: 05 Jun 2012 | 2 comments
Language Translations
MarkWarmack's picture
+1 1 Vote
Login to vote

Ever wonder how to keep Social Security Numbers (SSN) out of your Helpdesk 6.x environment.

With the HDQUERY and REGEX below, you can safely mask all SSNs with X's.

Hope this helps.

 

Here is the rule properties (see screenshot also):
 
Name:  REPLACE SSN in E-mail Sent as Helpdesk Incidents
 
Comment:  This rule will REPLACE a SSN with 'XXX-XX-XXXX' in a ticket in e-mail or manually saved comments.
 
Set these properties:  Set "Comment" to "HDQUERY[[SELECT REPLACE ((Cast(Comment as nvarchar(max))),(SUBSTRING(Comment,PATINDEX('% [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9] %', Comment) + 1, 11)),'XXX-XX-XXXX') FROM workitem with (NOLOCK) WHERE number = WORKITEM(workitem_number) AND is_last=1]]"
 
When:  Every time incident is saved
 
And:  When ALL of these are TRUE
   "Comment" matches regular expression "^(\d{3}-\d{2}-\d{4})|(\d{3}\d{2}\d{4})*$
<end>
 
Status:  Active

Is terminal:  Yes

Comments 2 CommentsJump to latest comment

KSchroeder's picture

Nice one Mark...I'm sure I'd be all over that if we used Helpdesk! :)

You should make this a public article so everyone can see it; right now only the STL UG can.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

0
Login to vote
ohzone - CherylPeterson's picture

I agree with Kyle - good information should be shared with the Community.

Cheryl

Endpoint Management,
Endpoint Virtualization
Managing Mobility
Community Manager
www.twitter.com/EMnV_symc
Need Altiris help? IRC chat #Altiris

0
Login to vote