IS there anyway of getting the information presented on the “Files” tab of the Admin Client, specifically the “Mail” folder, into a format suitable for exporting or copying to an outside file?
I’d like to export/copy this information to a spreadsheet for my own auditing purposes. I haven’t been able to find the code the feeds this view (if it is a view).
Thanks.
Subject: Yes, easily export Files tab using ACL Dominator tool
You can easily export data in the Domino Administrator client (i.e. Files tab) using the “ACL Dominator” tool. It generates DB properties reports, ACL reports and mailbox reports including mailbox activity and DAOS size which can all be exported to Excel. Click the web site below, then click the screenshot link labeled “Screenshot 9 - Export Domino Admin client - Files tab”.
http://www.notesmail.com/ACLdominator
FYI
There are other more technical ways to export it, but this is quick and simple with audit history including snapshots of settings in the past. Other ways include (1) starting Domino http task and issuing an XML server console commands, then remoting into Domino server to retrieve cryptic exported file, or (2) printing Files tab using XPS or PDF, but the data cannot be copy/pasted and only prints the current root or folder rather than include all folders on the server.
p.s. I know this is an old post, but better late than never.
★ Crucial tools for IBM Lotus Notes and Domino administration and development…
Find the “crucial tools you need to succeed” including product descriptions, downloads, demos and testimonials.
Download and try the lite (free) version.
Better, stronger, faster productivity for administrators and developers.
Speed up IBM Lotus Notes and Domino administration and development with these crucial software tools.
Subject: “File” Tab View in Domino Admin Client
The data in the files panel doesn’t come from a view, it comes straight from the server itself.Unfortunately there is no direct way to copy or export the list of dbs from the files panel. You can try to use the catalog.nsf database and customize the views and export that, or, if you need ultimate control, you can get the data from the server in xml format via a remote console command “show dir -xml” and build your own list entirely.
Thomas - IBM
Subject: RE: “File” Tab View in Domino Admin Client
Thanks for your suggestion.
Is there a way to “pipe” that output to a file?
Or is it stored somewhere on the server in a tmp file?
I can issue the command and see the output on the console… but it doesn’t appear to land in the log files under mail routing or miscellaneous.
Subject: It’s really meant to be consumed by code…
…so you could for example using Lotusscript to do a NotesSession.SendConsoleCommand(‘show dir -xml’) to the server and feed the resulting XML string to a NotesDOMParser or NotesSAXParser, which…might be complete overkill in your specific situation.
Subject: RE: “File” Tab View in Domino Admin Client
Take a look in the Domino Admin. Help file… I found the following, hope it helps:
Certain server commands display information that you might want to capture in a file. Type the server command and on the same line, type a space and then the following:
filename.ext
where filename.ext is the name of the file to which you want to save output. Enter a space after the server command but not after the redirection symbol (>). For example, this command writes the output of the Show Tasks command to the file TASKS.OUT in the Notes directory:
Show Tasks > TASKS.OUT
To store output in a file outside the data directory, specify the complete path to the file.
Subject: I have a decent “file manager” type database I can send you.
Here is an example…
Subject: RE: I have a decent “file manager” type database I can send you.
If you don’t mind, I’d like to take a look at that db. You can send an email to <>#postmaster|at|dkmc.org#<> with “file manager” in the subject line.
Thanks.
Subject: Export files tab in Admin client - solution option
Hi… you could use
sh dir -xml >c:\temp\server_files.xml (note no space after >)
Then Import server_files.xml (created on the server c:\temp), via “Data > XML” in Excel.
This will put the XML attributes across the top columns and the data in the rows (like the Admin client files tab). You can then filter based on each attribute eg Template.
Hope this helps…