Is it possible to make an SQL query to a different database and report the results back on NPM webpage?

you could build a portion of a web page with a programatic backend (CGI) that queries whatever database it needs and include it as a page resource in an existing view.

Kind of like a page within a page.

I Do this today with my cmdb data but it's easiest if it's also a MS SQL db. Link from your orion db to the other db then use a sql report to query just the remote or a join of the local orion and the remote. Embed report in your webpage and Bob's your uncle.

Setting up a Linked Server for a Remote SQL Server Instance — DatabaseJournal.com

I will definitely take a look into that Thanks a lot!

As long as you have a foreign key, in my case it's a custom property for asset tag, then you can join the remote db tables exactly as you would local tables. Only

Difference after setting up the link server once, is to query them such as

Inner join remote servername.db.dbo.Orion.table on ...