Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
I will attach what I have so far in a few minutes but the list is definitely not long enough.
Scott, have you seen this group in the community? Reporting
There is also this document with lots of query builder ready to use Resource for reporting
Maybe there is not exactly what are you looking for, but something similar that you can use.
Yes, very necessary to be able to find the folders which do not inherit ACL's. This seems to work.
Query Builder Report:
Type: SubFolder (wt.folder.subfolder - there are multiple similar)
Select: Context Name, Name
Criteria:
- inherited domain <> 0
- type definition reference key id <> 0
REFERENCE SQL: select * from SUBFOLDER where INHERITEDDOMAIN = 0 and IDA2TYPEDEFINITIONREFERENCE <> 0
Mike, I don't have enough experience with query builder to do what you ask. I need more details. I can't seem to find "type definition reference key id" in Attributes.
Also, what program would I use to run the SQL? SQL Explorer?
Thank You Much!
Scott,
attached report build following Mike's rules.