Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 517251

Summary:	[API] - Create database table to store user logs
Product:	Community	Reporter:	Eric Poirier <eric.poirier>
Component:	API.eclipse.org	Assignee:	API.eclipse.org inbox <api-inbox>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	P3	CC:	chris.guindon, webmaster
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Mac OS X
Whiteboard:
Bug Depends on:
Bug Blocks:	513771

Description Eric Poirier

2017-05-25 10:52:03 EDT

In the scope of the bug 513771 we will need to gather information about how many users updates the USS applications and how frequently.

This would be solved by creating a new table in the api database to store which user updated which application and when.

Example:

User            Application                Timestamp
user-1          OOMPH                      1495723707
user-2          MPC                        1495723712
user-3          OOMPH                      1495723771

Comment 1 Christopher Guindon

2017-05-25 11:09:21 EDT

(In reply to Eric Poirier from comment #0)
> In the scope of the bug 513771 we will need to gather information about how
> many users updates the USS applications and how frequently.
> 
> This would be solved by creating a new table in the api database to store
> which user updated which application and when.
> 
> Example:
> 
> User            Application                Timestamp
> user-1          OOMPH                      1495723707
> user-2          MPC                        1495723712
> user-3          OOMPH                      1495723771

+1 but make sure to use the unique application id in the application column, not the name.

Comment 2 Eric Poirier

2017-05-25 11:17:20 EDT

(In reply to Christopher Guindon from comment #1)
> (In reply to Eric Poirier from comment #0)
> > In the scope of the bug 513771 we will need to gather information about how
> > many users updates the USS applications and how frequently.
> > 
> > This would be solved by creating a new table in the api database to store
> > which user updated which application and when.
> > 
> > Example:
> > 
> > User            Application                Timestamp
> > user-1          OOMPH                      1495723707
> > user-2          MPC                        1495723712
> > user-3          OOMPH                      1495723771
> 
> +1 but make sure to use the unique application id in the application column,
> not the name.

Sounds good.

Which would result in something like:

User            Application                   Timestamp
user-1          cNhDr0INs8T109P8h6E1r_GvU3I   1495723707
user-2          MZ04RMOpksKN5GpxKXafq2MSjSP   1495723712
user-3          cNhDr0INs8T109P8h6E1r_GvU3I   1495723771

Comment 3 Eric Poirier

2017-05-31 12:41:54 EDT

A patch has been merged to create the database table.

https://foundation.eclipse.org/r/#/c/1599/

Now closing this bug.