Query filters
  • 08 Jan 2025
  • 2 Minutes à lire
  • Sombre
    Lumière
  • PDF

Query filters

  • Sombre
    Lumière
  • PDF

The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article

Queries can be defined from user, authenticator, and audit data fields. The fields listed below are available for selection when you define a query.

Query fields

The user query fields can be referred to in the XSLT templates.

Table: Query fields – User
Display nameData typeAccepted values
User:Back-End AuthenticationString
  • Default
  • None
  • If Needed
  • Always
User:Created timeDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
User:DescriptionString 
User:DisabledBoolean
  • 0
  • 1
User:DomainString 
User:EmailString 
User:Expiration DateDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
User:Has DigipassString
  • Assigned
  • Unassigned
User:Last AuthenticationDate 
User:Local AuthenticationString
  • Default
  • None
  • Digipass Only
  • Digipass/Password
  • DIGIPASS or Password
User:Lock CountNumber 
User:LockedBoolean
  • 0
  • 1
User:MobileString 
User:Modified timeDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
User:Organizational UnitString 
User:PhoneString 
User:StatusString 
User:User IDString 
User:User NameString 
User Attributes:*String 
Table: Query fields – Authenticator
Display nameData typeAccepted values
Digipass:Application NamesStringComma-separated list of authenticator application names.
Digipass:Application TypesStringComma-separated list of authenticator application types.
Digipass:AssignedDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss

Digipass:Backup VDP Enabled

String

  • Default
  • No
  • Yes – Permitted
  • Yes – Required
  • Yes – Time Limited
Digipass:Backup VDP ExpiresDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Digipass:Backup VDP Uses LeftNumber 
Digipass:Created timeDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Digipass:DescriptionString 
Digipass:Digipass TypeString5-character code.
Digipass:DomainString 
Digipass:Expiration DateDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Digipass:Grace Period EndDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Digipass:Modified timeDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Digipass:Serial NumberString 
Digipass:StatusString
  • Assigned
  • Unassigned
Digipass:User IDStringUser ID of the user the authenticator is assigned to.
Table: Query fields – Audit
Display nameData typeAccepted values
Audit:ActionString 
Audit:AMIDString 
Audit:ApplicationString 
Audit:AreaString 
Audit:Back-End AuthenticationString 
Audit:CategoryString 
Audit:CharacteristicsString 
Audit:Client DescriptionString 
Audit:Client LocationString 
Audit:Client TypeString 
Audit:CodeStringFor a list of possible codes and messages used by the audit system, see  Audit messages.
Audit:CommandString 
Audit:Configuration DetailsString 
Audit:CredentialsString 
Audit:Data SourceString 
Audit:Data Source LocationString 
Audit:DescriptionStringFor a list of possible codes and messages used by the audit system, see Audit messages.
Audit:DowntimeNumber 
Audit:Error CodeNumberFor a list of error codes used by OneSpan Authentication Server, see Error messages.
Audit:Error DetailsStringFor a list of error codes used by OneSpan Authentication Server, see Error messages.
Audit:Error MessageStringFor a list of error codes used by OneSpan Authentication Server, see Error messages.
Audit:Expiration DateDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Audit:FieldsString 
Audit:FromString 
Audit:Input DetailsString 
Audit:IP AddressIP Address

Required. Valid IPv4 address range using CIDR notation to filter audit messages, if the client IP address is either within the specified address range or not.

Can be used with the following conditions only:

  • is part of
  • is not part of
Audit:Local AuthenticationString 
Audit:MessageStringFor a list of possible codes and messages used by the audit system, see Audit messages.
Audit:ObjectString 
Audit:OperationString 
Audit:OutcomeString 
Audit:Output DetailsString 
Audit:Password ProtocolString 
Audit:Policy IDString 
Audit:QuotaNumber 
Audit:RADIUS Octets InputNumberThe number of bytes sent by the user.
Audit:RADIUS Octets OutputNumberThe number of bytes received by the user.
Audit:RADIUS Status TypeStringThe audit function performed, e.g. start, stop, update.
Audit:ReasonString 
Audit:Request IDString 
Audit:Request TypeString 
Audit:Server LocationString 
Audit:Session IDString 
Audit:Session TimeNumberHow long the user has been connected, in seconds.
Audit:SourceString 
Audit:Source LocationString 
Audit:TimestampDate

Format:

  • yyyy-mm-dd hh:mm:ss
  • yyyy/mm/dd hh:mm:ss
Audit:ToString 
Audit:TypeString 
Audit:Type codeNumber 
Audit:User LocationString 
Audit:VersionString 

Two or more values after the operator will be interpreted as if the word 'and' is between them (logical AND).

Date field queries

Any query field, which is a date field can have the following filter applied to it.

Use one of the following operators:

  • is less than or equal to
  • is greater than or equal to

Then specify one or more days, weeks, or months from now, where now is taken to be the current date.

The filter must be in the following format:

  • 1 day from now
  • 6 weeks from now
  • 5 years from now

You need to use the exact spelling and the exact number of spaces. The number must be a numeric character. The filter is not case-sensitive.

The words from now can be replaced with ago. For example, the following term will select information 3 years old or older:

is greater than or equal to 3 years ago


Cet article vous a-t-il été utile ?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Ozzy, facilitant la découverte de connaissances grâce à l’intelligence conversationnelle