Video Screencast Help
Symantec Secure Login will be live on Connect starting February 25. Get the details here.

Mask SSN in Helpdesk 6.x Incident Rule

Created: 04 Jun 2012 • Updated: 05 Jun 2012 | 2 comments
Language Translations
MarkWarmack's picture
+2 2 Votes
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})*$
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.

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.

Login to vote
ohzone's picture

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


Community Manager
Need Altiris help? IRC chat #Altiris

Login to vote