Ditutup

data reporting web site

[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.

Kemahiran: .NET, ASP, Pemprosesan Data, HTML, SQL

Lihat lebih lanjut: which site do i create my own site, web site process, web dos, tech data, sorted data, name and address template excel, microsoft exchange hosted, make data entry easier, get ip address asp net, dos web site, data processing com, data entry into web site, data entry in asp net, data entry device, check data entry speed, asp web site template, asp net data entry, asp net command, admin cs, my web tech, cs tech, make my own web site, i want to create my own web site, data processing companies, create new web address

Tentang Majikan:
( 5 ulasan ) Los Angeles, United States

ID Projek: #4058181

3 pekerja bebas membida secara purata $483 untuk pekerjaan ini

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 dalam 20 hari
(112 Ulasan)
7.2
adasoft

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

$450 USD dalam 30 hari
(7 Ulasan)
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 dalam 30 hari
(10 Ulasan)
3.9