<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=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* 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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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><span style='color:#1F497D'>From a Historical Reporting standpoint your looking at numbers/average, etc. If deleting that users data, it would skew some reports, etc.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Maybe an option to enable/disable disabled users in reports.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><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:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Louis Koekemoer (ZA)<br><b>Sent:</b> Tuesday, November 16, 2010 3:29 AM<br><b>To:</b> cisco-voip@puck.nether.net<br><b>Subject:</b> [cisco-voip] Historical Reporting<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have an issue with historical reporting. Users left months ago, UDP and end user has been deleted, user does not appear in IPCC anymore, but still if you pull a report, the resources still exist there. I assume I might have to go into some table in SQL and delete a row, but is scared to go and mess up things. Anyone can help me with this?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-ZA>Regards<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-ZA>Louis Koekemoer</span></b><span lang=EN-ZA><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Senior Cisco IPT Systems Engineer<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Converged Communications<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Dimension Data (South Africa)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Tel: +27 (11) 575 6560<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Fax: +27 (11) 576 6560<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Cell: +27 (71) 680 8790<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA>Email: <a href="mailto:Louis.Koekemoer@za.didata.com">Louis.Koekemoer@za.didata.com</a> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA style='color:red'>Planned Training – 15/11/2010 - 26/11/2010<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-ZA style='color:red'>Planned Leave - 29/11/2010 - 03/12/2010 <o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='color:#1F497D'>For further information about Dimension Data, please go to <a href="http://www.dimensiondata.com/" title="http://www.dimensiondata.com/">www.dimensiondata.com</a><o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:Webdings;color:#00B050'>P </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#00B050'>Before printing this email please think about the environment</span></b><b><span style='font-size:10.0pt;color:#00B050'> </span></b><span style='font-size:10.0pt;color:#00B050'> </span><span lang=EN-ZA><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p>This email and all contents are subject to the following disclaimer:<o:p></o:p></p><p>"<a href="http://www.dimensiondata.com/emaildisclaimer">http://www.dimensiondata.com/emaildisclaimer</a>"<o:p></o:p></p></div></body></html>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
Disclaimer:
This e-mail communication and any attachments may contain confidential and privileged information and is for use by the designated addressee(s) named above only. If you are not the intended addressee, you are hereby notified that you have received this communication in error and that any use or reproduction of this email or its contents is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer. Thank you.
</STRONG></P></BODY></HTML>