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

Terminado
Publicado hace alrededor de 5 años

$10-250 USD

Pagado a la entrega
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 del proyecto: 19000502

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 10 días
5,0 (18 comentarios)
4,8
4,8
2 freelancers están ofertando un promedio de $211 USD por este trabajo
Avatar del usuario
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 en 10 días
5,0 (1 comentario)
2,5
2,5

Sobre este cliente

Bandera de UNITED STATES
San Mateo, United States
5,0
2
Forma de pago verificada
Miembro desde mar 8, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.