Report for ACLs

[sdrzewiczewski]

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.

[sdrzewiczewski]

found a copy of the qml on my computer.

[PreetiGupta]

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

[cadjett]

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]

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]

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

[ShaylynJoy]

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.

[ShaylynJoy]

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

[gsudheer.08]

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

[nsridhar]

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

Thanks a lot,

Naveen

[Marco_Tosin]

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

[rleir]

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]

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)

[pwilliams-3]

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_Tosin]

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]