Just one last thing, please: the SQL query from [Inv_OS_Timezone] does not return the data of devices. How can I join that table considering that my main query is "FROM vComputer"?
This is my current query:
SELECT
v1.[MAC Address],
CONVERT(VARCHAR(10), v1.[CreatedDate], 3) AS [Discovered],
v1.[Name],
v1.[IP Address],
v1.[OS Name],
v1.[OS Version],
[dca4_AeX AC Identification].[OS Build Number],
v1.[System Type],
s.[Model] [Computer Model],
[Timezone].[Standard name],
[Timezone].[Standard Caption],
FROM vComputer v1
LEFT OUTER JOIN dbo.vHWComputerSystem s
ON (v1.Guid = s.[_ResourceGuid])
LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
ON (v1.Guid = [dca4_AeX AC Identification].[_ResourceGuid])
WHERE v1.[MAC Address] <> ''
ORDER BY v1.Name