[sander]

Is it possible to see when users activation passwords will expire and whether they have tried to use them. We have a large number of users who just got new phones and I want to make sure they have activated them, so I thought I could look to see if they have an outstanding code.

[jibi]

Try to set it again. If it hasn't been activated, it will show a password (first field only) and how many hours are left. If it has been activated or has expired, it will display as if you were setting a new one (48 hours and blank fields).

[sander]

Wirelessly posted

Any other options if you have a bunch of users and don't want to open each one. I was hoping for a view.

[conwawj]

You can get this from the configuration database. You'd have to write a query to pull the data directly from SQL. If want a sample send me a private message and I'll give you a sample query.

[qc_metal]

SELECT dbo.UserConfig.DisplayName, dbo.UserConfig.UserName, dbo.UserConfig.PIN, dbo.UserConfig.KeyGenExpiryTime, dbo.UserConfig.KeyGenMaxAttempts, dbo.UserConfig.KeyGenPassword, dbo.UserConfig.KeyGenNumAttempts, dbo.UserConfig.KeyGenState FROM dbo.UserConfig WHERE keygenexpirytime > GETDATE()

Great (and useful) query!