From Date and To date
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
From Date and To date
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);
- Attachments
-
- 1 Capture.PNG (65.4 KiB) Viewed 1772 times
-
- 2 Capture.PNG (12.23 KiB) Viewed 1772 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: From Date and To date
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
Re: From Date and To date
Hi Thanks for the replay,
Please find the sample report and help me please.
Please find the sample report and help me please.
- Attachments
-
- Test login statistic Report.mrt
- (30.62 KiB) Downloaded 119 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: From Date and To date
Hello,
Please send us a test data for your report.
Thank you.
Please send us a test data for your report.
Thank you.
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
Re: From Date and To date
Hi,
Please find the test data for reference, its showing only 100 rows
Do i need to do anything related to browser like cache.
Please find the test data for reference, its showing only 100 rows
Do i need to do anything related to browser like cache.
- Attachments
-
- Report (2).docx
- (7.8 KiB) Downloaded 104 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: From Date and To date
Hello,
It is not possible to use word document as data in your report.
Please send us a sample that reroduces the issue for anlaysis.
Thank you.
It is not possible to use word document as data in your report.
Please send us a sample that reroduces the issue for anlaysis.
Thank you.
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
Re: From Date and To date
How to send test data, which format is needed to test the data, can you please explain so i will send you according to you
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: From Date and To date
Hello,
Any format - XML, JSON, etc, that we can use in your report and reproduce the issue.
Thank you.
Any format - XML, JSON, etc, that we can use in your report and reproduce the issue.
Thank you.
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
Re: From Date and To date
Please find the sample data and help me
- Attachments
-
- Sample.xlsx
- (12.74 KiB) Downloaded 109 times
-
- Posts: 27
- Joined: Wed Jul 22, 2020 1:11 pm
Re: From Date and To date
Please find the sample data and help me
- Attachments
-
- AnyConv.com__Report (2).xml
- (19.27 KiB) Downloaded 109 times