Browse Guides

Missing or Deleted Tickets
Reading mode
Copy Link
Link Copied!
Print
Feedback
This guide has multiple versions available:
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- Why can&#39;t I access a Ticket?</strong></p><p><strong>- Recovering Deleted Tickets</strong></p><p><strong>- Preventing Agents from Deleting Tickets</strong></p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">Why can&#39;t I access a Ticket?</span></strong></p><p>The below screen indicates a ticket that cannot be accessed.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjYzODZmOWFhLWVmY2EtNDJkYS04YjkwLTI5YWI5Mjc3OTg5YiJ9.kuRZGOTYNx-GNk7TOAN2IaTrOiVMugf1uCUz4GMeKtY" class="fr-fic fr-fil fr-dib" width="507" height="234"></p><p><strong><span style="font-size: 10pt;">Fig 1. Inaccessible Ticket.</span></strong></p><p><br></p><p>There are a variety of reasons as to why this may be the case.</p><p><br></p><ul><li>The Ticket has been deleted.</li><li>The Ticket has been hidden from your view, either in a section you cannot view, or holds an attribute restricted from your view such as category, ticket type, ticket group etc.</li><li>The Ticket has been merged into another one.</li></ul><p><br></p><p>The most efficient way to understand why a ticket is inaccessible is by reporting on it. The following is a SQL script which when run will show whether a ticket has been deleted and so on.</p><p><br></p><p>First, head to your Reporting Suite. Click &quot;New&quot; in the top right-hand corner and head to &quot;Data Source&quot;. Select the source called *Write a custom SQL Query*. Paste the below script into the text box and head to &quot;Preview Report&quot;. Pick the date range for the ticket&#39;s submission and then click on the load button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjI4NmFjZTk2LTJjODktNDA2Mi1hMjI3LWE4OGUwMTgyZGM0MCJ9.nqsrmpWGMKCMlx-blEnhn5o1vCuNPyS_ah-gIEl0DMg" class="fr-fic fr-fil fr-dib" width="1218" style="width: 1220px; height: 273.286px;" height="273"></p><p><strong><span style="font-size: 10pt;">Fig 2. Custom SQL Data Source.</span></strong></p><p><br></p><p>SELECT faults.faultid &nbsp; &nbsp; &nbsp; &nbsp;AS [Ticket Number],<br>&nbsp; &nbsp; &nbsp; &nbsp;CASE<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHEN fdeleted &gt; 0 THEN &#39;True&#39;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ELSE &#39;False&#39;<br>&nbsp; &nbsp; &nbsp; &nbsp;END &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS [Ticket deleted?],<br><em>LEFT</em>(dateoccured, 19) AS [Ticket Submitted],<br>&nbsp; &nbsp; &nbsp; &nbsp;tstatusdesc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS [Status],<br>&nbsp; &nbsp; &nbsp; &nbsp;sectio_ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS [Team],<br>&nbsp; &nbsp; &nbsp; &nbsp;rtdesc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS [Ticket Type],&nbsp;</p><p>&nbsp; &nbsp; &nbsp; &nbsp;Category2 as [Ticket Category],</p><p>&nbsp; &nbsp; &nbsp; &nbsp;Acurrent.uname &nbsp; &nbsp; &nbsp; &nbsp;AS [Assigned Agent],<br><em>LEFT</em>(datecleared, 19) AS [Closure Date],<br>&nbsp; &nbsp; &nbsp; &nbsp;Acleared.uname &nbsp; &nbsp; &nbsp; &nbsp;AS [Closing Agent],<br>&nbsp; &nbsp; &nbsp; &nbsp;CASE<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHEN fmergedintofaultid &gt; 0 THEN &#39;Ticket Merged into &#39;<br>+ <em>Cast</em>(fmergedintofaultid AS&nbsp;<em>NVARCHAR</em>)<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ELSE &#39;Not Merged&#39;<br>&nbsp; &nbsp; &nbsp; &nbsp;END &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS [Ticket Merged]<br>FROM &nbsp; faults<br>&nbsp; &nbsp; &nbsp; &nbsp;LEFT JOIN requesttype<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON requesttypenew = rtid<br>&nbsp; &nbsp; &nbsp; &nbsp;LEFT JOIN uname Acurrent<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON assignedtoint = Acurrent.unum<br>&nbsp; &nbsp; &nbsp; &nbsp;LEFT JOIN uname Acleared<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON clearwhoint = Acleared.unum<br>&nbsp; &nbsp; &nbsp; &nbsp;LEFT JOIN tstatus<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON tstatus = status<br>WHERE &nbsp;dateoccured BETWEEN @startdate AND @enddate &nbsp;</p><p><br></p><p><strong><span style="font-size: 14pt;">Recovering Deleted Tickets</span></strong></p><p>If the Ticket has not been permanently deleted, it can be recovered. In Configuration &gt; Advanced Settings, click on the &quot;Deleted Tickets&quot; button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgwZmI1MWZiLTViOWYtNDVmOS05NGY2LTE5NjRmMDYxNzdlNiJ9.GDkL3OW8otU1hwMH90AXHViDVr9puzX-d7Q8oxwLPdA" class="fr-fic fr-fil fr-dib" width="1223" height="656"></p><p><strong><span style="font-size: 10pt;">Fig 3. Deletion Settings.</span></strong></p><p><br></p><p>Select the Ticket with the checkbox next to it, hover over &quot;Edit&quot;, and choose &quot;Recover&quot;.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVhOTZiYzI5LTU5NDctNDE1MC1hOTgxLTdlNzdmMjY0NWVjNiJ9.7VYJeezkVdwJb9K42rj2LwKXvZ2FU75L4bTJCbT7JmU" class="fr-fic fr-fil fr-dib" width="326" height="143"></p><p><strong><span style="font-size: 10pt;">Fig 4. Recovering a Ticket.</span></strong></p><p><br></p><p id="isPasted">Permanent deletion can be enabled/disabled through the following option in Configuration &gt; Advanced Settings.</p><p><br></p><ul><li><strong>Permanently delete Tickets from the database:</strong> When unselected, deleting Tickets will remove them from the UI but maintain records in the DB. When checked, Tickets are also deleted from the DB.</li><li><span id="isPasted"><strong>Tickets will be temporarily deleted and then permanently deleted after X number of days</strong><span style="white-space:pre;" id="isPasted">:&nbsp;</span></span>This checkbox will show if the above is enabled. When selected, a field will show to choose the number of days that permanent deletion occurs. Before that day threshold, tickets can still be recovered.</li><li id="isPasted"><strong>Number of days before Tickets are permanently deleted</strong><span style="white-space:pre;" id="isPasted"><strong>:</strong>&nbsp;</span>This field will show if the above is enabled, and will default to 30 days. The number entered here will become the number of days after deletion that permanent deletion of ticket occurs.&nbsp;</li></ul><p><br></p><p>If &quot;Permanently delete Tickets from the database&quot; is enabled and &quot;Tickets will be temporarily deleted and then permanently deleted after X number of days&quot; is disabled, Tickets will be permanently deleted immediately and they <strong>cannot&nbsp;</strong>be recovered. <strong><em>For this reason, it is highly recommended to either set a number of days to permanently delete after, or disable permanent deletion completely.&nbsp;</em></strong></p><p><br></p><p><strong id="isPasted"><span style="font-size: 14pt;">Preventing Agents from Deleting Tickets</span></strong></p><p>You can stop Agents from being able to delete tickets by setting &quot;Can Delete Tickets&quot; to &quot;No&quot; in the &quot;Permissions&quot; tab of their Agent profile.</p><p><br></p><p><strong><em>Note: Their role may inherit a higher permission, and the highest level of access takes precedence, so make sure to check that they are not inheriting higher permissions from a role (like this Agent is below), as this will override due to it being a higher permission.</em></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRlZTRlMjcxLWE3MzItNGIzOC05OTIwLWNhMTY0YzllNWFiNyJ9.l2r35CFH0tW6Cde17uzLFg-iFvGnLNIzhRjQGxKpSn8" class="fr-fic fr-fil fr-dib" width="961" height="231"></p><p><strong><span style="font-size: 10pt;">Fig 5. Can Delete Tickets permission.</span></strong></p><p><br></p><p>You can also enable &quot;Ask to enter a reason when deleting a Ticket&quot;. This will not prevent Agents from being able to delete Tickets, but may prevent accidental deletions as the reason will need to be entered before the deletion is processed.</p>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.