SQL statement for Hardware inventory
Hello
I want to make a report of my workstations. Could anybody give me please an SQL statement for a list containing following data:
workstation_name
Mac-address
IP-address
as well as the user and the department in case the asset is in use.
Thanks a lot, Marc
I want to make a report of my workstations. Could anybody give me please an SQL statement for a list containing following data:
workstation_name
Mac-address
IP-address
as well as the user and the department in case the asset is in use.
Thanks a lot, Marc