Solved

Tenant Creation Date

  • 23 September 2022
  • 10 replies
  • 61 views
K
Rank

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.

icon

Best answer by Kandy Beatty 23 September 2022, 18:10

View original

10 replies

RohitBhandurge
Rank
Userlevel 5
Badge

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

Rohit Bhandurge - Forever Grateful!
RohitBhandurge
Rank
Userlevel 5
Badge

@kenr - UPHistory gave me this information.

 

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

Rohit Bhandurge - Forever Grateful!
Kandy Beatty
Rank
Userlevel 7
Badge +16

@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 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
RohitBhandurge
Rank
Userlevel 5
Badge

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

 

Rohit Bhandurge - Forever Grateful!
K
Rank

@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
Rank
Userlevel 5
Badge

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

Rohit Bhandurge - Forever Grateful!
Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @kenr  and @RohitBhandurge 

Here is a quick GI that may help:

 

 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
RohitBhandurge
Rank
Userlevel 5
Badge

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.

Rohit Bhandurge - Forever Grateful!
K
Rank

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

@RohitBhandurge Thank you for finding the table.

khalme
Rank
Userlevel 2

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

 

Kevin Halme

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved