DQL Query to find a specific filename

Question

How do I look for a specific file?

Ie what’s the field for “filename” ?

&nbsp;

Using DQL report, I can find all files with extension “url”

What do I change to find a specific file (HELP_DECRYPT.URL)

&nbsp;

FROM &nbsp; path

GET &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; absname,

size AS size_bytes,

formatdate(created_on,'YYYY/MM/DD HH:MM:SS Z') AS creation_time,

formatdate(last_accessed,'YYYY/MM/DD HH:MM:SS Z') AS last_accessed_time,

formatdate(last_modified,'YYYY/MM/DD HH:MM:SS Z') AS last_modified_time

IF &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type = "FILE" AND

extension IN ("url")

SORTBY size DESC

dmonks · Answer

Hey Darryl,

Based on a DQL example (IF clause), I believe filename would be "basename". The example from the UI:

FROM &nbsp;&nbsp; &nbsp;path
	get &nbsp;&nbsp; &nbsp;name,
	active_users.name
	IF &nbsp;&nbsp; &nbsp;basename IN ("ssn.csv","credit_cards.csv")

Forum Discussion