Skip to main content
Feb 16, 2011 8:08 PM UTC
Question

Report for ACLs

I know this report has been posted before, but I just did a search and can't seem to find it. I'm looking to get for a given context the list of all the ACLs.

I've seen Antonio's SQL, but it gives the permission mask, not the actual permissions. Not sure how to convert that.

14 replies

Feb 16, 2011 8:15 PM UTC
found a copy of the qml on my computer.
Feb 16, 2011 8:23 PM UTC
We developed an excel macro which runs a query builder report in the background and convert permission mask to actual permission. It also gives the report of what changed from the last time the macro ran. I showed this in my last year presentation in PTC/User Orlando.

It is too big to attach here. Please let me know if interested.

Thanks,
Preeti
Feb 17, 2011 6:06 AM UTC

Another route is the Windu DomainPolicyRule output parsed 2 XML java tool I wrote:

http://portal.ptcuser.org/p/fo/st/topic=16&post=90665

The download is: http://www.datajett.com/windchill/wc_dev/ACL_Windu_2_XML_TXT.zip

It has a readme, but I will show link here: http://www.datajett.com/windchill/wc_dev/ACL_Windu_2_XML_TXT/readme.txt

readme is limited, but basically you run windu & chck off domain policy for diagnostic run. The note the windu output folder & use it as arg for java classin zip.

Gerry from forum, did find that there might be an issue with loadfromfile that will not allow xml loadfromfile to use Rolesat Org Level ACL Policy creation. Group or User works ok at Org level, just not Role. All is well in Product/Library levels.

He is awaiting the R&D's response on that one.

But if you have not tried this route, while it takes the Windu Policy output & splits it up into separate domains/Context files, it also creates separate xml for loadfromfile.

Nice for viewing &/or copying ACL from one windchill install/server to another.

L Jett
cadjett@aol.com;datajett@aol.com

Oct 2, 2023 6:46 PM UTC

Hi L  @Marco_Tosin 

after 12 years, we still have Windchill but your link to ptcuser.org did not survive. I would be interested to see your tool please!

cheers -- Rick

1-Visitor
Oct 3, 2023 6:45 AM UTC

Hi @rleir 

I haven't the original report from ptcuser.org.

 

Take a look at above reply from cadjett and see if it helps.

 

https://community.ptc.com/t5/Windchill/Report-for-ACLs/m-p/399161/highlight/true#M46760

 

 

Feb 24, 2011 3:44 PM UTC

Hi Stephen,

I am running your .qml but only seeing the Libraries listed. I see in the criteria of the report that you do have Products called out but for some reason upon generation I only receive Library contexts. I am wondering if there is something I need to set?

Thank you for sharing this report.

found a copy of the qml on my computer.

Feb 24, 2011 3:50 PM UTC

I answered my own question by removing the "OR" statement. 🙂

Sep 18, 2014 9:02 AM UTC

Hello Preeti


We also have same requirement for generating ACL report can you please share the macro you have built for the same.


Rgds


Sudheer



In Reply to Preeti Gupta:


We developed an excel macro which runs a query builder report in the background and convert permission mask to actual permission. It also gives the report of what changed from the last time the macro ran. I showed this in my last year presentation in PTC/User Orlando.

It is too big to attach here. Please let me know if interested.

Thanks,
Preeti
Sep 18, 2014 9:34 AM UTC

Could you please share the macro with me too? Here is my email id -


Thanks a lot,


Naveen

1-Visitor
Sep 18, 2014 11:52 AM UTC

Could you please share the macro with me too?


marco.tosin@vimar.com



In the PTC community there is a Reporting Group.


I think we can join this group also and share things even in that place.


http://communities.ptc.com/groups/reporting



And maybe you can also vote up this idea.


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



Marco

Oct 4, 2023 11:05 AM UTC

Typo in the link! I thought it was a simple fix:

https://community.ptc.com/groups/reporting

 

But no, that is a 404 not found.  Do you mean

https://community.ptc.com/t5/Windchill-Tips/Resource-for-reporting/ta-p/817824

 

1-Visitor
Oct 4, 2023 12:06 PM UTC

If you mean the document summarizing the query builder reports that I wrote years ago, then the correct link is the second one you wrote.

 

That document then spawned PTC support's desire to better structure a series of summary articles on various topics, including the reporting tool.

You can start at this https://www.ptc.com/en/support/wnc-reporting-landing

 

And then from this [Knowledge Hub] Windchill PLM - Business Reporting(WBR)

 

It is the HUB article of all other thematic HUB articles (by module, functionality, object type)

 

 

Sep 18, 2014 12:30 PM UTC
This sql query will give you ACLs by domain in a format that can be used to create ACLs with LoadFromFile.

Patrick Williams | Engineering Systems | c: 616.947.2110
[cid:image001.jpg@01CFD31A.CB9A2100]
1-Visitor
Sep 18, 2014 12:33 PM UTC

Thanks a lot Patrick.

In Reply to Patrick Williams:


This sql query will give you ACLs by domain in a format that can be used to create ACLs with LoadFromFile.

Patrick Williams | Engineering Systems | c: 616.947.2110
[cid:image001.jpg@01CFD31A.CB9A2100]