Names of local mssql databases

Content Authoring
1

(imported topic written by tigger0191)

I see in the Windows inspector library guide where several pieces of information can be gleaned with the “local mssql databases” inspector. So, to return the instance name, I used this relevance clause:

if exist local mssql databases then instance name of local mssql databases as string else “None”

What I need is to return the names of the individual databases. Does anybody know a good way to do this?

2

(imported comment written by BenKus)

Hi tigger,

This is not possible using relevance (it is too resource intensive for inspectors)… You will need to run an action that spits out this data to a file (perhaps using osql) and then return the file contents in a property.

Ben

3

(imported comment written by tigger0191)

Thanks Ben.