User location table?

I need the location field which contains the name.  the user contains the location_iD but not the name itself. Ive been looking all over the schema and cant find it.  Desperately need it for a query.  Anyone?

0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 1 month ago
Red Belt

Locations are an Asset with an asset_type_id == 1
So the Name column would contain the location name.

The following SQL will display the name for each matching row in the table ASSET in the database named ORG1.

select name from ORG1.ASSET where asset_type_id = 1

Posted by: barchetta 1 month ago
Blue Belt

Thank you.. got it.

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ