Software 101 – Database Part 1
Restore Archived Assessments
Behavioral Assessments
1. Open up SQLQuery
2. Run BA search by name or email address
3. When the results populate, find the archived assessment. The ‘SurveyUserStatus’ will say ‘Archived’ for the assessment you need to restore.
4. Copy the ‘SurveyUserID’ from the archived assessment.
5. Using the following stored procedure, insert the ‘SurveyUserID’ between the red single quotes
- exec [Support].[Restore_Archived_SurveyUser] ‘SurveyUserID’
6. Highlight the procedure and click ‘Execute’
7. You should receive confirmation that the assessment has been restored.
8. Approximately five minutes later, check in the software to ensure the assessment has been restored.
Cognitive Assessments
1. Open up SQLQuery
2. Run ‘FindCognitiveAssessment’ query:
- exec [Support].[FindCognitiveAssessment] ‘assessmenttaker@company.com’
3. Take the CognitiveID and SurveyUserID from the results and enter them into the following stored procedure and run it to restore the cognitive assessment.
- exec [Support].[RestoreCognitiveAssessment] ‘CognitiveID’, ‘SurveyUserID’