Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Report of users and access to projects
Topic Summary:
Created On: 17-Jun-2005 10:06
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Richard Stedham, on Wednesday, June 22, 2005 12:12 PM

Answer:
Thanks, got me thinking along the right lines. I have attached my final solution, which produces output that can be saved as a CSV file and loaded into Excel.
 17-Jun-2005 10:06
User is offline View Users Profile Print this message


Richard Stedham

Posts: 19
Joined: 10-Dec-2003

I need to produce a 'report' that shows each user and which projects they have access to. I have tried the attached but it does not work if access is controlled via a group. How can I check if the access record contains a group and then check if the user is in the group?
Report this to a Moderator Report this to a Moderator
 17-Jun-2005 14:06
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

This script originates from Telelogic and I am posting it unmodified.
It lists the access right for items (projects, folders or modules) in the database.
It needs changing to do what you are asking which is to list access to projects for each user, rather than access of users for each project.




-------------------------
Tony Goodman
http://www.smartdxl.com

Edited: 17-Jun-2005 at 14:07 by Tony Goodman
Report this to a Moderator Report this to a Moderator
 22-Jun-2005 12:12
User is offline View Users Profile Print this message


Richard Stedham

Posts: 19
Joined: 10-Dec-2003

Answer Answer
Thanks, got me thinking along the right lines. I have attached my final solution, which produces output that can be saved as a CSV file and loaded into Excel.

users.dxl
users.dxl  (1 KB)

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.