# Checking the Database Specifics - unsure if using main DB

**URL:** <https://forum.inductiveautomation.com/t/checking-the-database-specifics-unsure-if-using-main-db/20536>\
**Category:** Ignition\
**Tags:** database\
**Created:** [November 5, 2018, 5:03pm UTC](https://forum.inductiveautomation.com/t/checking-the-database-specifics-unsure-if-using-main-db/20536 "2018-11-05T17:03:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [November 5, 2018, 5:03pm UTC](https://forum.inductiveautomation.com/t/checking-the-database-specifics-unsure-if-using-main-db/20536/1 "2018-11-05T17:03:18Z")

</div>

Here’s my current situation, I have multiple servers with Ignition on it, a production server, a development server, and a testing server. On each server they have a connection to a database called Tab, which is the main database our production server uses. I want to be able to dive deeper and look at my dev/test server database connections to this ‘Tab’ database. and make sure that it is NOT the same as the actual live database we have customer files in. How can I view the specifics to make sure that is the case?

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [November 5, 2018, 5:40pm UTC](https://forum.inductiveautomation.com/t/checking-the-database-specifics-unsure-if-using-main-db/20536/2 "2018-11-05T17:40:01Z")

</div>

If you have the proper rights to the server you can query against it for the IP Address

SELECT CONNECTIONPROPERTY(‘local\_net\_address’) AS local\_net\_address

This is MS SQL.