PSQUERY App Engine email query results
Forum » Forum / Help » PSQUERY App Engine email query results
Started by: melbanmelban
On: 1271945918|%e %b %Y, %H:%M %Z|agohover
Number of posts: 4
rss icon RSS: New posts
Summary:
I want to have the PSQUERY app engine email the XLS or CSV file when the process completes
PSQUERY App Engine email query results
melbanmelban 1271945918|%e %b %Y, %H:%M %Z|agohover

I want to have the PSQUERY app engine email the XLS or CSV file when the process completes. Right now you have to go out and download the files from the process monitor logs page. You can setup the be notified of the process completion but not receive the files created since this is an App Engine and not an SQL or Crystal. Any ideas?

Reply  |  Options
Unfold PSQUERY App Engine email query results by melbanmelban, 1271945918|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Kathy (guest) 1277783667|%e %b %Y, %H:%M %Z|agohover

Did you get any further with this? we are trying to do the same thing, we have gone into distribution selected "Email Web Report" and entered in email address… process completes sucessfully but no email generated. If you have got any further than this please let me know.

Thanks

Reply  |  Options
Unfold Re: PSQUERY App Engine email query results by Kathy (guest), 1277783667|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Kathy (guest) 1278296995|%e %b %Y, %H:%M %Z|agohover

Hi Melban - we found our issue to this, there is SMTP settings in the psprcs.cfg that had not been configured NOTE you have to set the SMTPSourceMachine to the machine name.
Hope this helps anyone that comes across this issue.

Reply  |  Options
Unfold Re: PSQUERY App Engine email query results by Kathy (guest), 1278296995|%e %b %Y, %H:%M %Z|agohover
Re: PSQUERY App Engine email query results
Matt (guest) 1279766787|%e %b %Y, %H:%M %Z|agohover

The following URL provides an example of how to achieve this, although additional work is required to make it suitable for releasing to production around who is emailed the query result.

How to email scheduled psquery results

As mentioned in the comments to the blog this functionality is available in Tools 8.5

Reply  |  Options
Unfold Re: PSQUERY App Engine email query results by Matt (guest), 1279766787|%e %b %Y, %H:%M %Z|agohover
New Post
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License