KQL Search

Query Details

HomeAI ToolsDevice Query

External Data LOLBAS

Query

externaldata(
    Filename:string,
    Description:string,
    Author:string,
    Date:datetime,
    Command:string,
    CommandDescription:string,
    CommandUsecase:string,
    CommandCategory:string,
    CommandPrivileges:string,
    Technique:string,
    OperatingSystem:string,
    Paths:string,
    Detections:string,
    Resources:string,
    Acknowledgements:string,
    URL:string
)[@"https://lolbas-project.github.io/api/lolbas.csv"] with (format="csv", ignoreFirstRecord=True);

Explanation

The query is importing data from a CSV file located at a specific URL. The CSV file contains information about various commands, their descriptions, authors, dates, categories, privileges, techniques, operating systems, paths, detections, resources, acknowledgements, and URLs. The query is ignoring the first record in the CSV file.

Details

Jose Sebastián Canós profile picture

Jose Sebastián Canós

Released: March 10, 2023

Tables

externaldata

Keywords

Filename,Description,Author,Date,Command,CommandDescription,CommandUsecase,CommandCategory,CommandPrivileges,Technique,OperatingSystem,Paths,Detections,Resources,Acknowledgements,URL

Operators

externaldatawithformatignoreFirstRecord

Actions