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: User and Group Access Rights report
Topic Summary: User and Group Access Rights report via DXL
Created On: 2-May-2007 16:21
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.
 2-May-2007 16:21
User is offline View Users Profile Print this message


jim hays

Posts: 1
Joined: 16-May-2006

I wanted to check to see if there is any way to export a full list of users in DOORS with their access. Like an excel spreadsheet extract of the security table? Does anyone have a DXL already written that might do it? Many thanks,

Paul Higginbotham

Engineering Tools Center of Excellence

Project Manager, Business Solutions

Work: 864-254-2050

Dial Comm: *288-2050

E aul.higginbotham@ge.com">mailtoaul.higginbotham@ge.com

Report this to a Moderator Report this to a Moderator
 2-May-2007 17:27
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Good luck. For one thing, the report will be massive. Here are some thoughts:

Perhaps you want an AccessRecord report, displaying all the accesses in the project-folder-database. You would loop through everything and then looking at its access records, and you'd want to export a column showing whether the AR is specific or inherited.

If you want a report of each person's accesses, you would, for each thing (folder, module, attrdefs, etc) first gather all the Group information and each user in the group, then for each thing accumulate the accesses of the thing's groups, where you'd extract the existing accesses and add the new ones. Skip looks like a natural for that, where 'key' is user name and 'data' is Permission. After that, you'd loop through the thing's User's accesses, and these would take precedence over each user's accesses accumulated through the thing's group. I think this approach would be more suitable for some sort of "WhatAccessDoesThisUserHave.dxl" script, rather than one that dumps everybody's.

Good luck.

- Louie
Report this to a Moderator Report this to a Moderator
 2-May-2007 17:28
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Jim,

please have a look at Michael Sutherland's Homepage
There is an exporter of user list to Excel

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 3-May-2007 00:29
User is offline View Users Profile Print this message


Paul Miller

Posts: 376
Joined: 2-Oct-2002

Hi Jim,

The attched DXL script might go some of the way towards what you're after.

This gives a detailed report for users and groups - something I wish that Telelogic would provide as a part of sadly lacking DOORS Administration level management functions (had to get that off my chest, I feel better now! ).

The report produced in the DXL interaction window is tab delimited and can be copied and pasted straight into Excel which automatically detects the tab delimiter - you'll just have to format the Excel column widths to suit.

-------------------------
Paul Miller
Specification Practices Specialist,
EuroCyber,
Melbourne, Australia.
Mobile: +61 (0)418 135 103
Web Site: http://www.eurocyber.biz
E-mail: miller@eurocyber.biz">pmiller@eurocyber.biz
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.