How to Standardize your IT Controls Testing with DataSnipper

Learn how to use DataSnipper to create standardization for your IT Controls Testing using Snips and Form Extraction, ex. User Account Deprovisioning

Video Tutorial

Example

Here you can download the workbook shown in the video including all of the sample data and documents.

IT Control Testing - Example

Template

Here you can download a blank version of the workbook shown in the video to use or customise for your own procedures. 

IT Control Testing - Template

Prerequisites

• Relevant IT tickets 
• Set of User Accounts
• Professional or Enterprise Package

Start procedure

1. Start by creating an Excel workbook to document your testing and import the necessary documents 
   
2. Click on the "Form Extraction" button in the Document Extraction drop-down. 
3. Select "Start new form extraction" and choose the documents to use. In this case, it'll be the IT Tickets imported. 
   
4. Add extraction for each piece of relevant information you need to extract, i.e., "Ticket ID", "Full Name", "Termination Request Date", "Ticket Creation Date" and "Termination Date", and name each extraction accordingly.
   
5. Click on "Export to Excel" and a new Form Extraction tab will appear with your snips.
   
6. Copy the snips into your control testing Excel template and use Validation or Exceptions Snips to confirm if indeed the user access has been removed.