Screencasts - Hilfsvideos

Mask SSN in Helpdesk 6.x Incident Rule

Created: 04 Juni 2012 • Aktualisiert: 05 Juni 2012 | 2 Kommentare

Maschinelle Übersetzungen

das Bild der MarkWarmacks
+2 2 Stimmen
Bitte loggen Sie sich ein, um abzustimmen

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

Kommentare KommentareZum neuesten Kommentar

das Bild der KSchroeders

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.

Bitte loggen Sie sich ein, um abzustimmen
das Bild der ohzone - CherylPetersons

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


Endpoint Management,
Endpoint Virtualization
Managing Mobility
Community Manager
Need Altiris help? IRC chat #Altiris

Bitte loggen Sie sich ein, um abzustimmen