Possibiliy to display results SQL query in windows (monitoring purposes)
Case (one example) #1:
Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of documents to print. I can (as administrator) run that query but how can i make this possible that "normal"users can view these results also?
I am thinking to create a monitor screen on the department so everyone can see from a distance what the queue length is. Perhaps i want to add extra information like performance graphs etc, but that's future work.
Does anyone knows a product that makes this possible? The logic behind it is very simple, but i can't find a product that creates this kind of view. I hope someone can point me in a good direction.
Thanks !
monitoring sql
edited Jan 28 at 23:12
fixer1234
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
add a comment |
Case (one example) #1:
Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of documents to print. I can (as administrator) run that query but how can i make this possible that "normal"users can view these results also?
I am thinking to create a monitor screen on the department so everyone can see from a distance what the queue length is. Perhaps i want to add extra information like performance graphs etc, but that's future work.
Does anyone knows a product that makes this possible? The logic behind it is very simple, but i can't find a product that creates this kind of view. I hope someone can point me in a good direction.
Thanks !
monitoring sql
edited Jan 28 at 23:12
fixer1234
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
add a comment |
Case (one example) #1:
Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of documents to print. I can (as administrator) run that query but how can i make this possible that "normal"users can view these results also?
I am thinking to create a monitor screen on the department so everyone can see from a distance what the queue length is. Perhaps i want to add extra information like performance graphs etc, but that's future work.
Does anyone knows a product that makes this possible? The logic behind it is very simple, but i can't find a product that creates this kind of view. I hope someone can point me in a good direction.
Thanks !
monitoring sql
edited Jan 28 at 23:12
fixer1234
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
Case (one example) #1:
Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of documents to print. I can (as administrator) run that query but how can i make this possible that "normal"users can view these results also?
I am thinking to create a monitor screen on the department so everyone can see from a distance what the queue length is. Perhaps i want to add extra information like performance graphs etc, but that's future work.
Does anyone knows a product that makes this possible? The logic behind it is very simple, but i can't find a product that creates this kind of view. I hope someone can point me in a good direction.
Thanks !
monitoring sql
monitoring sql
edited Jan 28 at 23:12
fixer1234
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
edited Jan 28 at 23:12
fixer1234
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
edited Jan 28 at 23:12
fixer1234
18.8k144982
edited Jan 28 at 23:12
fixer1234
18.8k144982
edited Jan 28 at 23:12
fixer1234
18.8k144982
18.8k144982
asked May 7 '14 at 7:27
Peter OPeter O
83
asked May 7 '14 at 7:27
Peter OPeter O
83
asked May 7 '14 at 7:27
Peter OPeter O
83
83
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Possibly the easiest solution would be running some program or script of your own. It's tricky and requires coding knowledge, but it also allows you to do the most customization as well.
For example, utilizing a simple PHP page (ran on a web server), it wouldn't be that complicated (and you could lookup everything from documentation). This is just a made up example and I don't have any server to test it right now though:
<?php
$connection = mssql_connect('servername', 'username', 'password');
mssql_select_db('database', $connection);
$result = mssql_query('select count(*) as count from printer_queue;', $connection);
$data = mssql_fetch_array($result);
echo 'There are currently ' . $data[count] . 'document(s) in the printer queue.';
?>
Of course, the whole formatting etc. could be put into a full fledged/branded HTML page. You could create graphs, etc. it just requires some more programming knowledge.
While this creates a static webpage, you could make it refresh itself once every x minutes (or seconds). Then just show it in a web browser while in fullscreen and you're done.
answered May 7 '14 at 7:37
MarioMario
3,60721519
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f750686%2fpossibiliy-to-display-results-sql-query-in-windows-monitoring-purposes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Possibly the easiest solution would be running some program or script of your own. It's tricky and requires coding knowledge, but it also allows you to do the most customization as well.
For example, utilizing a simple PHP page (ran on a web server), it wouldn't be that complicated (and you could lookup everything from documentation). This is just a made up example and I don't have any server to test it right now though:
<?php
$connection = mssql_connect('servername', 'username', 'password');
mssql_select_db('database', $connection);
$result = mssql_query('select count(*) as count from printer_queue;', $connection);
$data = mssql_fetch_array($result);
echo 'There are currently ' . $data[count] . 'document(s) in the printer queue.';
?>
Of course, the whole formatting etc. could be put into a full fledged/branded HTML page. You could create graphs, etc. it just requires some more programming knowledge.
While this creates a static webpage, you could make it refresh itself once every x minutes (or seconds). Then just show it in a web browser while in fullscreen and you're done.
answered May 7 '14 at 7:37
MarioMario
3,60721519
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
add a comment |
Possibly the easiest solution would be running some program or script of your own. It's tricky and requires coding knowledge, but it also allows you to do the most customization as well.
For example, utilizing a simple PHP page (ran on a web server), it wouldn't be that complicated (and you could lookup everything from documentation). This is just a made up example and I don't have any server to test it right now though:
<?php
$connection = mssql_connect('servername', 'username', 'password');
mssql_select_db('database', $connection);
$result = mssql_query('select count(*) as count from printer_queue;', $connection);
$data = mssql_fetch_array($result);
echo 'There are currently ' . $data[count] . 'document(s) in the printer queue.';
?>
Of course, the whole formatting etc. could be put into a full fledged/branded HTML page. You could create graphs, etc. it just requires some more programming knowledge.
While this creates a static webpage, you could make it refresh itself once every x minutes (or seconds). Then just show it in a web browser while in fullscreen and you're done.
answered May 7 '14 at 7:37
MarioMario
3,60721519
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
add a comment |
Possibly the easiest solution would be running some program or script of your own. It's tricky and requires coding knowledge, but it also allows you to do the most customization as well.
For example, utilizing a simple PHP page (ran on a web server), it wouldn't be that complicated (and you could lookup everything from documentation). This is just a made up example and I don't have any server to test it right now though:
<?php
$connection = mssql_connect('servername', 'username', 'password');
mssql_select_db('database', $connection);
$result = mssql_query('select count(*) as count from printer_queue;', $connection);
$data = mssql_fetch_array($result);
echo 'There are currently ' . $data[count] . 'document(s) in the printer queue.';
?>
Of course, the whole formatting etc. could be put into a full fledged/branded HTML page. You could create graphs, etc. it just requires some more programming knowledge.
While this creates a static webpage, you could make it refresh itself once every x minutes (or seconds). Then just show it in a web browser while in fullscreen and you're done.
answered May 7 '14 at 7:37
MarioMario
3,60721519
Possibly the easiest solution would be running some program or script of your own. It's tricky and requires coding knowledge, but it also allows you to do the most customization as well.
For example, utilizing a simple PHP page (ran on a web server), it wouldn't be that complicated (and you could lookup everything from documentation). This is just a made up example and I don't have any server to test it right now though:
<?php
$connection = mssql_connect('servername', 'username', 'password');
mssql_select_db('database', $connection);
$result = mssql_query('select count(*) as count from printer_queue;', $connection);
$data = mssql_fetch_array($result);
echo 'There are currently ' . $data[count] . 'document(s) in the printer queue.';
?>
Of course, the whole formatting etc. could be put into a full fledged/branded HTML page. You could create graphs, etc. it just requires some more programming knowledge.
While this creates a static webpage, you could make it refresh itself once every x minutes (or seconds). Then just show it in a web browser while in fullscreen and you're done.
answered May 7 '14 at 7:37
MarioMario
3,60721519
answered May 7 '14 at 7:37
MarioMario
3,60721519
answered May 7 '14 at 7:37
MarioMario
3,60721519
answered May 7 '14 at 7:37
MarioMario
3,60721519
3,60721519
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
add a comment |
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Thanks for your feedback. I will get into this! Although this will take a lot of time to create (not a coding expert) and for things like graphs i probably need to create a separate DB (or table) to insert the results within a period of my graph.... Still hoping for an application/tool :)
– Peter O
May 7 '14 at 7:41
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
Just keep it simple for now. Even if it's just some preliminary solution to display any (unformatted) data. It would probably be possible to do similar things with Access for example, but I don't think there's any premade solution where you just throw in your queries and get everything. If you've got issues or question for the coding approach, just ask on stackoverflow.com. And, yes, for some timed graphs you'd most likely have to cache some data in some table/history thing.
– Mario
May 7 '14 at 7:44
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f750686%2fpossibiliy-to-display-results-sql-query-in-windows-monitoring-purposes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
