<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;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- Tracking Device Change History</strong></p><p><strong>- Filtering Device Change History</strong></p><p><strong>- Changing to Tile View</strong></p><p><strong>- Reporting on Device Changes</strong></p><p><strong>- Optimising Device Change history</strong></p><p><br></p><p><br></p><p><strong>Admin Guides:</strong></p><ul><li style="font-weight: bold;"><a href="https://usehalo.com/haloitsm/guides/1340/" target="_blank" rel="noopener noreferrer"><strong>General Settings (Asset Management)</strong></a></li></ul><p><strong><br></strong></p><p><strong>Related Guides:</strong></p><ul><li><a href="https://usehalo.com/haloitsm/guides/923/" target="_blank" rel="noopener noreferrer"><strong>Asset Management</strong><br></a></li><li style="font-weight: bold;"><a href="https://usehalo.com/haloitsm/guides/956/" target="_blank" rel="noopener noreferrer"><strong>Linking Assets</strong></a> </li><li style="font-weight: bold;"><a href="https://usehalo.com/haloitsm/guides/922/" target="_blank" rel="noopener noreferrer">The Asset Catalogue</a></li></ul><p><br></p><p><strong><span style="font-size: 14pt;">Tracking Device Change History</span></strong></p><p>Within your "Assets" area, you can track changes made to an asset in the "Change History" tab. This will show changes to an asset in a table view with the most recent showing first. In the example below, the user the asset is assigned to has been changed, followed by a site change. <br><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjM5MDJkNThlLWM2NWYtNDkzNy05ZjkxLThkYjUxMTViN2NkNiJ9.Km0ePr3zQWrCwiqzKT_GD_WHcgUAup8Oo5v4qEh2ApI" class="fr-fic fr-fil fr-dib" width="998" style="width: 1000px; height: 490.339px;" height="490"></p><p><strong><span style="font-size: 10pt;">Fig 1. Change History tab on an asset</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Filtering Device Change History</span></strong></p><p>Filtering can be applied to change history by hovering over the column name so that the filtering icon appears.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFhNmMyMDllLTdjZTEtNGZlYi04ZTRlLTVkMmU2YTViM2MxNiJ9.Uf5H_lNeqj2Je4nWrBy_W7kx3aPH1J0JlhW5p8I_BD8" class="fr-fic fr-fil fr-dib" style="width: 991px; height: 483.881px;" width="989" height="484"></p><p><strong><span style="font-size: 10pt;">Fig 2. Filter icon on a column.</span></strong></p><p><br></p><p>You can then click this icon and a search bar will appear to allow you to filter. "What", "From", "To" and "Who" use a type search field, whereas "When" shows a calendar popup to select a date from.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE2M2VkYzdiLTI5MjUtNGU4Zi05MDk2LWQzMGUzOWNiYjI5NSJ9.NF9VOKa1pF9BRltmhRWcy-7cY3kUak-riavEfyuV56A" class="fr-fic fr-fil fr-dib" style="width: 987px; height: 482.956px;" width="985" height="483"></p><p><strong><span style="font-size: 10pt;">Fig 3. Filtering the results.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Changing to Tile View</span></strong></p><p>Change history can also be viewed within tile view by selecting it from the "..." dropdown in <strong>Fig 4</strong>.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgwZjkyNDVkLWRiMDUtNDk5ZC1hNzRhLWJjZTdhZDdjMzk3MSJ9.WRvyZ6HcgNA0C6V-u_H7FYPxxMV_2GkC-6gPH7FT7ok" class="fr-fic fr-fil fr-dib" width="992" style="width: 994px; height: 486.359px;" height="486"></p><p><strong><span style="font-size: 10pt;">Fig 4. Change History in tile view.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Reporting on Device Changes</span></strong></p><p>The change history is linked to the "devicechange" table when reporting. <strong>Fig 5</strong> shows the table for the changes made in the example in <strong>Fig 1</strong>, taken from the "Device Changes" report that is available in the online repository. </p><p><br></p><div style="color: #000000;background-color: #fffffe;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;" id="isPasted"><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"><br>DEVICECHANGE.DCID </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [ID],<br>DEVICECHANGE.DCDID </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Device ID],<br>DEVICECHANGE.DCDevNum </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Device Number],<br>DEVICECHANGE.DCWhen </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Timestamp],<br>DEVICECHANGE.DCWho </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Agent],<br>DEVICECHANGE.DCDSite </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Device Site],<br>DEVICECHANGE.DCOldSite </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Site - From],<br>DEVICECHANGE.DCNewSite </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Site - To],<br>DEVICECHANGE.DCFieldID </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Field ID],<br>DEVICECHANGE.dcfieldname </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Field Name],<br>DEVICECHANGE.DCOldValue </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Field - From],<br>DEVICECHANGE.DCNewValue </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [Field - To],<br>DEVICECHANGE.dcuserid </span><span style="color: #0000ff;">AS</span><span style="color: #000000;"> [User ID]<br></span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"><br>DEVICECHANGE</span></div><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRjZDJmOWE0LTlmNzYtNGY4Mi1iNzdhLTc3MWUzNzA2MzZhYiJ9.14w_WWPUDeGr9x3le9iQi56-srDwIqlJJQehEooLerc" class="fr-fic fr-fil fr-dib" width="521" height="413"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 5. Report from the devicechange table.</span></strong></p><p><br></p><p id="isPasted">"DCFieldID" shows a number that corresponds to a type of change. The below ID key shows which each of these corresponds to.</p><p><br></p><p><strong><span style="font-size: 12pt;">ID Key</span></strong></p><p id="isPasted">-1 = "User"</p><p>-2 = "Moved"</p><p>-3 = "Status"</p><p>-4 = "Assembled"</p><p>-5 = "Used in Assembly"</p><p>-6 = "Linked to Ticket"</p><p>-7 = "Passed Commission"</p><p>-8 = "Failed Commission"</p><p>-9 = "Reset Commission"</p><p>-11 = "Asset Tag"</p><p>-12 = "Note"</p><p>-13 = "Commission Date"</p><p>-14 = "Unchanged Commission"</p><p>-15 = "Attachment Added"</p><p>-16 = "Attachment Removed"</p><p>-17 = "Image Added"</p><p>-18 = "Image Removed"</p><p>-19 = "Status Changed"</p><p>-20 = "Child asset linked"</p><p>-21 = "Child asset unlinked"</p><p>-22 = "Parent asset linked"</p><p>-23 = "Parent asset unlinked"</p><p>-24 = "Sibling asset linked"</p><p>-25 = "Sibling asset unlinked"</p><p>-50 = "Created"</p><p>-51 = "Type Changed"</p><p>-52 = "Software Added"</p><p>-53 = "Software Deleted"</p><p>-54 = "Software version updated"</p><p>-55 = "Software install date updated"</p><p>-56 = "Software licence changed"</p><p>-57 = "Software licence count changed"</p><p>-58 = "Software licence role changed"</p><p>-59 = "Linked Asset relationship changed"</p><p>-60 = "Inactive"</p><p>-61 = "Teamviewer connection"</p><p>-62 = "Business Owner"</p><p>-63 = "Change Advice Board"</p><p>-64 = "Technical Owner"</p><p>-65 = "Priority"</p><p>-66 = "Supplier"</p><p>-67 = "Contract"</p><p>-68 = "Supplier Priority"</p><p>-69 = "Supplier Reference"</p><p>-71 = "Service Linked"</p><p>-72 = "Service Unlinked"</p><p>-73 = "Name"</p><p>-74 = "Status"</p><p>-75 = "Sales Description"</p><p>-76 = "Purchase Description"</p><p>-77 = "Price"</p><p>-78 = "Cost"</p><p>-79 = "Tax Code"</p><p>-80 = "Accounts Code"</p><p>-81 = "Item Group"</p><p>-82 = "Parts Warranty Start Date"</p><p>-83 = "Parts Warranty End Date"</p><p>-84 = "Labour Warranty Start Date"</p><p>-85 = "Labour Warranty End Date"</p><p>-86 = "Licence Linked"</p><p>-87 = "Licence Unlinked"</p><p>-88 = "Contract Linked"</p><p>-89 = "Contract Unlinked"</p><p>-90 = "Taxable"</p><p>-91 = "Recurring Price"</p><p>-92 = "Recurring Cost"</p><p>-93 = "Not Consignable"</p><p>-94 = "Item Project Template"</p><p>-95 = "Do not receive on Purchase Order"</p><p>-96 = "Budget Type"</p><p>-97 = "Manufacturer SKU"</p><p>-98 = "Is a Contract"</p><p>-99 = "Don't Invoice on Sales Orders"</p><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;">Optimising Device Change history</span></strong></p><p><span style="font-size: 11pt;">You can turn on the setting "Use optimised Device Change history retrieval method", found in </span>Configuration > Asset Management > General Settings to allow performance improvements to Device Change History to be enabled.</p><p><em><strong><span style="font-size: 11pt;"><br></span></strong></em></p><p><strong><em><span style="font-size: 11pt;">Note: This should only be enabled for Databases created after June 2025.</span></em></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImMyNGI3ZjBkLTc4M2YtNDBkNS1iMGYyLTk1MWM3YzhmMzI2OSJ9.aVseZJzWosmogU0aFPEfTJy_93Nhj-dJvj9c7z_sbS4" class="fr-fic fr-fil fr-dib" width="894" height="886"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 6. Optimised Device Change history retrieval method checkbox.</span></strong></p>
