cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

See SQL DBs in FNMS

Hello All, Does any of you know if we can see the actually MS SQL DBs installed on a server? I had this question already few times from different teams in our Organization. If OOB not is there away to inventor them with Flexera agent? Regards Frank van Heertum

(2) Replies
mfranz
By Level 17 Champion
Level 17 Champion

Hi Frank,

Afaik, the databases are not part of the inventory.

One approach could be file scanning for *.MDF files in standard SQL server file locations and then somehow report on this data. However, there might be caveats to that, file scanning on servers is a problem on it's own. Also it might be questionable how DB file names will actually help you in your effort to iedntify databases (depending on naming schemas etc.). One might also wonder if FNMS would be the right tool for this.

Best regards,

Markward

Thanks Markward,

Yes that is also what I had in mind nevertheless many teams in my organization are requesting this so I thought maybe somebody out there had the same question and found an easy working solution.

Regards

Frank