Thanks @Steve Giller
I was hoping there would be a way of extracting the employee ID from the CMDB by creating a view in Asset Management and download the view created.
Is there any way this can be a development instead of creating reports? Not every user on our Service Manager Instance has access to create reports, so when we do asset audits, we download for example laptop report by creating a view in Asset management then downloading. We get to select the "used by" field in that report but it does not provide their employee ID.
When you are adding the user to an asset in Used by field, it does display their name and with their employee ID. Shame it does not provide the same info in the downloaded csv.
Not sure if this can be considered as a development.