search cancel

DQU query to list all users who signed on to CA Dataquery this year

book

Article ID: 134187

calendar_today

Updated On:

Products

Datacom

Issue/Introduction

I want to query the CA Dataquery User table DQU to obtain a list with all DQ USERS who have used Dataquery in 2019.

How can I do that?



Environment

Release : 15.0

Component : CA Dataquery for CA Datacom

Resolution

Run DQL query


 FIND DATAQUERY-DQU ROWS WITH (F00092-00032 = '#############/19################')

  PRINT FROM DATAQUERY-DQU USER-NAME F00092-00032



Additional Information

If DQOPTLST LITMASK is another character than # then use that masking character .