data reporting web site

Closed Posted Dec 20, 2012 Paid on delivery
Closed Paid on delivery

[url removed, login to view]

I want a web site that will allow my hosted Microsoft exchange companies to track email access for any user

I want to be able to import and process the raw log files (above hyperlink samples) to the site

The log files are space delimited (I attached a sample converted to excel just to make it easier to see the columns)

The only columns I’m interested in are:

Date

Time

cs-username

c-ip

cs(User-Agent)

I do not want to display the raw cs-username in the report.

When the log file is imported we need to grab three items based on the data in the cs-username column:

email address, first name, last name. To extract the data:

Strip any leading “Shadik\”

If the remaining data is an email address (for example info @[url removed, login to view]) then run this dos command to extract the first name, last name, and email address:

dsquery user -upn info @[url removed, login to view] | dsget user -fn -ln -upn

If the remaining text is NOT an email address (for example alex2) then run this dos command to extract the first name, last name, and email address:

dsquery user -samid alex2 | dsget user -fn -ln -upn

Based upon the domain name in the email address extracted, create a single username for that domain name, assuming one does not already exist from previous log file imports (domain name will be the username).

Data for all similar email addresses will be associated with this single username

For example: email address contains @[url removed, login to view], username [url removed, login to view] is created

Subsequent log files imported detect other email addresses with the same domain;user1 @[url removed, login to view],user2 @[url removed, login to view],user3 @[url removed, login to view]

The data for the above new entries will be reported under the same [url removed, login to view] username

upn,fn,ln

user1 @[url removed, login to view],User,One

user2 @[url removed, login to view],User,Two

user3 @[url removed, login to view],User,Three

After a cs-username is associated with a user it will permanently be associated to that username for future log file imports (to speed up log file data import and processing)

Based on the ‘Time’ column: only one entry per 0:01:00 (one minute), per cs-username, will be imported.

Concerning the import and report display for the cs(User-Agent) column:

Import all text up till the first “/” labeled as “device”

Import all text after the first “/” only until (but not including) the next “+” labeled as “version”

All the above data processing will happen automatically with the import and processing of the log file.

---------

Once logged in, you will see a list of all email addresses, first and last names with check boxes next to each one

There will be a date range selector and a “get email access report” button

Only one entry can be checked at a time to get a report

The report will display on the screen

The onscreen report will be able to be sorted based on any column (ascending or descending)

---------

There will be a site admin user which has the functionality to:

import and process the raw log files

change user passwords

enable/disable users (disabled users cannot log into the site)

Delete users (deleting a user will also delete all data for that user)

Purge data based upon: user/all users and date range

User functionality:

Change their own password

Generate on screen reports

A sample skeleton site template is required for approval before and bid is accepted.

.NET ASP Data Processing HTML SQL

Project ID: #4058181

About the project

3 proposals Remote project Active Jan 26, 2013

3 freelancers are bidding on average $483 for this job

ITservice

Hi, I have experience importing data from raw log files. Pls send me the excel sheet with sample data. I don't find here. Zip is taking too long to download. regards

$500 USD in 20 days
(112 Reviews)
7.2
adasoft

Dear Sir,We are very much interested your nice project. Sincerely AdaSoft

$450 USD in 30 days
(7 Reviews)
4.2
ultrasonicsoft

Hi, I have required skill set to complete your work. Please check my profile. I can deliver you this project. Hope to hear from you soon. Thanks! Regards

$500 USD in 30 days
(10 Reviews)
3.9