hello,
I am trying to create a View table in MSSQL for the contents searched in WebReport. However, I see a lot of linked content. Is there an easy way to create it?
There is a WEBREPORTS table in BESReporting, but I don’t know where I can find related information.
There is not a simple mapping between these columns and the table data. The BESReporting database contains definitions of these reports, schedules, etc. but does not contain the data produced in the report.
The data itself comes from the BFEnterprise database; Web Reports acts like a Console session, retrieving data from the BigFix server as needed and caching some results, but the data access itself is a combination of Session Relevance and SQL queries against the root server’s data. There is not a copy of the resulting data in the BESReporting database.
You can reproduce the information from any Web Report using REST API and session relevance, but will not be able to do it directly with a SQL query.
