wernaun
New Member.
2773 views

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
0 Likes
1 Reply
Anonymous_User Absent Member.
Absent Member.

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.