Hi Team,

We currently have an FNMS environment where the FNMS application/databases are hosted on separate servers, while our SSRS reporting services and reporting databases are hosted on a different server.

For management reporting, we currently retrieve data from the FNMS databases using multiple stored procedures and staging/reporting tables, and expose the results through SSRS reports.

Over time, we have started seeing some inconsistencies with the reporting data, and since there is limited documentation available for the existing implementation, we are considering restructuring the SSRS reporting solution.

We are planning to organize the reports into areas such as:

1. Discovery – multiple reports/views related to inventory and discovery data
2. Monitoring – multiple operational/monitoring reports
3. Publisher – publisher/software-specific reports and views

We would like to understand the recommended approach for building an SSRS reporting solution around FNMS data, particularly around:

• Recommended FNMS database views/tables or reporting interfaces for reporting purposes
• Best practices for extracting FNMS data into a separate reporting database
• Whether direct database queries, stored procedures, staging tables, or another supported approach is recommended
• Any reference architecture, documentation, sample queries, or SSRS reporting examples available from Flexera

If anyone has implemented a similar FNMS + SSRS reporting architecture, any guidance or documentation would be greatly appreciated.

Thanks in advance!