Is it possible to generate a report of users that have never created a record or history change to the StarTeam database?

0 Likes

Problem:

Is it possible to generate a report of users that have never created a record or history change to the StarTeam database?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2006-2008
  • Product Component: GUI/Database
  • Platform/OS Version: N/A

This can not be queried using the StarTeam user GUI. However, the custom SQL code below should cover all circumstances whereby a user writes a record or history change to the StarTeam database.

SELECT ID, full_name from syn_userobject
where deletedtime = 0
AND
(
ID NOT IN (select CreatedUserID from syn_viewmember)
AND
ID NOT IN (select ModifiedUserID from syn_viewmember)
)
AND
(
ID NOT IN (select Responsibility from syn_change)
)
AND
(
ID NOT IN (select CreatedUserID from syn_file)
AND
ID NOT IN (select ModifiedUserID from syn_file)
AND
ID NOT IN (select DeletedUserID from syn_file)
)
AND
( ID NOT IN (select CreatedUserID from syn_task)
AND
ID NOT IN (select ModifiedUserID from syn_task)
AND
ID NOT IN (select DeletedUserID from syn_task)
)
AND
(
ID NOT IN (select CreatedUserID from syn_topic)
AND
ID NOT IN (select ModifiedUserID from syn_topic)
AND
ID NOT IN (select DeletedUserID from syn_topic)
)
AND
(
ID NOT IN (select CreatedUserID from syn_view)
AND
ID NOT IN (select ModifiedUserID from syn_view)
AND
ID NOT IN (select DeletedUserID from syn_view)
)
AND
(
ID NOT IN (select CreatedUserID from syn_link)
AND
ID NOT IN (select ModifiedUserID from syn_link)
AND
ID NOT IN (select DeletedUserID from syn_link)
)
AND
(
ID NOT IN (select CreatedUserID from syn_Audits)
AND
ID NOT IN (select ModifiedUserID from syn_Audits)
AND
ID NOT IN (select DeletedUserID from syn_Audits)
)
order by ID


Old KB# 28988
Comment List
Related
Recommended