From Date and To date
Posted: Tue Jul 28, 2020 7:18 am
Please help me,
I am trying to filter the data based on from date and to date.
Please check the bellow filter condition and my query
after adding the filter condition the data is not showing in the report.
(userstat.actiondate >= fromdate) && (userstat.actiondate <= todate)
{userstat}select distinct time_stamp as actiondate,user_name as username ,event_description as action,event_name as actiontype from dm_audittrail where event_name in ('dm_connect','dm_disconnect','d2_connect') and user_name not in ( 'dm_bof_registry','DCTM Reports','d2_mail_method' ) and user_name not like 'dm\_%' ESCAPE '\' and user_name not like 'd2\_%' ESCAPE '\' and user_name not like 'c2\_%' ESCAPE '\' and (string_1 in ('inline password','ldap','OS password') or event_description='Logoff' ) and user_name is not nullstring order by time_stamp desc ENABLE(RETURN_TOP 1000);
I am trying to filter the data based on from date and to date.
Please check the bellow filter condition and my query
after adding the filter condition the data is not showing in the report.
(userstat.actiondate >= fromdate) && (userstat.actiondate <= todate)
{userstat}select distinct time_stamp as actiondate,user_name as username ,event_description as action,event_name as actiontype from dm_audittrail where event_name in ('dm_connect','dm_disconnect','d2_connect') and user_name not in ( 'dm_bof_registry','DCTM Reports','d2_mail_method' ) and user_name not like 'dm\_%' ESCAPE '\' and user_name not like 'd2\_%' ESCAPE '\' and user_name not like 'c2\_%' ESCAPE '\' and (string_1 in ('inline password','ldap','OS password') or event_description='Logoff' ) and user_name is not nullstring order by time_stamp desc ENABLE(RETURN_TOP 1000);