Query logs older than certain date ?

[vilius.m]

Possible to do ?
I was able to query for certain day by using "log=201606xx*".

Thanks,
Vilius M.

 

[dicowins]

Do you mean q actlog ? for certain day? that depends on how long the actlog retention is set to. q stat will show Activity Log Retention = xx Days. Thi slimits how many days are kept in log. Then you can q actlog
BEGINDate = "MM/DD/YYYY" ENDDate = "MM/DD/YYYY" . If from Certain Time BEGINTime = "HH:MM:SS" and ENDT = "HH:MM:SS". but as I said limited to days set to retain actog.

 

[vilius.m]

No I'm talking about tdpsql here - commands like:

tdpsqlc query log=20160623*
tdpsqlc restore log=20160623*

by using * I was able to specify certain day, and I was looking for some way to specify "older than" certain date.