<div>
What is it you are asking for?
</div>


<div>
how long will it take to create a parser from scratch? we have raw logs from firewalls , and we need to create a parser. We are being asked to give a timeframe.
</div>


<div>
Do you mean you would like to create a stored procedure that searches log records based on the regex patterns supplied in your link? &nbsp;Where are these logs stored? &nbsp;What is the schema?
</div>


<div>
You tagged this as SQL &amp;&nbsp;Query Syntax is there anything database related?
</div>


Senior Systems Administrator

Kelly Garcia

<div>
<div class="content wysiwyg-content">
on average how long will it take to develop a query parser like the one on this link it requires a lot of regex queries:<br />
<br />
<a href="https://www.github.com/Azure/Azure-Sentinel/tree/master/Parsers%2FBarracuda%2FCGFWFirewallActivity" rel="ugc nofollow">https://www.github.com/Azure/Azure-Sentinel/tree/master/Parsers%2FBarracuda%2FCGFWFirewallActivity</a>
</div>
</div>


on average how long will it take to develop a query parser like the one on this link it requires a lot of regex queries:

https://www.github.com/Azure/Azure-Sentinel/tree/master/Parsers%2FBarracuda%2FCGFWFirewallActivity

query parser time required

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.

Security

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.