I need a query builder report with Folder Names vs Domain Names, while folder is not inherited from parent.

[sfaulkner]

I will attach what I have so far in a few minutes but the list is definitely not long enough.

[Marco_Tosin]

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.

[MikeLockwood]

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

[sfaulkner]

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!

[Marco_Tosin]

Scott,

attached report build following Mike's rules.