I decided to write the sql for this report manually since for some reason I didn't see vComputer as an option to select in the report builder (ns 6). I was able to put together the results I'm looking for in the query via SQL Server Management Studio. Here is my code:
SELECT
vc.[Name]
,vc.[User]
,vc.[OS Name]
--,vc.[OS Version]
,vc.[IP Address]
,cd.[Comment] AS 'Comment'
,hw.[System Manufacturer] AS 'Manufacturer'
,hw.[System Model Number] AS 'Model'
,max(mem.[Total Physical Memory]) AS 'Memory'
,hw.[Serial Number] AS 'Serial '
,hw.[Asset Tag] AS 'Asset Tag'
FROM [AltirisNSData_Production].[dbo].[vComputer] vc
INNER JOIN [AltirisNSData_Production].[dbo].[Inv_AeX_Computer_Description] cd
ON vc.[Guid] = cd.[_ResourceGuid]
INNER JOIN [AltirisNSData_Production].[dbo].[Inv_AeX_HW_Serial_Number] hw
ON vc.[Guid] = hw.[_ResourceGuid]
INNER JOIN [AltirisNSData_Production].[dbo].[Inv_AeX_AC_Primary_User] pu
ON vc.[Guid] = pu.[_ResourceGuid]
INNER JOIN [AltirisNSData_Production].[dbo].[Inv_AeX_HW_Memory_Changes] mem
ON vc.[Guid] = mem.[_ResourceGuid]
WHERE vc.[Name] LIKE 'of%'
AND cd.[Comment] LIKE '%'
AND hw.[System Model Number] LIKE '%'
GROUP BY vc.[Name],
vc.[User],
vc.[OS Name],
vc.[IP Address],
cd.[Comment],
hw.[System Manufacturer],
hw.[System Model Number],
mem.[Total Physical Memory],
hw.[Serial Number],
hw.[Asset Tag]
order by name desc
And yes I know, there is no Inv_AeX_Computer_Description out of the box. Thats a custom inv.
So when I try to put this sql in a report, it error's out. I out out "[AltirisNSData_Production].[dbo]." because it didn't seam necessary in the report and other reports never showed that.
The error I get in the console is "Incorrect syntax near 'cd'." But the code works working directly with the sql. Thoughts?