Client Management Suite

Can anyone assist in creating a report that gives us a list of all Laptop models with current hard drive size and type?

------

I can see

select * from dbo.vHWLogicalDevices

where dbo.vHWLogicalDevices.[Manufacturer] like '%(Standard disk drives)'

shows all of the HD models

------

select * from dbo.vHWComputerSystem

shows all of the computer models. 

---------------

I see that IT analytics can give a report of computer model and the drive size, but no physical disk type (hard drive model).

I don't see a common key to marry them together in a report.

I need the report to show

Computer Model, Laptop HD model, HD size.

Thanks in advance for your time!

The common field in all inventory tables is _ResourceGuid which is the Global Identifier of the computer.  Here is the query I use for HDD info:
 

-- Hard Drive Details

-- v2014_10_29

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'

SELECT DISTINCT

vc.Guid as [_ItemGuid],

vc.Name [Computer Name],

sn1.[Manufacturer],

sn1.[Model],

sn1.[Identifying Number] [Serial Number],

disk.Model [HDD],

diskstore.[Max Media Size (Kilobytes)]/1024/1024 [Size GB],

( SELECT TOP 1 CC.[StartTime] FROM [evt_ns_client_config_request] CC

WHERE CC.[ResourceGuid] = vc.[Guid]

ORDER BY CC.[StartTime] DESC

) AS [Last Config Request],

vc.Domain,

vc.[IP Address],

vc.[User] [Primary User],

vc.[OS Name],

vc.[OS Revision]

FROM vComputer vc

LEFT JOIN vHWComputerSystem sn1 ON sn1.[_ResourceGuid] = vc.Guid

LEFT JOIN Inv_HW_Logical_Device disk on disk._ResourceGuid = vc.Guid and disk.[Device ID] = '\\.\PHYSICALDRIVE0' and disk.Model not like 'VMware%'

LEFT JOIN Inv_HW_Storage diskstore on diskstore._ResourceGuid = vc.Guid and diskstore.[Device ID] = '\\.\PHYSICALDRIVE0'

WHERE vc.[IsManaged] = 1

AND VC.[OS Name] not like '%server%'

--AND ([vc].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))

ORDER BY vc.Name

Thanks for your help.  We don't need a list of every computer.  Just every laptop model and the HD type (SSD/spindle etc...)  Any way to query if it is an SSD and report on that?

Hi mhendel05,

There is no simple way of intentifiying if a HDD is a SSD or spindle.

Please check the following Link this may help..

http://www.symantec.com/connect/blogs/query-display-which-computers-have-ssd-drive

Network23