On 3/2/2017 2:56 AM, wernaun wrote:
>
> Hi all,
>
> we've hundrets of coloboration folders like this:
>
> xFolder (root folder)
> |_ xTeam1
> | |_ Subfolder (including more subfolders and files...)
> |_ x_Company99
> |_ xTeam2
> |_ xTeam3
> |_ xTeamIT
> |_ xTeamMarketing
>
> etc...
>
> I need a query which checks the last access date from all files/folders
> and subfolders, and return only the folder name from the 2nd level
> (xTeam1) if the last access date is greater than 2 years ago of all
> files below each collaboration folder.
> So that we able to archive this folders, which contain only old files.
>
> Kind regards
>
> Nils
>
>

Nils,

There's actually a special website the NFMS Support Team created to
assist with custom queries like this: http://www.filequerycookbook.com.
You can find custom queries other File Reporter users have created
(https://www.filequerycookbook.com/recipes) as well as get help from our
team directly.

-- NFMS Support Team