Desktop User Guides > Interviewer > Viewing log information > Viewing logs > Examples using DM Query with DataCollectionAudit_Analysis.ddf
 
Examples using DM Query with DataCollectionAudit_Analysis.ddf
Viewing all records in DataCollectionAudit_Analysis.ddf
select * from hdata
Viewing all cases for a specific project
select * from hdata where AuditProject = ‘PROJECTNAME’
Viewing all initial data entry cases worked on by a specific user
select AuditUser, ^.AuditProject as AuditProject, ^.AuditDataFile as AuditDataFile, AuditCollectionMode, AuditOperation,
AuditStartTime, AuditFinishTime, AuditEntryCount, AuditValidationCount, AuditWorkstationId, AuditWorkstationUser, ^.AuditCaseId
as AuditCaseId, AuditCaseStatus, AuditText from hdata.AuditCollection where AuditUser = ‘USER’
Viewing all completed initial data entry records for a project entered by a specific user
select AuditUser, ^.AuditProject as AuditProject, ^.AuditDataFile as AuditDataFile, AuditCollectionMode, AuditOperation,
AuditStartTime, AuditFinishTime, AuditEntryCount, AuditValidationCount, AuditWorkstationId, AuditWorkstationUser, ^.AuditCaseId
as AuditCaseId, AuditCaseStatus, AuditText from hdata.AuditCollection where (AuditOperation = {Initial}) AND (AuditCaseStatus =
{Completed}) <> -1) AND ^.AuditProject = 'PROJECTNAME' AND AuditUser = 'USER'
Viewing the total number of times questions where answered in initial data entry mode for a project entered by a specific user:
select Sum(AuditEntryCount) from hdata.AuditCollection where (AuditOperation = {Initial}) <> -1) AND ^.AuditProject =
'PROJECTNAME' AND AuditUser = 'USER'
Viewing the total number of times verification changes were accepted for a project entered by a specific user:
select Sum(AuditValidationCount) from hdata.AuditCollection where ^.AuditProject = 'PROJECTNAME' AND AuditUser = 'USER'