Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Extract the user permission data on CMS

Extract the user permission data on CMS

Extract the user permission data on CMS


I am trying to extract the data in the user permissions area of CMS. The company want to do a clean up as there are many users on CMS who have access to all VDNs, Skills and vectors. I enter the user id and the list all but there is no option to copy the entire results so I could paste into excel or notepad or anything!. we are using CMS 16.

I have tried accessing CMS from Putty and using emulator 615 from ASA. I tried to print the list all results and its telling me I do not have a printer setup. Im not sure how comlpex it is to configure the printer in solaris or if that will give me what i need.

RE: Extract the user permission data on CMS

I would use the ODBC link to CMS and extract the data using something like TOAD or even MSAccess.

However, in the past I would extract it by creating a bogus network printer then extracting the output from the CMS printer spool and importing it into Excel.

You can read about both methods here: thread690-1708194: Exporting CMS Users List

I also attached a document I have from long ago when I did CMS administration on how to setup a network printer.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close