Good news / bad news - Connection does store auditing information, including user creation and deletion, but there is not yet a good way to access it as far as I know. It is in the UnityRptDb. You can pull the data from the DB using CUDLI, available here:<br>
<br><a href="http://ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html" target="_blank">http://ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html</a><br><br>Once connected via CUDLI, select UnityRptDb as the database and pick vw_auditlog as the table. The column descriptions in the upper right are pretty useful for explaining what each column in the table is. The most useful for this purpose would be alias, date, source, and text. There will likely be too much data in that table to just browse, so you'll need to run a query via view -> query builder. Two things you might want to search by are source (which is just the name of the stored procedure that was run, such as csp_SubscriberCreate) and alias (the alias of the user performing the activity). Some sample queries for those would look like:<br>
<br>All user deletes:<br>select * from vw_auditlog where source = 'csp_UserDelete'<br><br>All activity for <username>:<br>select * from vw_auditlog where alias = '<username>'<br><br>-Pat<br><br>
<div class="gmail_quote">On Tue, Jul 19, 2011 at 11:48 AM, Wellnitz, Erick A. <span dir="ltr"><<a href="mailto:erick.wellnitz@kattenlaw.com" target="_blank">erick.wellnitz@kattenlaw.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">The audit logs in Connection are rubbish. CUCM is much more robust in the default audit log settings.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
<p><span style="font-size:11.0pt;color:#1F497D">To track changes such as user creation and deletion there is a micro trace ‘CUCA’ which logs to
</span><span style="font-size:9.5pt;color:black">diag_Tomcat_*.uc which translates to ‘Connection Tomcat Application’ in RTMT.<u></u><u></u></span></p>
<p><span style="font-size:9.5pt;color:black">Still waiting to hear if my assumptions on which of the following need to be enabled is correct.<u></u><u></u></span></p>
<p>00 Errors and Fatal events <u></u><u></u></p>
<p> 01 General <u></u><u></u></p>
<p> 02 Data Access (High) <u></u><u></u></p>
<p> 03 Data Access (Low) <u></u><u></u></p>
<p> 04 Data Utilities <u></u><u></u></p>
<p> 05 Actions <u></u><u></u></p>
<p> 06 Tomcat Tools <u></u><u></u></p>
<p> 07 Tools <u></u><u></u></p>
<p> 09 Tags <u></u><u></u></p>
<p> 10 Port Monitor Service<u></u><u></u></p>
<p><span style="font-size:9.5pt;color:black"><u></u> <u></u></span></p>
<p><span style="font-size:9.5pt;color:black"><u></u> <u></u></span></p>
<p><span style="font-size:9.5pt;color:black">Thanks to Tony at TAC for pointing this document out.<u></u><u></u></span></p>
<p><span style="font-size:9.5pt;color:black"><a href="http://www.cisco.com/en/US/customer/docs/voice_ip_comm/connection/8x/serv_administration/guide/8xcucservag030.html#wp1050964" target="_blank">http://www.cisco.com/en/US/customer/docs/voice_ip_comm/connection/8x/serv_administration/guide/8xcucservag030.html#wp1050964</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></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">From:</span></b><span style="font-size:10.0pt"> Ryan Ratliff [mailto:<a href="mailto:rratliff@cisco.com" target="_blank">rratliff@cisco.com</a>]
<br>
<b>Sent:</b> Tuesday, July 19, 2011 9:52 AM<br>
<b>To:</b> Wellnitz, Erick A.<br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] Connection log/trace files<u></u><u></u></span></p>
</div>
</div><div><div></div><div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">For CUCM the tomcat access logs can be of help if audit logs are not enabled. It'll take a bit of detective work to figure out the URLs accessed and such but can be done. Since UC has the same platform I'd expect these same logs to
be present on it as well. <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">If you can see some activity then go in as yourself and delete a temp user. Find in the logs what your activity looks like and then search through past logs for similar activity.<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:13.5pt;color:black">-Ryan<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Jul 18, 2011, at 5:45 PM, Wellnitz, Erick A. wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
<br>
<span><span style="font-size:13.5pt;font-family:"Lucida Grande","serif""><u></u><u></u></span></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Anyone know which log /trace file in RTMT I could look at besides audit log to see who has been doing what and when. I need to find when a user was deleted from the system.
Unity Connection 8.x</span><span style="font-size:11.0pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#333333">ERICK A. WELLNITZ<span> </span></span></b><span style="font-size:10.0pt"><br>
<span style="color:#333333">Network Engineer</span><br>
<b><span style="color:#83A6BD">Katten Muchin Rosenman LLP</span></b><br>
<span style="color:#333333">525 W. Monroe Street / Chicago, IL 60661-3693</span><br>
<span style="color:#333333">p / <a href="tel:%28312%29%20577-8041" value="+13125778041" target="_blank">(312) 577-8041</a><span> </span></span><br>
</span><span style="font-size:11.0pt"><a href="mailto:erick.wellnitz@kattenlaw.com" target="_blank"><span style="font-size:10.0pt;color:#333333">erick.wellnitz@kattenlaw.com</span></a></span><span><span style="font-size:10.0pt"> </span></span><span style="font-size:10.0pt">/<span> </span></span><span style="font-size:11.0pt"><a href="http://www.kattenlaw.com/" target="_blank"><span style="font-size:10.0pt;color:#333333">www.kattenlaw.com</span></a><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"> <u></u><u></u></span></p>
</div>
<table border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:white;padding:.75pt .75pt .75pt .75pt">
<pre><span style="color:black">===========================================================<u></u><u></u></span></pre>
<pre><span style="color:black">CIRCULAR 230 DISCLOSURE: Pursuant to Regulations Governing Practice Before the Internal Revenue<u></u><u></u></span></pre>
<pre><span style="color:black">Service, any tax advice contained herein is not intended or written to be used and cannot be used<u></u><u></u></span></pre>
<pre><span style="color:black">by a taxpayer for the purpose of avoiding tax penalties that may be imposed on the taxpayer.<u></u><u></u></span></pre>
<pre><span style="color:black">===========================================================<u></u><u></u></span></pre>
<pre><span style="color:black">CONFIDENTIALITY NOTICE:<u></u><u></u></span></pre>
<pre><span style="color:black">This electronic mail message and any attached files contain information intended for the exclusive<u></u><u></u></span></pre>
<pre><span style="color:black">use of the individual or entity to whom it is addressed and may contain information that is<u></u><u></u></span></pre>
<pre><span style="color:black">proprietary, privileged, confidential and/or exempt from disclosure under applicable law. If you<u></u><u></u></span></pre>
<pre><span style="color:black">are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or <u></u><u></u></span></pre>
<pre><span style="color:black">distribution of this information may be subject to legal restriction or sanction. Please notify<u></u><u></u></span></pre>
<pre><span style="color:black">the sender, by electronic mail or telephone, of any unintended recipients and delete the original <u></u><u></u></span></pre>
<pre><span style="color:black">message without making any copies.<u></u><u></u></span></pre>
<pre><span style="color:black">===========================================================<u></u><u></u></span></pre>
<pre><span style="color:black">NOTIFICATION: Katten Muchin Rosenman LLP is an Illinois limited liability partnership that has<u></u><u></u></span></pre>
<pre><span style="color:black">elected to be governed by the Illinois Uniform Partnership Act (1997).<u></u><u></u></span></pre>
<pre><span style="color:black">===========================================================<u></u><u></u></span></pre>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Lucida Grande","serif"">_______________________________________________<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><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div></div></div>
</div>
<br>_______________________________________________<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><br>
<br></blockquote></div><br>