Skip to main content
Solved

Tenant Creation Date

  • Sep 23, 2022 3:24 PM UTC
  • 10 replies
  • 165 views
  • Translate All

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:

 

 

View original

10 replies

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

Translate

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@kenr - UPHistory gave me this information.

 

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

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

@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 

Translate

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@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.

 

Translate

  • Author
  • Freshman I
  • Sep 23, 2022 4:03 PM UTC

@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.

Translate

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@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.

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18
  • Captain II
  • Answer
  • Sep 23, 2022 4:10 PM UTC

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

Translate

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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.

Translate

  • Author
  • Freshman I
  • Sep 23, 2022 4:24 PM UTC

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

@RohitBhandurge Thank you for finding the table.

Translate

khalme
Freshman II
  • Freshman II
  • Sep 23, 2022 7:16 PM UTC

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).

 

Translate