topic Re: How to get all of the acl Policies in windchill 9.1? in Windchill

How to get all of the acl Policies in windchill 9.1?

ptc-4148881 — Wed, 02 May 2018 08:54:30 GMT

How to get all of the acl Policies in windchill 9.1?I can't find a export tool to do this,help!

Re: How to get all of the acl Policies in windchill 9.1?

MikeLockwood — Sun, 06 May 2012 22:50:37 GMT

I have a query builder report that returns all - can dump out to Excel. Contact me if you would like to have it.

Re: How to get all of the acl Policies in windchill 9.1?

rdanner — Tue, 15 May 2012 18:42:20 GMT

Mike, Yes - I could use this report.

Please send it my way.

Re: How to get all of the acl Policies in windchill 9.1?

MikeLockwood — Tue, 15 May 2012 18:44:10 GMT

Please advise email address to send to.

Re: How to get all of the acl Policies in windchill 9.1?

rdanner — Tue, 29 May 2012 19:37:36 GMT

Mike,

Please send to richard_e_danner@whirlpool.com

Re: How to get all of the acl Policies in windchill 9.1?

ptc-4148881 — Tue, 29 May 2012 23:56:30 GMT

please send to 52234858@qq.com,Thanks.

Re: How to get all of the acl Policies in windchill 9.1?

rmk — Thu, 26 Oct 2017 20:23:21 GMT

Hi Mike,

Am looking exactly the same report too., Please send me to -.

Thanks in Advance.

Re: How to get all of the acl Policies in windchill 9.1?

bnüßlein — Tue, 24 Jul 2012 18:52:45 GMT

Mike,

please send it also to bernd.nuesslein@goldhofer.de.
Thanks al lot

Re: How to get all of the acl Policies in windchill 9.1?

WajidHussain — Mon, 22 Oct 2012 13:38:32 GMT

Mike,

I see a lot of people are interested in the report. Are you able to upload / make avilable via this thread ? If not, maybe you can copy/paste the SQL.

Cheers

Re: How to get all of the acl Policies in windchill 9.1?

WajidHussain — Mon, 22 Oct 2012 13:50:20 GMT

this tread might be helpful to others:

http://communities.ptc.com/ideas/1535

Re: How to get all of the acl Policies in windchill 9.1?

MikeLockwood — Mon, 22 Oct 2012 15:03:07 GMT

I've provided the report to PTC and asked them to edit it then post it.

Re: How to get all of the acl Policies in windchill 9.1?

HRodarte — Thu, 26 Oct 2017 22:17:56 GMT

I cannot find anything about this report capability at PTC.com, would you please send my a copy?

Re: How to get all of the acl Policies in windchill 9.1?

WajidHussain — Fri, 13 Sep 2013 14:35:31 GMT

Mike, I would also appricate a copy of this report cheers wajid@hussain.co.uk

Re: How to get all of the acl Policies in windchill 9.1?

stheuner — Thu, 03 Oct 2013 20:57:25 GMT

Hi Mike, would be nice if you could send me a copy of it too. I realy would appriciate it, thanks Sven.

the_pilo@yahoo.de

Re: How to get all of the acl Policies in windchill 9.1?

MINGRUJIANG — Thu, 26 Oct 2017 22:46:41 GMT

Hi Mike, would you send me a copy of it too. Thanks a lot.

Re: How to get all of the acl Policies in windchill 9.1?

WajidHussain — Tue, 01 Apr 2014 11:02:51 GMT

There are a few people asking for the report, but has anyone actually received anything from Mike yet?

Re: How to get all of the acl Policies in windchill 9.1?

ctragbar — Fri, 04 Jul 2014 09:54:11 GMT

Hallo, take a look into this thred http://communities.ptc.com/thread/35321.

There you will find a posting from Mike with the attached ACL´s.qml.zip report.

Re: How to get all of the acl Policies in windchill 9.1?

aachanta — Tue, 10 May 2016 07:38:52 GMT

Hi All,

If we want to migrate ACL's from the source system Windchill 9.1 M010 to target system Windchill 10.2 M020. How would we do that ? Can you please answer the below questions

1. ) Do we need to write a custom utility for extracting ACL's from the source system ? If yes, can anyone please share a sample code related to the same.

2. ) As and when we migrate data from the source system to that of target system using Windchill Bulk Migrator the extracted data first loads into the staging database and from the staging database the data gets loaded into the target Windchill system. So upon extracting ACL's from the source system will they also be stored in the staging database. If yes where ?

3. ) Upon saying retrieving or extracting ACL's what is it are we extracting ? What is the output going to be like ? Is it an xml file or something else ? What is ACL's extracted output ? Say for suppose if we are extracting WTPart or WTDocument object types we can see all the object related data in the staging database and upon loading in target system and its database. So where will the ACL's be stored in the system ? Is it in the staging database or anything else ? Can anyone tell the name of the table ?

4. ) Upon creating an ACL in Policy Administrator will it make an entry in the Windchill folder. If yes which particular file will be internally modified and how to see that ?

Can you please answer the above questions so that I can get an idea on how to extract ACL's from the source system and then load into the target system in case if we are using WBM and even without using WBM can anyone let me know about it once.

Thanks in advance.

Best Regards,

Aditya Achanta