Insight Discovery can be configured with a SQL database as repository instead of file system?

[Carlos Sanchez Golding]

I am configuring Insight Discovery and the scanning results are going to the Insight Discovery file system's server, but I would like to save the asset information directly in SQL Database instead of the file system. Is that possible?

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

This would be a spectacularly bad idea.  Jira, including the apps and application you can add to it, including Assets (the current name for the old "Insight") cache and index their data outside the database.  Also, most apps have database structures that are not intuitive for humans.

TLDR: Never write to a Jira database.  For Asset reports, use the import functions as they were written for.

It is the worst possible way to add data to Jira because you probably don't know what you actually need to add, Jira won't be able to report on the data until you have run a full re-index, and there are only a tiny handful of cases where you do not have to take your Jira offline to run your SQL.

[Carlos Sanchez Golding]

Hi, thank you for your answer, but I don't want to write in Jira database, I am talking regarding Insight Discovery server which collect all asset scanning information and save it in the server's file system, then this information is read by Jira Service Management CMDB.

What I wanted to do is to save the information from the asset scanning in a SQL database instead of the server's file system

[Nic Brough -Adaptavist-]

Ok, but you did say " I would like to save the asset information directly in SQL Database instead of the file system"

Assets live in the Jira database, and Assets Discovery is built to work with that database, it is not intended for stuffing data into other places.

[Carlos Sanchez Golding]

I think you are not familiarized with Insight Discovery product, I am not talking about Jira database, I am just talking about the storage when you do assets scanning using Insight Discovery product.

BTW, I did say what you mention, but before I mentioned the Insight Discovery file system's server, not Jira.

[Nic Brough -Adaptavist-]

I work with Assets regularly, I'm quite familiar with it (there's a clue in that I'm using the current name for it)

The output of a discovery run is indeed a file, but it is one intended to be imported into Assets not some other database that isn't part of Jira.

[Benjamin]

Hi @Carlos Sanchez Golding ,

I haven't seen documentation on importing straight. The main approach is save to file and import it. Tried to see if there's possibly an approach to API but nothing pops up on search.