Highlighted
Intrepid explorer

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

Tags (1)
0 Kudos
2 Replies
Highlighted
Rising star

Re: See SQL DBs in FNMS

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

Softline Group is Europe's leading independent expert in Software and IT Asset Management.
Highlighted
Intrepid explorer

Re: See SQL DBs in FNMS

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

0 Kudos