How to tabulate the number of publish made by an individual in Service Center ?

The title stated it all. So is there any way i can do that? The client outsystems server is on-premise

Hi Newbie,

Take a look at the System Entities. There might be some information in e.g. Espace_Version that you can use.

EnthusiaticNewbie wrote:

The title stated it all. So is there any way i can do that? The client outsystems server is on-premise

Try the below SQL:


SELECT u.USERNAME, ot.LABEL, o.DATETIME
  FROM [dbo].[OSSYS_DEVELOPER_OPERATION] o
  INNER JOIN [dbo].[OSSYS_DEVELOPER_OPERATION_TYPE] ot ON o.OPERATION_TYPE = ot.ID
  INNER JOIN dbo.[ossys_User] u ON o.USER_ID = u.ID
WHERE ot.LABEL = '1CP'
ORDER BY u.ID, o.DATETIME