Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Chris Bodman 8 posts 88 karma points
    Apr 17, 2018 @ 09:56
    Chris Bodman

    Query SQL for valid tokens

    Hi Everyone,

    So if we have sent out a load of tokens, is there a way to find out how many of those tokens are still valid, either by date generated or a bool somewhere?

    The idea being, I'd like to have a report to say how many of X tokens sent are still valid, and not used.... So valid token and Len(Password)<1.

  • pranjal 75 posts 186 karma points
    Apr 17, 2018 @ 11:13

    i am not getting your issue please elaborate what you need to do expire a token or what???????

  • Chris Bodman 8 posts 88 karma points
    Apr 23, 2018 @ 09:35
    Chris Bodman

    I want to be able to find out how many tokens that have been sent out haven't been used yet but are still valid.

    For instance, if I've sent out 100 tokens with a 48 hour expiration. If 50 of them were used, after 36 hours I'd expect to see 50 still valid. If no other tokens were used, after 49 hours, I'd expect to see 0 tokens valid.

Please Sign in or register to post replies

Write your reply to: