Simple query to check if a folder exist

Question

I know this may come off as a very basic question, but which table contains the list of all existing directories within an endpoint? 
 I managed to come with this SQL query, but it only returns the folder if there is any file within the folder, hence the hash table. 
 SELECT
directory
FROM hash
WHERE
directory = '$$folderPath$$' 
 Table directories doesn't exist, neither does table folders , so how do I simply check if a folder exists within a given path regardless if it contains files or not? 
 Thank you.

RichardP · Accepted Answer

Okay, you can use the 'File Attributes and metadata' query: 
 Now, to get an empty folder in the variable path put in the directory: C:	estFolder\ 
 you can also put in 	estFolder\ but it will just return a single entry even if the folder appears on multiple drives. 
 I just tested this by creating an empty folder on two drives and running the query. If I defined the specific path - it return each individual result. If I did the generic - it only returned one result even though there were two folders that matched. 
 I hope this helps.

Simple query to check if a folder exist

Top Replies