Find Jobs
Hire Freelancers

SQL Server TSQL stored procedure to log IIS user and robot access, getting data from external REST API providers

$10-250 USD

I përfunduar
Postuar about 5 years ago

$10-250 USD

Paguhet në dorëzim
The basic project to be accomplished is to create a SQL Server/TSQL stored procedure that will take Windows Server IIS logging information and to store into a series of SQL Server tables to track patterns of access of users and crawlers/robots. The goal is keep track of different classes of web requesters by the IP address, browser/device types, their location, what pages they accessed (when first, last, and how many times), with a lot of focus on detailed tracking of all crawlers/robots to our site. There are four additional tables that get populated when a crawler/robot is detected. Three REST API providers are used to get detailed information from the IP Address and User Agent Information provided of the requester that we want to then store in the database. Project Requirements: • All code should be written in TSQL invoked as a stored procedure • The database will be SQL Server 2017 or later • I can provide a dedicated development server accessible 24x7 via RDP over the Internet w/Windows Server 2016, SQL Server 2017, and Visual Studio Community Edition installed and ready to go. • I can provide a full SQL Server TSQL script to create the schema for your use • There are 5 primary tables that get populated by the arguments to the stored procedure • The solution requires getting data from three REST API providers (IPStack, from 51degrees, HackerTarget that all have free API access for testing) • There are 4 additional tables that need populating if the request is detected to be a crawler/robot • Please read the attachment for the detailed schema and requirements for how the fields are populated and how the tables need to be linked to each other The arguments to the stored procedure are from IIS ServerVariables ([login to view URL]) as follows: REMOTE_ADDR, HTTP_HOST, URL, QUERY_STRING, HTTP_USER_AGENT, REQUEST_METHOD, HTTP_ACCEPT, HTTP_COOKIE, and HTTP_ACCEPT_LANGUAGE Attached is a detailed schema description and what needs to be populated in the database.
ID e Projektit: 19000502

Rreth projektit

2 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hello, I am a c# developer and a sql server certified developer i can provide you this very smart solution and will work on it dedicatedly. you can view my profile and then we can discuss further
$222 USD në 10 ditë
5,0 (18 përshtypje)
4,8
4,8
2 freelancers are bidding on average $211 USD for this job
Avatari i Përdoruesit
I have 6 years experience in Tsql coding I went through thr requirement i can quickly help you to create stored procedure for this requirement
$200 USD në 10 ditë
5,0 (1 review)
2,5
2,5

Rreth klientit

Flamuri i UNITED STATES
San Mateo, United States
5,0
2
Mënyra e pagesës u verifikua
Anëtar që nga mar 8, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.