Please Help!

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Please Help!

Logged in as: Guest

arrSession:exec spGetSession 2,2,909

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Please Help!
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Please Help! - 9/26/2003 1:00:37 AM

uknees

Posts: 1
Score: 0
Joined: 9/26/2003
From:
Status: offline

Hi all,

Here's the scenario:

I need to write something to check if the engineers have filled in their
time sheet.

So... here's what I need to do
Check the DB to see if the all the engineers have filled in time sheet
- for those who didn't complete the weekly time sheet,
a message will popup on their screen to remind them

My problem:
I cannot use the net send command because not all users are running
WinNT or 2000, some are still using Win98. Even if winpop.exe is executed
on the clients, users can still disable it.

My solution:
Write my own exe program to popup a messagebox at the clients machine,
based on their ip address (which is kept in the DB)
if they satisfy the criteria of not completing the time sheet.

My question:
Is this possible? As in executing the exe program based on ip address.
I have no idea how to accept a parameter(ip address) from the exe file.

I thought of writing it in a stored procedure(easier for me to access DB)
but, I am not sure if xp_cmdshell is able to execute exe files.

I also played with the idea of writing it using vbscript but, have no
idea how to execute my exe with a parameter.

Any advice is greatly appreciated. Thanks!