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.
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
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
Thanks for the code. This was good.
Would you like to reply?
Login or Register to post your comment.