How to retrieve location ID in Resource Central backend

Modified on Thu, 22 Aug, 2024 at 11:26 PM

 

Summary

To retrieve location ID, go to RC Admin page → Reports → SQL. Type the following command in SQL statement:

select id, Caption, IsApplicationNode, NodeType from Tree

Click [Run], a table with IDs of all tree nodes is displayed:

You can look for the ID of any tree node from the table.

 

Properties

Applies to: RC 4.0+

Reference: TFS #144230

Knowledge base ID: 0225

Last updated: Sep 12, 2017

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article