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

We are happy to announce the new Windchill Customization board! Learn more.

Report for ACLs

sdrzewiczewski
7-Bedrock

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 14

found a copy of the qml on my computer.

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

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

rleir
17-Peridot
(To:cadjett)

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

Marco_Tosin
21-Topaz I
(To:rleir)

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

 

 

Marco

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.


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

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

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


Thanks a lot,


Naveen

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

Marco
rleir
17-Peridot
(To:Marco_Tosin)

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

 

Marco_Tosin
21-Topaz I
(To:rleir)

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)

 

 

Marco

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]

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]
Marco
Top Tags