176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MYSQL STORED PROCEDURE
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Aug 18, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $500 - $1,000
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We need a stored procedure written to perform time differential calculations, aggregation, and sums by windows event log id's by workstation and user name for work days +/- 8 hours. The stored procedure will update four tables with the data aggregated by Day, Week, Two-Week Period and Month. We are using MYSQL Ver 5.5 on Windows
------------------------------------------
Added 19 AUG 2012, 13:36 PM EDT
The project is as described and I am providing you more detail so that you can provide an accurate estimate. We are looking to have a stored procedure developed that will process data stored in MySQL 5.5 on Windows. The data consists of elements extracted from a single table wusing the following extracted fields: eventid, event_timestamp, event_type, user\domain, alias, workstationid.

General Algorithm
-----------------
Use time (for a given logon session) = ( (logoff time | begin_logoff time) - logon time )

Special case for when no Logoff Token was generated (no 538 for a given lo...

Sign in or Register to see more

Desired Skills
MySQL Administration
Job ID: 32839380
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Dominik V.      
Dominik V.'s identity has been verified.  Learn More
 Croatia (Hrvatska)  |  
Freelancer with 10+ years experience in database systems(Oracle, Mysql, Microsoft Access), database development, web-based application development...
1
  |  
 4.5   |  Private   |  9 Jobs
Bid ID: 33020637  |  Submitted: Aug 26, 2012 10:17 ET 
Proposal SEALED

 United Kingdom  |  
BSc. Computer Science with 15 years of software development, business analysis and project management experience. Key skill set includes Business...
1
  |  
 4.4   |  $330 Earnings   |  1 Jobs
Bid ID: 32999737  |  Submitted: Aug 25, 2012 03:25 ET 
Proposal SEALED

 India  |  
We are experts in databases and financial software. We have worked with the biggest investment banks in the world. We have a wealth of experience...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32893649  |  Submitted: Aug 21, 2012 09:14 ET 
Proposal SEALED

 India  |  
I AM A .NET DEVELOPER WITH MYSQL. SPECIAL IN PROCEDURE[MYSQL]
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32874195  |  Submitted: Aug 20, 2012 15:08 ET 
Proposal SEALED

 India  |  
Experienced Software Developer having more than 12 years of experience in developing applications using PHP, MySQL, Oracle, XML, C/C++, Delphi...
9
  |  
 4.9   |  Private   |  18 Jobs
Bid ID: 32872062  |  Submitted: Aug 20, 2012 13:45 ET 
Proposal SEALED

Luca Spricigo      
Luca Spricigo's identity has been verified.  Learn More
 Italy  |  
I am 36 years old, I am a freelancer with a strong sense of responsibility for the assigned tasks. I am very proficient in most Microsoft programs...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32866225  |  Submitted: Aug 20, 2012 09:50 ET 
Proposal SEALED

 Poland  |  
I have 12 years experience in following areas: - web programming ( PHP / mysql / HTML / CSS / Javascript / jQuery / AJAX ) - open source...
3
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 32861416  |  Submitted: Aug 20, 2012 05:45 ET 
Proposal SEALED

 Pakistan  |  
Quality services with good rating in Desktop apps(C#.net), Web designing, web apps(ASP, PHP, Wordpress), web scraping and more...
6
  |  
 4.9   |  Private   |  43 Jobs
Bid ID: 32849672  |  Submitted: Aug 19, 2012 14:31 ET 
Proposal SEALED

 Serbia  |  
Winner
Skilled web programmer and software developer with experience in MySQL, Java, SQL Server, C# and embedded C and Assembler programming of Microchip...
11
  |  
 5.0   |  Private   |  5 Jobs
Bid ID: 32848637  |  Submitted: Aug 19, 2012 13:09 ET 
Delivery
Within 2 weeks
$657.53

Serhii Berezovych      
Serhii Berezovych's identity has been verified.  Learn More
 Ukraine  |  
6 years programming experience Skills: Oracle, MySQL, C++, PHP, JavaScript (jQuery AJAX)
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32844343  |  Submitted: Aug 19, 2012 05:59 ET 
Proposal SEALED

 India  |  
I am expert oracle dba , pl/sql developer and Unix system administrator. I have a post graduate degree in computer application. I have 25 years of...
1
  |  
 0.0   |  $124 Earnings   |  1 Jobs
Bid ID: 32840573  |  Submitted: Aug 18, 2012 22:36 ET 
Proposal SEALED

 United States  |  
Build new database systems Backup and restore database system Set security on database, table, column... Maintainance :re-index, improve...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32840046  |  Submitted: Aug 18, 2012 21:33 ET 
Proposal SEALED

 Palestine  |  
Web Developer
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32839514  |  Submitted: Aug 18, 2012 20:20 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »