Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Message to Session Users - How's it done in your org ?
If the database server is a Windows server and you want to send to Windows clients on a LAN / WAN how about something like the following
set def &
undef the_msg;
define the_msg = 'Hello';
select distinct
' rem user name : ' || username || ', os user: ' || osuser || chr(10)
|| 'net send ' || replace ( replace(machine,'DOMAIN1\') , 'DOMAIN2\' ) ||
' ' || '&the_msg'
from
( select username , osuser , machine from v$session where user# <> 0 order
by username )
;
undef the_msg;
-- end of netsend.sql
You could add a spool command, send the output to a batch file and then use
host command to run the batch file.
It could be improved to remove any generic domain by using substr and instr
but I haven't had the need to do that.
Is this the type of thing you are after?
Regards,
Bruce Reardon
-----Original Message-----
Sent: Tuesday, 4 December 2001 7:25
On NT LAN use the "NET SEND" command.
You can send to individual user names or domain wide
or to those that have connections to the server.
HTH
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com
> -----Original Message----- > From: Robert Chin [SMTP:chinman_at_optonline.net] > Sent: Sunday, December 02, 2001 07:10 PM > > In our current environment, we have the need to be able to > send LAN pop-up message to users of ACTIVE Oracle sessions. > ("Pls log out NOW !...", "Pls don't do any x transactions..." etc you get > the idea) > > If your organization have similar need..... > Do you know how it's done in your organization ? > Pls specify the infrastructure (whether it's via Internet or LAN and the > OS) > > Thanks
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 04 2001 - 17:33:19 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |