I'm using the below query to get the status of the mail sent.
select createdate, toaddress, subjectofemail, status from emailhistory where status in (5,15,404)
In SQL Builder(Data analyzer) = I'm getting the record.
But when I'm trying to implement it in Analytics I'm getting the below message, which is not allowing me to generate a report
Solved! Go to Solution.
The purpose of my query is to identify, which emails have not been sent yet
select createdate as 'emailsentdate', toaddress, subjectofemail, status as state from emailhistory where status in (5,15,404)
By using the above query as well, I'm getting zero records.
Other reports are fine, I'm able to create a new report with records
One test report result
Could you please help me with the steps, how I can verify whether ES Analytics Service is UP or not?
Since you have createdate column in report its throwing error
We tried validating the same in SSM v5.5 SP3.11, We don't see any issue if we are accommodating the createdate at first instance. Not sure if this is identified issue in lower version?