Manage the Profiles event log
Use Profiles administrative commands to manage the Profiles event log.
Before starting
To run administrative commands, use the wsadmin client. See Starting the wsadmin client for information about how to start the wsadmin command-line tool.
About this task
The Profiles EVENTLOG table logs records relating to Profiles user events. For example, every time a user removes a board post or adds a tag to their profile, an entry is logged in the table. From time to time, you might want to purge older records from the table to control the size of the data. Otherwise, the entries can grow rapidly and impact performance in areas such as seedlist indexing.By default, records that are more than 30 days old are automatically purged from the event log. For information about how to modify the setting that controls this interval, see Configure event log clean-up for Profiles.
Procedure
To manage entries in the event log table for Profiles...
- From the dmgr host:
cd $DMGR_PROFILE/bin
./wsadmin.sh -jython
execfile("profilesAdmin.py")
If prompted to specify a service to connect to, type 1 to pick the first node in the list. Most commands can run on any node. If the command writes or reads information to or from a file using a local file path, pick the node where the file is stored.
Use the following commands as required.
ProfilesService.purgeEventLogs()
Deletes all event log entries in the EVENTLOG table. This command does not take any arguments.
ProfilesService.purgeEventLogsByDates(string startDate, string endDate)
Deletes event log entries created between the specified start date and end date.
This command takes the following parameters:
startDate
A string that specifies the start date for the period in MM/DD/YYYY format.
endDate
A string that specifies the end date for the period in MM/DD/YYYY format.
For example:
ProfilesService.purgeEventLogsByDates("06/21/2009", "06/26/2009")This command deletes all the event log entries that were created on or after June 21st, 2009 and before June 26th, 2009 from the EVENTLOG table.
ProfilesService.purgeEventLogsByEventNameAndDates(eventName, string startDate, string endDate)
Deletes event log entries with the specified event name that were created between given start date and end date.
This command takes the following parameters:
eventName
The type of event that you want to remove from the EVENTLOG table. The following names are some examples of valid event names:
- profiles.created
- profiles.removed
- profiles.updated
- profiles.person.photo.updated
- profiles.person.audio.updated
- profiles.colleague.created
- profiles.colleague.added
- profiles.connection.rejected
- profiles.person.tagged
- profiles.person.selftagged
- profiles.tag.removed
- profiles.link.added
- profiles.link.removed
- profiles.status.updated
- profiles.wallpost.created
- profiles.wallpost.removed
- profiles.wall.comment.added
For a complete list of valid event names for Profiles event log cleaning administrative tasks, refer to the following web page: Events_Reference
startDate
A string that specifies the start date for the period in MM/DD/YYYY format.
endDate
A string that specifies the end date for the period in MM/DD/YYYY format.
For example:
ProfilesService.purgeEventLogsByEventNameAndDates(profiles.colleague.created, "06/21/2009", "06/26/2009")This command deletes all the profiles.colleague.created event log entries that were created on or after June 21st, 2009 and before June 26th, 2009 from the EVENTLOG table.
Parent topic
Administer Profiles
Related tasks
Configure event log clean-up for Profiles
});