Create report to list enrolled OneTouch users

This document is written for PhenixID Server.

The reader should have some basic knowledge about PhenixID Server.

This document describes how to create a report to view enrolled OneTouch users.  

Create report json file

- Create a json file, ot_assigned.json, with this content:

{
    "displayName": "Enrolled OneTouch",
    "category": "Custom",
    "description": "Enrolled OneTouch",
	    "query": "select assignedTo,expires,device_ref from tokens where (device_ref is not null) AND (serial is null) order by assignedTo"
    
} 

Place file on server

Place the file on the server (follow the instruction in this document)

 

Test

Login to Configuration Manager

Go to Reports

Click Custom -> Enrolled OneTouch