Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2014-05-22 : 22:14:25
|
| Hi, I have a project that assign to me to do an automation of production Dashboard.This dashboard will be installed in 10 different lines and the result will be displayed or showto 32" LCD monitor. THe result will be a real time or maybe delayed fo a few minutes.In production, it composed of 10 lines, In every lines will be monitored how the production output is being done, so that in case there will be a deficit or gap they can heads up the operator to speed up the line output.1. The data is coming from SQL Database.2. The Dashboard composed of 3 to 5 pages with different process from quality, output, performance.3. It should be scrolled down. can setup the timer to scroll down the pages to be displayed.4. This will be installed in 10 different lines.5. The data displayed in the Dashboard is realtime or it can be setup the extraction using timer.My Question is what particular software/application should be used to create this dashboard?Will be this work in SSRS? Any idea guys? Thank you very much.Jov... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-23 : 11:33:48
|
| At my previous company, the NOC used Sitescope for things like this.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2014-05-25 : 21:43:02
|
| Hi tkizer,Can you give me an overview how this Sitescope perform.How can i pull the data in SQL server using Sitescope?Is this compatible in MS SQL? Maybe this is a third party software to deploy and operate the dashboard in LCD monitor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-26 : 20:04:15
|
| I can't provide even an overview of it as I had no interaction with it. The NOC completely handled it. Yes it supports MS SQL Server as well as many other technologies.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2014-05-26 : 21:57:14
|
| btw, what is NOC? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-26 : 22:05:16
|
| NOC=Network Operations CenterI am summarizing and from only a DBA's point-of-view...It's a group within IT that monitors the production environment 24x7. They use various monitoring tools, such as Sitescope, to monitor production, check for issues and alert as needed.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2014-05-29 : 00:49:58
|
| Hi tkizer,I got an info that it can be done in SSRS. i have to build it in SSRS to create the reports. use the web browser to displayed in LCD monitor. to open the ssrs link they said to use a script to open the ssrs link and also the scheduled on how to displayed it in web browser. |
|
|
|
|
|
|
|
|
Dashboard Automation