>From my local documentation: YESTERDAY ONAIR ONLY: select ELR_LINES.CART_NUMBER, ELR_LINES.EVENT_DATETIME, ELR_LINES.LENGTH, ELR_LINES.TITLE, ELR_LINES.ARTIST, ELR_LINES.ALBUM, ELR_LINES.CUT_NUMBER, CART.GROUP_NAME, CART_SCHED_CODES.SCHED_CODE from ELR_LINES left join CART on ELR_LINES.CART_NUMBER=CART.NUMBER left join GROUPS on CART.GROUP_NAME= GROUPS.NAME left join CART_SCHED_CODES on ELR_LINES.CART_NUMBER=CART_SCHED_CODES.CART_NUMBER where SERVICE_NAME='Production' AND EVENT_DATETIME > DATE(SUBDATE(CURDATE(),1)) AND EVENT_DATETIME < DATE(CURDATE()) AND ONAIR_FLAG='Y' AND GROUPS.REPORT_MUS='Y' order by EVENT_DATETIME INTO OUTFILE '/tmp/yesterday.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';
On Sat, Feb 11, 2023 at 7:24 PM David Klann <[email protected]> wrote: > Hi Ivan, > > Like Eric, I have a script that I run that "augments" the built-in > Rivendell reports (see link below). > > There are two steps to making Rivendell reports work (apologies if you > already know and understand these): > > - define the reports in RDAdmin > Manage Reports > in the box labeled "Export Path" I always specify the full path > (e.g., /home/rd/Desktop/Reports/report-name-%Y-%m-%d.txt) > Make sure to pay attention to the "Source Services" and the > "Source Hosts". These refer to the entities on which you wish > to report. > > - generate reports in RDLogManager > Manage Reports > The dates default to the current date, so you'll want to change (at > least) the starting date to get something meaningful. > > The script I wrote was originally intended to be run weekly, so that's > its name... It's a pretty long shell script (Z-Shell), you can see how > to run it with "weekly-report-rd3 --help". > > See the code on sourcehut (https://sr.ht/) at > > http > s://git.sr.ht/~dklann/ram/tree/master/item/usr/local/bin/weekly-report-rd3 > > Hope this helps! > > ~David Klann > > > On 2/11/23 17:41, [email protected] wrote: > > > > Eric, > > Do you have a sample script that you can share > > Thanks > > > > On 2023-02-11 16:06, Eric Adler wrote: > >> I run an sql query as a cron job nightly with csv export that > >> automatically emails. Two really, checking the music flag so the > >> reports go to different people. > >> > >> On Sat, Feb 11, 2023, 3:48 PM <[email protected]> wrote: > >> > >>> Good Afternoon Community. > >>> I was wondering if any one has have any experience with Generating: > >>> 1.log reconciliation report. > >>> 2. Or Report That tells when the carts ran. > >>> > >>> I have tried to configure the reports The Rdadmin/Reports/Manage > >>> Reports. > >>> I don't see anything in rd/admin/ services > >>> Does anyone have an idea how to get this report.. I have a second > >>> question But I will Its about Converint Databases. post > it as a > >>> separate > >>> Thread.. > >>> > >>> Thanks > >>> Ivan > >>> _______________________________________________ > >>> Rivendell-dev mailing list > >>> [email protected] > >>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > > -- > > **********************NOTICE***************************************** > > This email is intended only for the person or entity to which it is > > addressed to in this email and it may contain information that is and > > would be considered privileged,confidential or otherwise protected from > > disclosure by recipient. > > Dissemination, distribution or copying of this e-mail or the > > information herein by anyone other than the intended recipient,or an > > employee or agent responsible for delivering the message > > to the intended recipient, is prohibited. If you have received this > > e-mail in error or would like not to receive future emails from > > jamcorbroadcast.com, please immediately notify us by forwarding this > > > email to [email protected] > > _______________________________________________ > > Rivendell-dev mailing list > > [email protected] > > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
