Generate a report showing the users and/or groups assigned to each Network Folder (Network Share) in FileCloud for audit purposes.
Original Question or Issue:
Generate a report showing the users and/or groups assigned to each Network Folder (Network Share) in FileCloud for audit purposes.
Environment:
- Product - FileCloud Server
- Version - Any
- Platform - Any
Steps to Reproduce:
Error or Log Message:
Defect or Enhancement Number:
Cause:
Resolution or Workaround:
Open a command prompt and navigate to the MongoDB binaries.
cd C:\xampp\mongodb\bin• Launch the MongoDB shell.
mongosh• Switch to the FileCloud database.
use tonidoclouddb• Run the following aggregation query to create a temporary audit collection.
db.externals.aggregate([ { $lookup: { from: "groups", localField: "groups.id", foreignField: "_id", as: "groupInfo" } }, { $project: { _id: 0, NetworkFolder: "$name", Users: "$users.name", Groups: "$groupInfo.groupname" } }, { $out: "networkfolder_audit" } ])• Exit the MongoDB shell.
exit• Export the temporary collection to a CSV file.
mongoexport --db tonidoclouddb --collection networkfolder_audit --type=csv --fields NetworkFolder,Users,Groups --out networkfolder_audit.csv• Review the generated networkfolder_audit.csv file.
Notes: