Jump to content
Sign in to follow this  
mgragen

script to run a report from Report Center

Recommended Posts

Has anyone had any luck on creating a script to run certain reports (Executive Summary, AntiVirus Health, etc.) from within Report Center? The user that would be running this script would not have Report Center permissions so it would need to be emailed and or exported out in any format.

Thanks in advance!

Share this post


Link to post
Share on other sites

I use a script to schedule a report automatically, but I'm not sure about a one off report. Basically what I did was turn on SQLSpy, then schedule a report, and look at all the SQL commands. It's quite complicated, but in the end you should only need to run two SQL commands. One to create the schedule, and another to add the report to the schedule. The problem would be scheduling I assume. But if you could schedule it to run once, then have a nightly script(or a script that was automatically scheduled during the run of the first script) to delete the scheduled script after the first scheduled run.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...