Skip to main content
1-Visitor
Dec 16, 2016 6:05 PM UTC
Question

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

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

4 replies

MarcoTosin
21-Topaz II
Dec 16, 2016 6:29 PM UTC

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.

Translate
Marco
22-Sapphire I
Dec 16, 2016 8:07 PM UTC

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

Translate
sfaulkner1-VisitorAuthor
1-Visitor
Dec 16, 2016 9:50 PM UTC

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!

Translate
MarcoTosin
21-Topaz II
Dec 19, 2016 11:30 AM UTC

Scott,

attached report build following Mike's rules.

Translate
Marco