Written by James McDonald

January 31, 2022

The problem with N-Central Report Manager is that it is only supported using a rather old version of SQL (Something like 2016). If you use the MAPS (Microsoft Action Pack Subscription) you only get licenses for the latest versions (SQL Server 2019)

Inspired by a reddit post

Option 1: Data Export to SQL Server

I would need to check that this would allow to export to SQL Server 2019 but this would be OK if staying in a Windows centric world. I wonder if this would keep exporting and so keep data greater than 90 days.

Under https://<yourncentralserver>:10000/ Setup => Data Export you can configure a connection to an SQL server

Option 2 – Postgres Restore from Backup Dump

A work-a-round perhaps… I haven’t as yet tried this but it looks completely feasable

If you untar the nightly FTP backup and go to ncbackup-202112102219-daily\tmp\ncbackup you will find the postgres dump files. (.bin and .schema files)

It would be possible to grab the backup, untar and restore it to a postgres sql db (running on Windows or Linux).

Once you have nosed around the schema a bit and perhaps connected it to something like the open source community edition of Pentaho Report Designer. You could get better access to the data than provided by the default NC reports.

This of course surmises that the data in the dump isn’t encrypted or has some other impenatrable obsfucation done to it to make this idea impossible


Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Meraki Open Source Licenses

Until today I assumed that Meraki was built in-house with only closed source software. But having a look at the...


If you have Veeam backup failing with the Updating BCD failed with Cannot update SafeBoot flag and SentinelOne is...