data reporting web site
$250-750 USD
Pagado a la entrega
[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.
Nº del proyecto: #4058181
Sobre el proyecto
3 freelancers están ofertando un promedio de $483 por este trabajo
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
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