Global list of user pins
The ability to extract the user pin codes into Excel.
From time to time we will be rolling out devices into offices where the system has never been available before, as a result once the room devices are in place, user can then register their staff passes against their user pins.
However for us to supply this we have to go into each individual account and get the pin.
It would be great to be able to either a) extract all user pins for our organisation, or even better b) the ability to extract user pins based on location.
This would save us a lot of preparation time, when it comes to roll-out.
Andrew Simpson
shared this idea
-
Peter Scobbie
commented
Get support to run this SQL script on your DB (if on anything from Enterprise 3.0 onwards):
SELECT pkuserid, username, userpin FROM dbo.tbluser
Only issue is that in order for a pin to be generated, the user must have logged into the system and have generated a PIN.
I have asked support if this process could be automated in future and then the report dumped into excel from the script above would have all the detail you require.