How to see license info on SDE 10.3.1 Geodatabase

[KevinEscalera1]

Hi everyone, I have a question, is there a way to see the status of a license in Enterprise PostGreSQL Geodatabase?. I want to know when the license is going to expire and also be sure that the license has been replaced when I replace it with a new one.

thanks in advance.

[George_Thompson]

You can look in the sde_server_config table within the SDE schema.

Look at the AUTH_KEY field, there will be a date field in the string.

I.E.: arcsdeserver,101,ECP#,02-JULY-2016, .............

System tables of a geodatabase in PostgreSQL—Help | ArcGIS for Desktop

[PanagiotisPapadopoulos · Accepted solution]

connect from pgAdmin on your SDE geodatabase.

find on SDE schema the table sde.sde_server_config and preview the data.

the row with the value "AUTH_KEY" on prop_name field hosts the sde license

here you can see everything you want.

[KevinEscalera1]

Thank you and George, for your quick response, I was able to do it