Deleting stale Office messages

[Patrick Green]

Hi Kenneth & Robin,
 
You might try RSSOINBO to get a list of the number of documents in
individual inboxes.   And RSSODLIN to delete entries for individual users.
 
Cheers,  -- Ptk.
 
 
 
 
 
Kenneth Hill <SAP_DEV_WB at Yahoo.com>@MITVMA.MIT.EDU> on 10/08/2002 09:19:06
AM
 
Please respond to "SAP Workflow Users' Group" <SAP-WUG at MITVMA.MIT.EDU>
 
Sent by:    SAP Workflow <Owner-SAP-WUG at MITVMA.MIT.EDU>
 
To:    SAP-WUG at MITVMA.MIT.EDU
cc:
Subject:    Deleting stale Office messages
 
Friends,
 
I have been experiencing degradation in response times when opening our SAP
Office messages (SO01 in 4.0b) . This is even though I have very few (3-5)
items
in my Office and Workflow folders.
 
I run the Workitem archive and deletion (SARA) regularly and have not seen
a
substantial growth in SWWIHEAD and related tables. I suspect that the
slowing
response time may be due to the growth of Office mail and not workitems.
There
are many users who save reports and batch jobs spools in their Inbox and
don't
clean these up. I know one user who has several thousand of these. There
may be
other users whose logins have been deleted, but their Inbox may not have
been
purged.
 
Is there a deletion report, similar to RSWWWIDE,  available to delete
Office
messages? Also can you tell me the name of the tables where the Office
messages
are stored, so that I can monitor the rowcounts.
 
Thank you for your assistance.
 
Kenneth Hill
and
Robin Sahasranam
 
 
 
 
_________________________________________________________________
PLEASE NOTE THAT IBM recently completed its acquisition of
PricewaterhouseCoopers' global management consulting and information
technology services business, PwC Consulting.  As a result, PwC Consulting
is no longer a part of the PricewaterhouseCoopers network of firms, and is
now a part of the IBM Global Services business unit.  IBM (including IBM
Global Services) and PricewaterhouseCoopers are not the same organisation,
and neither governs or is affiliated with the other, or any affiliate,
subsidiary or division of the other.
 
 
PLEASE ALSO NOTE THAT as a result of this acquisition by IBM, the
individual sending this note is an IBM employee and is no longer employed
by or represents PricewaterhouseCoopers.