AppManager ResourceName and ResourceID

AppManager ResourceName and ResourceID

I would like like to pull host names and hardware info out of the AppManager database to a MS SQL database for asset/inventory management purposes.  Is there a specific table within AMDB that ties the RESOURCENAME to the RESOURCEID and/or potentially the ATTRIBUTEID as well?

I am able to remotely connect and pull the tables from MySQL to MS SQL but I am thus far unable to find the link between the RESOURCEID and the RESOURCENAME.

thanks!

                New to ADSelfService Plus?