Support Forums
24hr Alarm database report & monthly bad actors

Is there a way to set up a daily report that runs back the last 24hrs of an alarm database history into an excel file?
Also, is it possible to save a "bad actors" report to an excel or CSV?

Thanks,

KC

Is there a way to set up a daily report that runs back the last 24hrs of an alarm database history into an excel file? Also, is it possible to save a "bad actors" report to an excel or CSV? Thanks, KC

Yes, but you gotta script a custom report, never understood why this isn't included.

Yes, but you gotta script a custom report, never understood why this isn't included.

That sounds like an awful lot of work.
Thank you Boonz, but I don't like this news one bit.

That sounds like an awful lot of work. Thank you Boonz, but I don't like this news one bit.

The simple,but manual, way to solve this is to open the alarm page, filter the results to a table of whatever you are looking for, and then CTRL+C copy the table before pasting it into Excel. I'm not positive about the Bad Actors report but you can CTRL+C copy pretty much any table in VTScada.

To Automate it, you can try working With the REST interface but I expect it will be much easier to do once the upcoming reports builder is relesased.

The simple,but manual, way to solve this is to open the alarm page, filter the results to a table of whatever you are looking for, and then CTRL+C copy the table before pasting it into Excel. I'm not positive about the Bad Actors report but you can CTRL+C copy pretty much any table in VTScada. To Automate it, you can try working With the REST interface but I expect it will be much easier to do once the upcoming reports builder is relesased.

Trihedral Engineering Ltd.

Ctrl-C will work for now. Looking forward to the Report Studio release.

Thanks for the response,

KC

Ctrl-C will work for now. Looking forward to the Report Studio release. Thanks for the response, KC
edited 6 days ago at 9:06 pm
50
4
3
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft