Knowledge Partner
Knowledge Partner
1937 views

Exporting User/mailbox lists

How can one get a list of mailboxes that have been archived out of
Retain? Or any of the user lists as well.

The Retain User list does not match GroupWise user list nor archived
mailboxes. The Retain User list is much shorter (lots seen missing),
not that I've found a way to extract the list yet.
We want to clear out the long gone short term users, but how to select
them when I can't see them in the system. They must be there from the
view of licenses consumed, but how to manage that usage?

We never did that very manual process of collected former staff, but
Retain appears to be wanting it that way rather than showing the former
and long gone staff.

Retain 4.2 (4.4 downloaded and in the queue to install) running on
OES11.2 This Retain system originally deployed as 1.x on OES9, so it
does have some history.



Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!

___
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
0 Likes
1 Reply
Knowledge Partner
Knowledge Partner

Re: Exporting User/mailbox lists

In article <VA.00000b2b.00b03314@no-mx.forums.microfocus.com>, Andy
Konecny wrote:
> How can one get a list of mailboxes that have been archived out of
> Retain?


Even though Mr Automatic is ignoring me, I engaged support on this.
The methods are:
A) use the Reporting and Monitoring abilities that were added somehere
in the last 10 years and that I don't have running because in this set
up, it isn't worth paying for the SSL cert (i.e. No other reason for
it).
B) Interrogate the DB directly with a suitable query which Support
proviced.
If running MySQL on Linux, with the default db names, the following can
be copy and pasted(right click) into a PuTTY session, otherwise it
contains the clues a DBA could use to extract that data out of other
combinations.


mysql -u root -p retain -e "SELECT
f_lmailbox AS 'Mailbox Name',
f_email AS 'Email Address',
f_dn AS 'User Name',
FROM_UNIXTIME(ts_store) AS 'Most Recently Archived Message',
COUNT(DISTINCT(tm.message_id)) AS 'Number of Messages Stored'
FROM t_message tm
INNER JOIN t_uuid_mapping tum ON tm.uuid_mapping_id =
tum.uid_mapping_id
INNER JOIN t_abook ta ON ta.f_uid = tum.f_uuid
GROUP BY abook_id
ORDER BY COUNT(DISTINCT(tm.message_id)) ASC
; SELECT NOW() AS 'Export Date';" | sed 's/\t/;/g' >
/home/retain_mailboxs.csv


Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!

___
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
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.