Solved

Sending message to all users on domain regarding software upgrade with out using net send

Posted on 2008-10-23
4
301 Views
Last Modified: 2012-05-05
For those of you that work in schools, you will know about the SIMS program (Schools Information Management System) that run on SQL.
I'm trying to find a way of alerting users when we have to run patch updates / dbase upgrades as it is a pain to have to keep on working late to ensure all people are off the system.
Logic would say that as long as users are informed of the times for upgrade then there will be no problem but in reality the site is large, and people don't always follow instruction. The consequences (I have experienced both), the users loses the data they input due to the stopped SQL services...or the database upgrade goes pop due to open threads and a lengthy restoration begins.
The frustration being that SIMS is an extremely powerful program but no one had the foresight to include a table of currently logged in users, so you have no way of knowing.
Basically I want a way to first of all send a message to staff users logged on to the machines, I can export a list of SIMS stations and would want to broadcast to these. Then I'm experimenting with TASKILL to close the program although I'm not sure how successful this will be. The plan to say the program will be upgraded at xx:xx and then remotely shutdown the program however the remote shutdown may not be neccessary if they have a clear time it is unavailable as the service cycle cuts them off anyway. Then send a message around saying this is back up again after upgrade completes.

I know about the messenger service but as we have Vista clients this is no use. I have tried to get this clear in my head and was thinking about nested  batch files, ie a batch file to call a local batch file to display a message but wanted to see if anyone had an bright ideas??
Any ideas how I can achieve this?
0
Comment
Question by:SeventhZen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 500 total points
ID: 22792609
How about using a sceduled task that is set automatically via a login script.

This task runs a popup screen or message notifying the users, once in the morning and again 30 minutes before your down time window.

Win XP and mew can have scheduled tasks easily via  a batch file or maybe even the AT command.

I hope this helps !
 
0
 
LVL 1

Author Comment

by:SeventhZen
ID: 22794094
Ok, but the down time will change dependent on the day. I'll look into this though as it does sound like a way forward. How do you call a pop up message from a scheduled task?
0
 
LVL 1

Author Comment

by:SeventhZen
ID: 23084211
There seems to be no solid solution to this problem which is disappointing. With all the complicated things we can do within a network I would have thought that alerting users through the system would have been a must. Can anyone tell me why the built in messenger service is so bad?
0
 
LVL 1

Author Comment

by:SeventhZen
ID: 23084228
... having said this, Sysexpert's solution would work.

I just haven't managed to find the code to create a pop up window...yet!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
move command 5 67
Enterprise Mode 4 55
NTP time source for DC 3 46
Promote Server 2012 R2 on Server 2003 domain 13 17
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question