Sometimes auditors are asking to produce a full audit trail of the project. This usually happens when they cant find anything bad in the process but still have hopes to leave at least some comments/remarks. In order to resolve this, heres the complete project audit trail report: ESQL SELECT HIST.CHANGESET_ID, HIST.CHANGE_DATE, HIST.USER_NAME AS CHANGED_BY, HIST.ARTIFACT_TYPE_NAME, HIST.ARTIFACT_ID, HIST.ARTIFACT_DESC AS ARTIFACT_NAME, HIST.CHANGETYPE_NAME AS CHANGE_TYPE, HIST.SIGNATURE_HASH FROM SpiraTestEntities.R_HistoryChangeSets AS HIST WHERE HIST.PROJECT_ID = ${ProjectId} XSLT Project Audit Trail Change ID Change Date Changed By Artifact Type Artifact ID Artifact Name Change Type Signed Signed Not Signed As usual, please let me know if you find some bugs in the report. Your feedback is appreciated! en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/3190.aspxthreadId=3190Vladimir Plotkin (vladimir@inmarsys.com) Sometimes auditors are asking to produce a full audit trail of the project. This usually happens when they cant find anything bad in the process but still have hopes to leave at least some comments/remarks. In order to resolve this, heres the complete project audit trail report: ESQL SELECT HIST.CHANGESET_ID, HIST.CHANGE_DATE, HIST.USER_NAME AS CHANGED_BY, HIST.ARTIFACT_TYPE_NAME, HIST.ARTIFACT_ID, HIST.ARTIFACT_DESC AS ARTIFACT_NAME, HIST.CHANGETYPE_NAME AS CHANGE_TYPE, HIST.SIGNATURE_HASH FROM SpiraTestEntities.R_HistoryChangeSets AS HIST WHERE HIST.PROJECT_ID = ${ProjectId} XSLT Project Audit Trail Change ID Change Date Changed By Artifact Type Artifact ID Artifact Name Change Type Signed Signed Not Signed As usual, please let me know if you find some bugs in the report. Your feedback is appreciated! Thu, 30 Apr 2026 09:59:22 -04002026-04-30T09:59:22-04:00/Support/Forum/spirateam/reports/3190.aspx