How to get a listing of all BW queries posted on the Portal
I know it's possible to get a listing of all BW queries but I'm looking for a subset of that list regarding only those queries posted on the BW Portal. Currently the most efficient way we can figure out is to view a Portal page source and search for key naming conventions to locate the technical names of the queries. But as you can imagine this is pretty clumsy. We're using KM and I'm aware KM stores Portal info. in a db but I haven't found any info. about how to query the db to get the list of queries we've posted to the Portal.
Thanks in advance