The Device Authorizations query will provide information on requested, approved and revoked data authorizations along with associated login attempt details.

By default the 'Revoked' and any unused device authorizations will be omitted.

Report filters

The report filter are optional, in the event no filters are defined all device authorizations and linked login attempts are retrieved, however, this may significantly impact the report performance. 

Data provider settings

IncludeUnusedDeviceAuthorizations (bool; default = true)
If the setting is set to FALSE, then the device authorizations without associated login attempts are not shown (for example device authorizations (requested/approved) that were never used or device authorization with login attempts that fall outside of the provided filter range)