cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Number of Users and Groups

Highlighted
Newbie

Number of Users and Groups

Hi All,

Sorry to send a request from PTC out on the solutions exploder, but I
need your help in defining the direction of the Windchill product. If
you could reply with the number of users and groups you have in your
production system and your Windchill version information, it would be
very much appreciated.

I'm specifically looking for the ratio of (users+groups) to (users), not
counting the container team role groups, if you'd prefer to report it
that way. To help with counting, you should be able to use the attached
script and instructions.

Thanks,
Mike Kasameyer
PTC Product Management
5 REPLIES 5
Highlighted

Number of Users and Groups

All-

We have 5000+ user IDs with 202 groups (A "Read", "Author", and "Admin"
group for each of our data cabinets in Windchill Foundation).

On a related note, we recently migrated from Windchill Foundation 6.2.6 to
Windchill Foundation 8.0.

Our production LDAP in 6.2.6 (and it's backups for the last year)
apparently had a corruption that was masked in 6.2.6, that our test system
didn't have, and that resulted in major database-LDAP disconnects during
the migration.

We've lost hundreds of users and thousands of group memberships - and it
is VERY hard to work with the LDAP-database mismatches that have crippled
us. The "repair" tool in the principal administrator doesn't work for
these migrated, corrupt user IDs.

PTC is helping, but I just wanted to say that if this was all in the
database instead of the LDAP that we'd have been able to use SQL repairs
to fix this problem immediately. Instead, we have an incredible amount of
pain trying to fix what is essentially a "black box" problem inside the
LDAP and inside of BLOBs instead of inside of nice, neat, repairable
database records.

So, for those at PTC who get this, please consider an option in the future
of allowing group/user data to get back into the database where reporting
and repairs for large systems isn't so incredibly difficult as it is in
the LDAP. Any benefit that we may incur from having an LDAP pales in
comparison to the pain it has caused us over the last several years in
managing our production, test, and training systems for replication and
upgrades/migrations.

Thanks.

Al Anderson
Solar Turbines Incorporated








"Kasameyer, Mike" <->
02/19/2008 04:49 PM
Please respond to
"Kasameyer, Mike" <->


To
-
cc

Subject
[solutions] - Number of Users and Groups




Caterpillar: Confidential Green Retain Until: 03/20/2008



Hi All,

Sorry to send a request from PTC out on the solutions exploder, but I need
your help in defining the direction of the Windchill product. If you
could reply with the number of users and groups you have in your
production system and your Windchill version information, it would be very
much appreciated.

I'm specifically looking for the ratio of (users+groups) to (users), not
counting the container team role groups, if you'd prefer to report it that
way. To help with counting, you should be able to use the attached script
and instructions.

Thanks,
Mike Kasameyer
PTC Product Management
Highlighted

AW: Number of Users and Groups

Hi,



Here are our results.


Number of Users and Groups

Hi All,

For those of you who replied with the statistics from your system,
thanks. It's been very helpful so far.

For those of you who attempted to run the tool and received an error, I
apologize. There were some dependencies in the code which required a
later 8.0 MOR. The script has been updated to work on earlier MORs as
well -- see "Statistics2" attached. I'd appreciate it if you ran this
one, and sent in the results.

For those of you who may be concerned about what the script may do, it
is reading the LDAP for user and group information. As long as you
follow the instructions and don't extract into codebase there should be
no risk of data corruption or other issues.

Thanks again,
Mike Kasameyer

Highlighted

Number of Users and Groups

Mike,

Our somewhat Draconian virus scanner software stripped of the attached class
files off of you email message. Is there any way you can put the required
files up on the solutions Projectlink project so they can be grabbed from
there?

Ron


On 2/28/08 1:48 PM, "InterScan Notification" <->
Highlighted

Number of Users and Groups

Ron,

I checked them into a new "User and Group Statistics
<
Technical Committees Project.

Thanks for the suggestion.

Regards,
=MrK


Announcements