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
Released: March 10, 2023
Tables
externaldata
Keywords
FilenameDescriptionAuthorDateCommandCommandDescriptionCommandUsecaseCommandCategoryCommandPrivilegesTechniqueOperatingSystemPathsDetectionsResourcesAcknowledgementsURL
Operators
externaldatawithformatignoreFirstRecord