[login to view URL]
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 @[login to view URL]) then run this dos command to extract the first name, last name, and email address:
dsquery user -upn info @[login to view URL] | 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 @[login to view URL], username [login to view URL] is created
Subsequent log files imported detect other email addresses with the same domain;user1 @[login to view URL],user2 @[login to view URL],user3 @[login to view URL]
The data for the above new entries will be reported under the same [login to view URL] username
upn,fn,ln
user1 @[login to view URL],User,One
user2 @[login to view URL],User,Two
user3 @[login to view URL],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.
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