• State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    3
  • Views views
    251
  • Users 0 members are here
  • Locked Locked
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

need help to create a special custom query...

wernaun
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
  • 0
    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

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.