Client Management Suite

Can someone create a custom report that shows the computer name and the keyboard attached?  I can see the hardware ID for the keyboard in Resource Manager, but that's only for one device and I want to gather information about all the PCs in my fleet.

Is this kind of what you are looking for?

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca3_OS System Device Windows].[Manufacturer],
   [dca3_OS System Device Windows].[Description],
   [dca3_OS System Device Windows].[Device ID],
   [dca3_OS System Device Windows].[Type]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_OS_System_Device_Windows] AS [dca3_OS System Device Windows]
         ON ([vri2_Computer].[Guid] = [dca3_OS System Device Windows].[_ResourceGuid])
WHERE
   (
      (
         ([dca3_OS System Device Windows].[Description] LIKE N'%keyboard%')
      )
      AND
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )

That's a good start, but I get an error when trying to execute it on line 18, "must declare the scalar variable "@v1_TrusteeScope".

Per chance, could you create the report, export it to an XML file, and then attach it to this post?

Sorry, yeah looks like I didn't copy the whole SQL code.

Attachment(s)

New Computer Report.xml   9 KB 1 version

That worked!  Thanks