Jump to content
dane300

A way to email a dataview?

Recommended Posts

What about export the dataview to Excel then email the file to you hourly?

Does that work for you? if yes I can help you making that

Share this post


Link to post
Share on other sites

Yes, you can by scheduling the script hourly.

 

initially, I'll try to create a script for you that pulls the dataview you want from your LT DB and exports it to Excel (.csv) then sends it to your email.

You will have to schedule this script hourly, or however you want. You will also be able to add\remove emails.

 

Which dataview are you looking to get emailed?

Share this post


Link to post
Share on other sites

The que scripts...... All I really need is the total number of script currently running or que emailed to me if there is a different way beside dataview

Share this post


Link to post
Share on other sites

I don't know if there is a way to email any dataview(s), but I can create for you a script to email the information from both dataviews you mentioned (Running Scripts, Queued Scripts ).

Considering my time, I hope I will be able to create and attach them today for you.

Share this post


Link to post
Share on other sites

Ok, here is the script, It pulls the information from both dataviews for the running and queued scripts into one list, I also added the running scripts "step", and column "client\location" for easier finding since we won't be able to right click and "Open The Agent" as in dataviews.

After importing the script, 1st you will need to change the "Global Variables" to write your email, and your LT server ID to insure that the script will run ONLY against LT Server.

 

Everytime the script runs it sends email with attachment, The attached CSV file should look like:

 

The script attached. Hope it fits your needs.

Try to test before schedule it and please let me know if there is any question, or if you need more\less fields (columns) in it.

Capture.JPG.ad3a9e77780cbc17bca66340d247394d.JPG

Untitled.jpg.f8eea23b227378b133d7c4cab203be2d.jpg

Running n Queued Scripts.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×