Skip to main content
S
sfaulkner1-Visitor
1-Visitor
December 16, 2016
Question

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

  • December 16, 2016
  • 2 replies
  • 2620 views

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

2 replies

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
December 16, 2016

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.

Marco
M
MikeLockwood22-Sapphire I
22-Sapphire I
December 16, 2016

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

S
sfaulkner1-VisitorAuthor
1-Visitor
December 16, 2016

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!

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
December 19, 2016

Scott,

attached report build following Mike's rules.

Marco
    Terms & ConditionsAccessibility statement