Skip to main content
S
sdrzewiczewski10-Marble
10-Marble
February 16, 2011
Question

Report for ACLs

  • February 16, 2011
  • 10 replies
  • 3433 views
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.

10 replies

S
sdrzewiczewski10-MarbleAuthor
10-Marble
February 16, 2011
found a copy of the qml on my computer.
P
PreetiGupta15-Moonstone
15-Moonstone
February 16, 2011
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
C
cadjett1-Visitor
1-Visitor
February 17, 2011

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

R
rleir17-Peridot
17-Peridot
October 2, 2023

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

MarcoTosin
21-Topaz I
MarcoTosin21-Topaz I
21-Topaz I
October 3, 2023

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
S
ShaylynJoy1-Visitor
1-Visitor
February 24, 2011

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.

S
ShaylynJoy1-Visitor
1-Visitor
February 24, 2011

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

G
gsudheer.081-Visitor
1-Visitor
September 18, 2014

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
N
nsridhar1-Visitor
1-Visitor
September 18, 2014

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


Thanks a lot,


Naveen

MarcoTosin
21-Topaz I
MarcoTosin21-Topaz I
21-Topaz I
September 18, 2014

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
R
rleir17-Peridot
17-Peridot
October 4, 2023

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

 

MarcoTosin
21-Topaz I
MarcoTosin21-Topaz I
21-Topaz I
October 4, 2023

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
    P
    pwilliams-313-Aquamarine
    13-Aquamarine
    September 18, 2014
    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]
    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    September 18, 2014

    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
    Terms & ConditionsAccessibility statement