ビデオヘルプ

Mask SSN in Helpdesk 6.x Incident Rule

作成: 04 Jun 2012 • 更新: 05 Jun 2012 | コメント数: 2
各国語の翻訳
MarkWarmack の写真
+2 得票数: 2
ログインして投票

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

コメント コメント数: 2最新のコメントを表示

KSchroeder の写真

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
ログインして投票
  • アクション
ohzone - CherylPeterson の写真

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
ログインして投票
  • アクション