Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL report by Formfactor.

Created: 03 Dec 2012 • Updated: 06 Dec 2012 | 2 comments
This issue has been solved. See solution.

Helo.

I would like to produce a report that shows the below information.:

pc name, username, form factor, computer model, serial number

I do know there is a report included that shows something similar but this doesn't have the username included.

This is a report to seperate out laptops and desktops, so we can see which person is due for a laptop upgrade.

Please assist.

Thanks.

Comments 2 CommentsJump to latest comment

Andrew Bosch's picture

SELECT i.Name
,i.[User]
,dbo.fnInv_LocalizeEnum('listitem.chassis.chassistypes',ch.[Chassis Package Type],'77B56FF3-33E5-4BB0-BCA6-DE0E6DBB3CBA','en-US') AS [Form Factor]
,s.Model
,ch.[Serial Number]

FROM vComputer i
JOIN vHWComputerSystem s
   ON s.[_ResourceGuid] = i.Guid
JOIN vHWChassis ch
   ON ch._ResourceGuid = i.Guid
ORDER BY i.Name

------------------------------------
Sr. Principal SQA Engineer
Symantec

SOLUTION