Get a list of all BAQs

[b.huang (Ben Huang)]

I would like to get a list of all BAQs with author, name, etc. Anyone knows which table contains those info and I should query from? Thanks,

[Aaron_Moreng]

Ice.QueryHdr

[b.huang (Ben Huang)]

Thank you very much. Is there any table showing when a baq was run last time?

[Aaron_Moreng]

Not to my knowledge.

[b.huang (Ben Huang)]

or what time a baq was created.

[Aaron_Moreng]

No that would also be some custom functionality you’d have to build, to my knowledge.

[b.huang (Ben Huang)]

Thank you a lot, Aaron. Happy Thanksgiving!

[Aaron_Moreng]

You too!

[ScottLepley]

Already have these, may as well share them, right?
FSIP-BAQs.baq (16.8 KB) FSIP-QueryTables.baq (17.4 KB) FSIP-QueryTablesWithField.baq (19.9 KB) FSIP-QueryPhrases.baq (12.2 KB)

[timshuwy (Tim Shoemaker)]

There is currently no way to tell when the last time a BAQ was used… but this may be getting even more difficult because BAQs are used in so many ways. QuickSearch, Dashboards, Reports were originally the only uses, but now they populate combo boxes, used in Product configurators, used by XLConnect, the UI, Kinetic, etc etc etc… Not sure if there is a plan to keep track of every time a BAQ is touched/used.

[danbedwards (Dan Edwards)]

You can add a BPM on Method DynamicQuery.GetQueryByID and then log query name and date to a UD table. This provide a pretty good way of monitoring usage but I assume you want history from before so this might be old news.
You can also enable change logs on the QueryHdr table using an old tip that was posted on this site about modifying zDataTable.

Implementing a change log on the PCLookup tables

We deployed our first Product Configurator in March and it is being heavily used by our salespeople. Of course, now everyone is excited to add more options and/or tweaking the options offered. Due to recommendations given at last years conference, we developed a lot of our functionality using the PClookup tables. This works great but very quickly we realised that this was a weak link in our change control process. The BPM option to add a change log in the data directive is not activated. I a…

[NateS (Nate Schoonover)]

@danbedwards

You can add a BPM on Method DynamicQuery.GetQueryByID and then log query name and date to a UD table.

Has anyone taken this approach to track BAQ usage? I am thinking about trying it, but I don’t want to cause any system issues. Like Mark said, the BAQs are used in a lot of places, so that GetQueryByID may be called a lot. If anyone has used this, did you filter out anything before saving it to your UD table?

I am thinking about turning on a tracker like this for a few months to get a good handle on all the required BAQs, then I can nudge the unused one much closer to the trash bin.