defcon.klaxon
Lifetime Supporting Member
Hi guys,
A new client has an existing system that works just fine (surface water plant) but they had a falling out with the previous integrator and they're a bit lost, trying to get everything sorted. My specific task is to help them figure out how to access the data needed for the reporting they send into the water quality agency. Apparently the previous integrator would remote in, grab the raw data, and provide it to the operators. Maybe so he could bill monthly maintenance, I don't know...I know very little about SQL but I believe you can create scripts that would do this for you; point is, I'm trying to figure out how to access the data in SQL as easily as possible so that the operators don't need me to do it for them.
I've taken a look at the system, lo and behold in SQL there is a table called "State Reporting" and it has several tags like flow rates, CL2 residuals, turbidities, and the like. So that is easily found, but when I try to extract data through the wizard I find that there is no way for me to specify date range for the data I'm trying to grab. It simply creates a spreadsheet with several months of data from the year 2014. So I don't know if the SQL server is currently running and saving data or if there's an error somewhere, and if it is currently running, how to access the data for just the month I'm interested in.
I've been searching around and have some some info that is a bit helpful but the date range still has me scratching my head. Could anyone provide some info that could help me, a total SQL noob, to understand how to interact with the database? Until now all my work with SQL has had some software intermediary (like Dream Report) so I haven't had to deal with the database directly. Thanks for any help!
A new client has an existing system that works just fine (surface water plant) but they had a falling out with the previous integrator and they're a bit lost, trying to get everything sorted. My specific task is to help them figure out how to access the data needed for the reporting they send into the water quality agency. Apparently the previous integrator would remote in, grab the raw data, and provide it to the operators. Maybe so he could bill monthly maintenance, I don't know...I know very little about SQL but I believe you can create scripts that would do this for you; point is, I'm trying to figure out how to access the data in SQL as easily as possible so that the operators don't need me to do it for them.
I've taken a look at the system, lo and behold in SQL there is a table called "State Reporting" and it has several tags like flow rates, CL2 residuals, turbidities, and the like. So that is easily found, but when I try to extract data through the wizard I find that there is no way for me to specify date range for the data I'm trying to grab. It simply creates a spreadsheet with several months of data from the year 2014. So I don't know if the SQL server is currently running and saving data or if there's an error somewhere, and if it is currently running, how to access the data for just the month I'm interested in.
I've been searching around and have some some info that is a bit helpful but the date range still has me scratching my head. Could anyone provide some info that could help me, a total SQL noob, to understand how to interact with the database? Until now all my work with SQL has had some software intermediary (like Dream Report) so I haven't had to deal with the database directly. Thanks for any help!