Find Jobs
Hire Freelancers

Write some Software

$10-30 USD

Concluído
Publicado há aproximadamente 8 anos

$10-30 USD

Pago na entrega
I need a Powershell script to pull the content of a webpage. The elements needed are on the page and need to be reformatted and written into a MS Access 2010 table. !!!!!The request is to do it with "Powershell". That is what I must have. No other third-party apps such as JS, Perl or Python.!!!!!! Finish/fix the script I started and have attached as a file or start from scratch... Pseudo code: Verify webpage exists: if "[login to view URL]"; returns error then "No updates for this date" ***Error example: "[login to view URL]" else do the following: Pull these items from the page: ------------------ "<p>This SRU number: 2016-05-04-001<br>" "This SEU number: 1476<br>" for each table... There are two tables on this sample but this changes. The can be "High Priority", Medium Priority", and/or "Low Priority". So for each table I need to categorize each of the rules. Only two sample for the two tables are shown here. "<caption><b>High Priority</b></caption>" "<tr><td>1</td><td>38680</td><td>MALWARE-CNC</td><td>[login to view URL] GET attempt</td><td>off</td><td>drop</td><td>drop</td></tr>" "<tr><td>1</td><td>38681</td><td>MALWARE-CNC</td><td>[login to view URL] POST attempt</td><td>off</td><td>drop</td><td>drop</td></tr>" "<caption><b>Medium Priority</b></caption>" "<tr><td>1</td><td>38677</td><td>INDICATOR-OBFUSCATION</td><td>UTF-8 evasion attempt</td><td>off</td><td>off</td><td>off</td></tr>" "<tr><td>1</td><td>38678</td><td>INDICATOR-OBFUSCATION</td><td>UTF-8 evasion attempt</td><td>off</td><td>off</td><td>off</td></tr>" ------------------ The middle Policy State, "Bal", is the one needed from the three listed. What I need is the data placed in the table "tbl_Rules" in the Access database. The columns are: "SRU","SEU","Priority_Level","GID","SID","Rule_Group","Rule_Message","Policy_State_Bal" Example inut from sample page: 2016-05-04-001,1476,High Priority,1,38680,MALWARE-CNC,[login to view URL] GET attempt,drop 2016-05-04-001,1476,High Priority,1,38681,MALWARE-CNC,[login to view URL] POST attempt,drop 2016-05-04-001,1476,Medium Priority,1,38677,INDICATOR-OBFUSCATION,UTF-8 evasion attempt,off 2016-05-04-001,1476,Medium Priority,1,38678,INDICATOR-OBFUSCATION,UTF-8 evasion attempt,off
ID do Projeto: 10465803

Sobre o projeto

3 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
I have created the script for you. You can download it from here: [login to view URL] File contains two readme file and an exe file it has been developed in powershell only, but for demo i have converted it into exe. before you run [login to view URL] create the table in the database with the following given fields id autoNumber SRE shortText SEU shortText GID shortText SID shortText Rule_group LongText Rule_Message LongText Priority ShortText policy_state_bal ShortText field names should remain the same. please test it if you get any errors please tell me i will fix it.
$30 USD em 0 dia
0,0 (0 avaliações)
0,0
0,0
3 freelancers estão ofertando em média $25 USD for esse trabalho
Avatar do Usuário
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$15 USD em 1 dia
4,8 (4 avaliações)
2,3
2,3
Avatar do Usuário
hi there, have been doing this every now and then. PM me the details.
$30 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
macdill afb, United States
5,0
11
Método de pagamento verificado
Membro desde jul. 10, 2009

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.