Skip to main content
Answer

Tenant Creation Date

  • September 23, 2022
  • 10 replies
  • 105 views

Is there a way to find the creation date of a tenant?  We’re interested in knowing the creation dates for the tenants in our sandbox.  Thanks.

Best answer by Kandy Beatty

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

10 replies

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • September 23, 2022

@kenr - Surprised to see there is no table called UPCompany in the sql.


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • September 23, 2022

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end. You can pull this in GI.


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • September 23, 2022

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • September 23, 2022

@kenr - UPHistory gave me this information.

 

There should be a way to pull this on the front end.

The only thing to add is that you would need SQL access @kenr 

@kbeatty21 @kenr - Right. You can write a GI for “UPHistory” table.

 


  • Author
  • Freshman I
  • September 23, 2022

@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • September 23, 2022

@RohitBhandurge

“There should be a way to pull this on the front end.”

 

That’s what I’m looking for, but haven’t found it.

Try with a GI for UPHistory.


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • Answer
  • September 23, 2022

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • September 23, 2022

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

@kbeatty21 - This could do the job since UPHistory is the only table keeping the history of tenants.


  • Author
  • Freshman I
  • September 23, 2022

@kbeatty21 Thank you!  The GI is very helpful.  I appreciate your help.

@RohitBhandurge Thank you for finding the table.


khalme
Freshman II
  • Freshman II
  • September 23, 2022

Another option, if you only need to quickly find the dates, is to use the Source Data link on the Schema Browser (if your version has it).