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