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

Slutfört
Publicerad ungefär fem år sedan

$10-250 USD

Betalning vid leverans
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.
Project ID: 19000502

Om projektet

2 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
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 Om 10 dagar
5,0 (18 omdömen)
4,8
4,8
2 frilansar lägger i genomsnitt anbud på $211 USD för detta uppdrag
Använd avatar
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 Om 10 dagar
5,0 (1 omdöme)
2,5
2,5

Om kunden

Flagga för UNITED STATES
San Mateo, United States
5,0
2
Verifierad betalningsmetod
Medlem sedan mars 8, 2019

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.