Closed

Windows Logon Script (Interfaces to DB)

This is a very small project. I am looking for a script to be developed for WMI/VBscript to perform a simple set of tasks at logon, and upload those results as a package with relevant information to an MS SQL Database.

The details of the script are as follows:

The details of the script are as follows:

1. Check a directory upon initial execution for any files of a hardcoded specific extension.

2. Collect and analyze files from (1) for a set of hardcoded keywords, if keywords found flag an arbitrary variable to a true value and continue processing, if not found, set result to false and continue processing file in (1)

3. Data from (1) should now be passed to an external executable with configurable hardcoded parameters and the results collected (result will be a .log file) external executable will produce output with a "success" output/keyword in the log if successfully processed. This should be performed on a per-file basis from (1).

4. If Success keyword is not discovered in program output from (3) delete file and associate log and continue to any additional files for processing, or exit if no other files discovered.

5. If success keyword from (3) is discovered continue processing, set arbitrary variable to "Valid", compress/archive initial file from (1) and logfile from (3) into archive/zip file with title format '[url removed, login to view]'

6. Information from (5) should be processed and uploaded to an MS SQL server to store the following information in a particular order, variables should be populated from local system values and user login. The information uploaded should be formatted as, 'date', 'time', 'localIP', 'sysname', 'username', 'poolfound'(variable from 2), 'data'(zip file from 5)

7. The information should be assumed to be acquired from a local windows system, the variables above with the exception of poolfound and data should be readily available through WMI to discover the logged in user (username), local hostname(sysname) and IP address.

8. Upon successful upload to the MS SQL server of information in (6) all data and logfiles generated in (1-5) will be removed from the local system and the script well exit.

Note: This should be assumed to be on windowsXP/200X system and will be executed as a script upon initial logon of users. All data will be hardcoded with no command line or run time parameters to be input.

The script should be easily modifiable by an advanced user for additional keywords, sql inputs, etc. Please contact me if you have any questions on further details for this project

Skills: .NET, C Programming, Visual Basic, Windows Desktop

See more: logon script, windows logon script, sql logon time, windows login time collect, windows login script, true results, script ip address, perform line, looking for windows 8, ip address script, continue line in c, logon windows, windows login script log, sql logon script, login script local, logon script output, script windows logon, scripting windows log, windows login script log username database, windows logon script mssql, windows login script creator, windows login script variables, logon script address hostname windows, custom windows logon scripts database, windows logonscript database

About the Employer:
( 0 reviews ) Scottsdale, United States

Project ID: #372313

6 freelancers are bidding on average $115 for this job

manidigital

We are experienced in logo, flash and page/flyer designs as well as making brochures. We have the capability to do what you need done in a reasonable amount of time, only gets paid until you're pleased. projects des More

$95 USD in 10 days
(6 Reviews)
3.9
ibm2009

i have completed BE from a renowned college and am very good in c,c++ and visual basic i will try my best to give the best output in proper time

$121 USD in 7 days
(0 Reviews)
0.0
DhirenNangla

I am a fresher from a renowned college. I have covered C/C++ and Visual Basics in my college. I will do all I can to fully satisfy your expectations.

$100 USD in 15 days
(0 Reviews)
0.0
kulkarnigs

I have 5 years of experience in Microsoft technologies. I work for an CMMI Level 5 company. I can do this for you

$150 USD in 3 days
(0 Reviews)
0.0
vgvaidya7

This can certainly be done using VBScript/WMI. Please refer to PM.

$100 USD in 3 days
(1 Review)
0.0
kabeersa007

Just provide the harcoded keywords, external .exe filename and a .log file.. your project/script is ready.

$125 USD in 7 days
(0 Reviews)
0.0