<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.imprintuniqueid, li.imprintuniqueid, div.imprintuniqueid
{mso-style-name:imprintuniqueid;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">If you are interested, one StoneScribe solution (<a href="https://www.donomasoftware.com/donoma-stonescribe/">https://www.donomasoftware.com/donoma-stonescribe/</a>) will manage this.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">StoneScribe will manage those chats to the end of their lifecycle and then not only delete them – they are file-shredded. There’s a lot StoneScribe does… but for your problem here, I’ve limited my comments to that issue.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We sell through Cisco resellers around the world, so you can either reach out to them – or you can start with contacting us direct and we can loop in your integrator of choice.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Parker Pearson<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-line-height-rule:exactly;-webkit-text-size-adjust:100%;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:20px 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="center" style="padding:0 10px 0 0;border-top:none;border-right:solid 2px #9BBB59;border-bottom:none;border-left:none;vertical-align:middle;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="center" style="padding:0 1px 8px 0;vertical-align:middle;"><a href="http://donomasoftware.com/" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="http://www.ali-inc.com/images/donoma.png" width="64" height="71" border="0" title="Donoma Software Web Page" alt="Donoma Software Web Page" style="width:64px;min-width:64px;max-width:64px;height:71px;min-height:71px;max-height:71px;font-size:12px;" /></a></td></tr></table></td><td align="left" style="padding:10px 0 10px 10px;vertical-align:middle;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;font-size:0;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#571D1F;font-style:normal;font-weight:700;white-space:nowrap;"><tr style="font-size:18px;"><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;">Parker</td><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;font-weight:400;"> <br /></td><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;">Pearson</td></tr></table></td></tr><tr style="font-size:14px;"><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;">Vice President, Marketing & Business Development</td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:15px 0 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#571D1F;font-style:normal;font-weight:700;white-space:nowrap;"><tr style="font-size:16px;"><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;">Donoma Software<br /></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><tr style="font-size:12px;"><td align="left" style="padding:4px 0 0;vertical-align:top;font-family:Calibri,Arial,sans-serif;">1750 Kraft Dr. Suite 1200 Blacksburg, VA 24060<br /></td></tr></table></td></tr></table></td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:4px 0 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:12px;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><td align="left" style="vertical-align:top;font-family:Calibri,Arial,sans-serif;"><span style="color:#4B7C53;">t:</span> <a href="tel:540.443.3577" target="_blank" id="LPlnk689713" style="text-decoration:none;color:#000001;"><strong style="font-weight:400;">540.443.3577</strong></a></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><tr style="font-size:12px;"><td align="left" style="padding:4px 0 0;vertical-align:top;font-family:Calibri,Arial,sans-serif;"><span style="color:#4B7C53;">e:</span> <a href="mailto:parker@donomasoftware.com" target="_blank" id="LPlnk689713" style="text-decoration:none;color:#000001;"><strong style="font-weight:400;">parker@donomasoftware.com</strong></a></td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;color:#000001;font-style:normal;font-weight:400;white-space:nowrap;"><tr style="font-size:12px;"><td align="left" style="padding:4px 0 0;vertical-align:top;font-family:Calibri,Arial,sans-serif;"><span style="color:#4B7C53;">w:</span> <a href="http://www.example.com/" target="_blank" id="LPlnk689713" style="text-decoration:none;color:#000001;"><strong style="font-weight:400;">www.donomasoftware.com</strong></a></td></tr></table></td></tr></table></td></tr></table></td></tr><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:10px 0 0;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="font-size:0;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="center" style="padding:0 6px 0 0;vertical-align:top;"><a href="https://www.facebook.com/DonomaSoftware" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="cid:image183372.png@18778D47.032173B7" width="24" height="24" border="0" title="Facebook" alt="Facebook" style="width:24px;min-width:24px;max-width:24px;height:24px;min-height:24px;max-height:24px;font-size:12px;" /></a></td></tr></table></td><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="center" style="padding:0 6px 0 0;vertical-align:top;"><a href="https://twitter.com/donomasoftware" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="cid:image421177.png@D24285C7.C3AAD282" width="24" height="24" border="0" title="Twitter" alt="Twitter" style="width:24px;min-width:24px;max-width:24px;height:24px;min-height:24px;max-height:24px;font-size:12px;" /></a></td></tr></table></td><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;font-size:0;line-height:normal;"><tr style="font-size:0;"><td align="center" style="padding:0 6px 0 0;vertical-align:top;"><a href="https://www.linkedin.com/company/donoma-software" target="_blank" id="LPlnk689713" style="text-decoration:none;"><img src="cid:image846049.png@3BE1595D.BBF7D1FB" width="24" height="24" border="0" title="LinkedIn" alt="LinkedIn" style="width:24px;min-width:24px;max-width:24px;height:24px;min-height:24px;max-height:24px;font-size:12px;" /></a></td></tr></table></td></tr></table></td></tr></table></td></tr></table></td></tr></table></td></tr></table></td></tr></table></div><div style="mso-line-height-rule:exactly;-webkit-text-size-adjust:100%;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;"><tr style="font-size:0;"><td align="left" style="vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="width:100%;font-size:0;"><tr style="font-size:0;"><td align="left" style="padding:6px 0 0;border-top:solid 1px #E1E1E1;border-right:none;border-bottom:none;border-left:none;vertical-align:top;"><table cellpadding="0" cellspacing="0" border="0" style="white-space:normal;color:#C0C0C0;font-size:14.67px;font-family:Calibri,Arial,sans-serif;font-weight:400;font-style:normal;text-align:justify;width:100%;"><tr style="font-size:10.67px;"><td style="font-family:Calibri,Arial,sans-serif;">The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.<span style="font-family:remialcxesans;font-size:1px;color:#FFFFFF;"></span><br /></td></tr></table></td></tr></table></td></tr></table></div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">cisco-voip <cisco-voip-bounces@puck.nether.net> on behalf of Erick Wellnitz <ewellnitzvoip@gmail.com><br>
<b>Date: </b>Wednesday, February 13, 2019 at 10:37 AM<br>
<b>To: </b>Anthony Holloway <avholloway+cisco-voip@gmail.com><br>
<b>Cc: </b>Cisco VoIP Group <cisco-voip@puck.nether.net><br>
<b>Subject: </b>Re: [cisco-voip] Persistent Chat<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If I ever find out what the customer does I'll definitely update everyone. I may even write something in the lab to share if I ever get some time.
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I'd imagine a python script on a small linux host could run every night to clean up old entries. <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="imprintuniqueid"><br>
<span style="font-size:10.0pt;color:#BFBFBF"> </span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<p class="imprintuniqueid" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;color:#BFBFBF">The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact
the sender and destroy any copies of this information.</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Feb 12, 2019 at 10:05 AM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com">avholloway+cisco-voip@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">Oh I see. Well, since Cisco does mention the following: <o:p>
</o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">"We recommend that you maintain the external database according to the best practice guidelines described in the product documentation. If you do not properly maintain the external database,
<span style="background:#FFF2CC">and you allow the external database to fill up</span>, this causes performance problems in the IM and Presence Service cluster."<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">It stands to reason that you could just use the method you described initially, which is to have your SQL admin write the procedure to delete records older than X days.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Good luck, and I'd be curious to know which route you take.<o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Feb 12, 2019 at 8:56 AM Erick Wellnitz <<a href="mailto:ewellnitzvoip@gmail.com" target="_blank">ewellnitzvoip@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">That works for what loads in Jabber but they're concerned with the messages existing in the database which makes them fair game for legal discovery.<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Feb 11, 2019 at 7:59 PM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Is it not just the setting labeled <b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#58585B">Maximum number of messages that can be retrieved from the archive?</span></b><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Feb 11, 2019 at 11:12 AM Erick Wellnitz <<a href="mailto:ewellnitzvoip@gmail.com" target="_blank">ewellnitzvoip@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">All, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">With the introduction of WebEx Teams the request for persistent chat isn't so common anymore.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have a client asking about it and how we can limit how long messages are kept in persistent chat.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I can't find a native way to do that but was thinking if IM&Presence doesn't index the database independently an SQL admin could write a procedure to remove entries older than x days. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Any thoughts?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></p>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</body>
</html>