Home

Results 1 to 2 of 2

Thread: need help to create a special custom query...

  1. #1
    Join Date
    Mar 2017
    Posts
    1

    need help to create a special custom query...

    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

  2. #2
    NFMS Support Team NNTP User

    Re: need help to create a special custom query...

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •