Thanks guys...

I'll give your script a go Phil... thanks...

Joel, I'm not sure what the plan might be for developing an 'import' feature for this, but perhaps just something simple like extending the csv export/import for data points with some more columns.... you could cover the case for multiple event detectors by just duplicating rows for the data point (it could update/ignore and add the extra event detectors at the same time). Programmatically, that would hopefully be simple to implement.

Cheers!
-Shaun

Thanks Joel,

I'll keep that in mind!

Cheers!

Hi Joel,

That sounds good... I can create a data source per logical 'group' to query values - this will probably speed up templating the whole thing, and spreading the queries across multiple connections will help things scale too I think..

The number of results can vary depending on the query... we can change the query to return a single data point "current value" or a list of variables/values relevent to the device we are querying data for.

The queries would probably run once per minute, and there could be up to 1000 data points, so that'd be ~17 data points updated per second as a ballpark guess.

This would grow over time and in its final state (after a few years of growth) could be about 4x this.

Hi,

I'm writing up a proposal for a client... they have a Kepware OPC server that has a MS-SQL database back end that is fed data from their Siemens control system...

The client has said that he would like us to look at querying the MS-SQL database directly for all the values for the system... His intention is to replicate the SQL DB from their secure network to a DMZ for us to talk to - providing better isolation given this system will be exposed to the internet.

1. Is there any limitations or scalability issues with query for thousands of values via a database connection?
2. Does Mango keep a connection alive per data source and issue all the defined queries across that link, or does it connect, authenticate, query, disconnect?

Is there a better way to query an OPC server for this kind of data?

Cheers!
-Shaun

Hi @JoelHaggar, @phildunlap
Thanks for the help...

Joel, we'd be looking to implement as soon as the feature was available :)
If its not too much trouble, please let me know when this is ready for testing - I'd be happy to test this ahead of a production release!

As for permissions, if you did have the ability to permit changes to event detectors separate to data points, that would give some extra security and protection from users, but it would probably be fine to give them edit permission to the data point.

Phil, this sounds like it might be an option for us in the event that our customer requires us to have this implemented before the work Joel talks about is ready.

Thanks
Shaun

Hi,

I need to give a customer access to edit event detector threshold values via a dashboard.

Is there a way I can do this?

Is there something in the API I can use for this, or even an example I could look at?

Ideally it'd need to be dynamic so something like, for a given device, list all the event detectors that exist so you can select one and edit it.

Thanks
Shaun

Thanks @Jared-Wiltshire :)

Hi All,

I have a project with a requirement for many users (potentially several hundred) to access dashboards, where each user might receive a different view based on a set of rights (group membership?).

I know I can create many user accounts and groups within Mango, but given there could be several hundred users to manage, I'd like to use an external system for authentication and possibly group membership/rights management such as Active Directory, Google, Facebook etc.

Alternately, if we do use Mango's internal user/group management system, what are the practical limits? Is there access via the API to manage user accounts so I can author a management system that would ideally also include 'ooops, I forgot my password' functionality?

Cheers!
-Shaun

If you're running any software on a computer that others have access to login to or to the file system, you're already at a disadvantage if you're trying to minimise or control access.

Ultimately, if you have R/W access to files on the disk or the memory of the computer/server running any software, you can reset passwords, or use other methods to break in - like reading passwords out of active memory, stack tracing, or other available "debugging" methods.

A vendor can bake in some kind of 'protection' so you can lock a system down (like non-resettable admin passwords), but ultimately these are just a deterrent - with some effort, this kind of thing can often be overcome. As an example, Mitsubishi Alpha PLC passwords are easily discovered if you know what area of memory to read from their config tool when it 'tests' the password you enter. Ask me how I know ;p

The best approach to protect your work is to deploy as a 'black box' type system. You run on a MangoES, Separate physical server, or Virtual Machine, where you give your client only the minimum access required to use the system such as a less privileged user to login via web browser only to a dashboard. This also gives you the opportunity to sell them 'support' on either per-incident or subscription basis for the deployment.

Hope this helps!

Cheers!
-Shaun

Oh! @phildunlap I didn't realise thats what that button was for.. haha!

Thanks again, and thanks very much for the script too!

Cheers!
-Shaun

Thanks for the details guys...

I'm familiar with the CSV export from the data points/sources page, but that doesn't give you the event detectors that I can get from the config export.

When I build a reusable template based on json config I usually include the data source, data points, event detectors, event handlers, and the point hierarchy... I try to make it as complete as possible.

Most of the deployments I work on have many of the same device, so fast duplication with just changes of names, IPs, modbus IDs etc makes life easy.

I'll have to explore the API and scripting as you both suggest soon!

Cheers!
-Shaun