Endpoint Protection

 View Only

  • 1.  Scheduled Reports output automatically to a file?

    Posted May 23, 2008 02:55 PM
    Reading through the reporting administration guide it is really unclear whether it is possible to output a scheduled weekly report to a file that can later be emailed to a distribution list. What I am wondering is if anyone has a report setup on a schedule that atleast saves the report as a file as the output? I know you can run a report and "File - Save As" through a web browser, I am looking for something more automated than this however. If it matters the version of Reporting Snap-in addon that I am using is 1.0. Thanks in advance.


  • 2.  RE: Scheduled Reports output automatically to a file?

    Posted May 27, 2008 02:40 PM
    It was a bummer to find out you could create scheduled reports, but couldn't email them or dump them to file.  Since the data is inside of an sql database I'm writing a script to pull some of the info out.  I'll post it when I'm done.


  • 3.  RE: Scheduled Reports output automatically to a file?

    Posted May 27, 2008 03:32 PM
    That is what I figured after playing with it some more, that is really quite useless to even have a scheduled reporting feature if you can't email/distribute the reports! Let me know how the scripting goes, thanks. Mike


  • 4.  RE: Scheduled Reports output automatically to a file?

    Posted May 30, 2008 10:19 AM
    We'll do..


  • 5.  RE: Scheduled Reports output automatically to a file?

    Posted Jun 02, 2008 12:30 PM
    I've decided to try and teach myself how to use SQL to a point, I've got everything setup on my local machine but I am wondering which DB I should attach locally from the SAV server? I copied and attached the Reporting.mdf but I am not sure it has the information I am looking for? Thanks, Mike


  • 6.  RE: Scheduled Reports output automatically to a file?

    Posted Jun 02, 2008 04:27 PM
    It depends on what you named the database.  I just kept the defaults and named mine reporting.
     
    BTW, I'm almost finished with the script, unfortunately I don't have much time I can devote to it right now, but am steadily finishing it day by day when I do have time..


  • 7.  RE: Scheduled Reports output automatically to a file?

    Posted Jun 02, 2008 04:41 PM
    Ok so I have copied and attached the correct one, I can find most of the information I would expect to see under "dbo.inventory" however I cannot seem to find the column that would represent the virus definition version which is probably the information I am most interested in...Any hints?


  • 8.  RE: Scheduled Reports output automatically to a file?

    Posted Jun 06, 2008 05:58 PM
    You actually have to look at dbo.pattern to find that.  Here's my script I had mentioned..