I see DevId, but I would prefer not to dig through many tables to find which table or tables to join.
No Matches Found!
Try with a different search term
No Matches Found!
Try with a different search term
I see DevId, but I would prefer not to dig through many tables to find which table or tables to join.
Hi, thanks for the response. That table has a DevName field, but that is not the Device Name as displayed in the UI.
Hi Tim,
I'd kindly advise to use API over SQL, when possible, to minimize the risk, otherwise anything wrong on the DB side may affect your environment (if it's not only Select statement). From the API side you can see devices' information including the name under /devices GET API Call as following SS:
I hope it helps.
Zafer
Hello Zafer,
I will take a look at this as well. I am just looking for reporting purpose to see where to cross reference a device ID to the displayed Device Name from the UI.
Hi Tim,
Did you know there is also Device ID column on the view section as below:
You can also get export of the list of devices from MobiControl Webconsole when required. if i missed your request please let me know, I'll try to help with my best :)
Zafer
Yes, thanks. I see the Device ID all over the place in the DB, I would like to use that to join to whatever table has meaningful name that I am looking for.
The devname column in the Devinfo table contains that value. I have to use RTRIM(devname) when defining it in my query so it will trim off the extra space at the end.
Not in my copy, maybe that is part of the sanitization process I guess, but not sure why it would be.
That field has 'DeviceName##########' where #### is a nine digit integer value and that is not what is displayed in the UI.
If it's 9 digits after the device name as standard, you could use the query below in your select statement:SUBSTRING(DevName, 1, LEN(DevName) - 9)
That is interesting... I will ask SOTI Support. The text does start with the literal string 'DeviceName'.
It turns out that SOTI's script to cleanse the DB is generic as in it can be used by customers as well and the customers may want to hide their actual device names so the script makes them generic throughout the tables.
