SpiraTeam query all users and roles

I needed a script for an audit of SpiraTeam to query all users and roles. And here it is:

/****** Script for SelectTopRows command from SpiraTeam ******/
SELECT TOP 1000000

[FULL_NAME]
,[PROJECT_ROLE_NAME]
,[PROJECT_NAME]
,[ACTIVE_YN]
FROM [SpiraTeam].[dbo].[VW_PROJECT_USER]
where ACTIVE_YN like ‘Y’
ORDER BY FULL_NAME ASC

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>