Analyze query in table and export to excel
Problem:
Exporting CMS DB query results to excel is challenging, though it is covered by some third-party tools.
What about exporting one-to-many relationships?
With BiWhy 24.70.43 version, you can do it in a few clicks.
Run query. If you don’t know which one, use BiWhy help/query examples/CMS DB snapshot
Browse through available properties. If don’t already know which one to use
Select fields to export to the table or use * to get everything from the query
Select a field with multiple values, if you want to flatten one
Not flattened field: shows a list of values
Flattened filed: a new row is created for each entry
Export to Excel, if needed.
See User/User-Group example below. The table has a row for each valid combination of user and user group.
BOBJ has 113 specified parent-child relationships (BOBJ-specific SQL syntax), which produce one-to-many results.
See some on the screenshot.
Parent/child example:
SELECT … FROM … WHERE parents("SI_NAME='Service-Server'", "SI_NAME='NODE001.EventServer'")
SELECT … FROM … WHERE children("SI_NAME='Service-Server'", "SI_NAME='AuditingService'")
Plus there are many other dependencies, which you can find in properties, for example, User/Recent Documents, …
Now all of it can be easily analyzed or exported, of cause, it is handy to export simple properties too.
Comments