SQL Query - Need help

[San_Bangalore]

Hi Everyone,

Could I request for a SQL query to get all the vault store and SQL server names where the DB’s are hosted?

Thanks for all the help in advance.

[GertjanA · Accepted solution]

In the EV program files folder, find ServiceLocations.sql

Run that against your Directory database.

will give lots of info, amongst which Vault Store Name, , database location (sql + instance) and databasename

[San_Bangalore]

This is  agreat info, Thank you sir

[GertjanA]

Your welcome.

Can you mark the post as 'solution'. This to avoid others trying to answer, and to assist others who have the same question.

Thanks !

GJ