Solved

Active and Inactive Mail Account

Posted on 2004-08-05
6
310 Views
Last Modified: 2013-12-18
There is an attempt to delete users from the Address Book by looking at the last accessed date of all mail databases.

1)How do I find out when was the last time all the mail databases were accessed?  

2)The inactive users will be put in a group and be removed 6 months later.  How do I stop others/active users from sending mails to these inactive users?

Or is there an other ways to achieve the same objective?  Please provide me with the necessary steps.


0
Comment
Question by:jessicasyc
  • 3
  • 2
6 Comments
 
LVL 15

Expert Comment

by:Bozzie4
Comment Utility
If you use R6, you can put the group the inactive users will be in, in the "Deny mail delivered to" (or something) in the Configuration document for the server.

You can find the last accessed time from the maildb from the file itself, (notesdatabase.lastmodified), but this will only give you the general last modified time - so if a server delivers mail, it's updated too....
So a better approach would be to write something that checks the log file (R5) or the activity log (R6+) for entries for a specific user.


cheers,

Tom
0
 
LVL 15

Expert Comment

by:Bozzie4
Comment Utility
That's the UsageByUser view in log.nsf, or the DatabaseUsage view in log.nsf you could search for the specific entries....

cheers,

Tom
0
 

Author Comment

by:jessicasyc
Comment Utility
Log.nsf only store records for 2 weeks.  Besides, the task to update all mail databases' design runs every night.  So last accessed date on the database is not an good indicator.

How do I use Database|Sizes, Database|Usage in log.nsf?  Please explain to me the section'Usage for entire period' in the Database|Sizes / Database|Usage document.

System details as below.
Server : 5.08
OS : AS400
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 15

Expert Comment

by:Bozzie4
Comment Utility
I remember creating an application (once , long ago ) to harvest this information back in the days of 4.6.  Result was a view, where the least accessed databases where easily identifiable and where the inactive users where identified too ...
But I also remember that this app. wasn't needed any longer in R5 ... because these features are available native in R5 (?) - now I'm not so sure anymore.
Anyway, I know for certain I no longer have that app.  

cheers,

Tom
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 95 total points
Comment Utility
I also wrote some utilities about a year, year and a half ago.  Pulled the user activity, filtered for servers and admins, and reported remaining usage.
0
 

Author Comment

by:jessicasyc
Comment Utility
Thanks for all the responses.

Please let me know which database that I can access to determine the inactive and active users/mail databases.  Which are the fields on the documents to compute user activity, filtered for servers and admins, and report remaining usage.

I should be able to create an application base on your inputs.

0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now