Products
Applications
Support
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Fibre Channel Networking
Events
All Events
Enterprise Software
Mainframe Software
Fibre Channel Networking
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Discovery and Inventory Group
View Only
Community Home
Discussions
Library
Events
Members
Back to Library
Query to display which computers have a SSD drive
1
Recommend
Aug 12, 2013 06:47 AM
Marcello D'Angelone
According to
ssd-vs-hdd-report
,
Windows does not allow a reliable way to collect information about a SSD disks.
However we can identify the SSDs from the Inv_HW_Logical_Device data class.
You can copy the following query to create your own report:
SELECT
v
.
[Name]
AS
[Computer Name]
,
cs
.
[Model]
AS
[Computer Model]
,
hwl
.
Model
,
ld
.
[Device ID]
as
Drive
,
CAST
((
ISNULL
(
ld
.
[Size (Bytes)]
,
0
)/(
1024
*
1024
*
1024
))
AS
DECIMAL
(
10
,
2
))
AS
'Total Disk Space (GB)'
,
CAST
((
ISNULL
(
ld
.
[Free Space (Bytes)]
,
0
)/(
1024
*
1024
*
1024
))
AS
DECIMAL
(
10
,
2
))
AS
'Free Disk Space (GB)'
FROM
vComputer v
INNER
JOIN
Inv_HW_Logical_Device hwl
ON
v
.
Guid
=
hwl
.
_ResourceGuid
INNER
JOIN
vHWComputerSystem cs
ON
cs
.
_ResourceGuid
=
v
.
Guid
INNER
JOIN
Inv_HW_Logical_Disk ld
ON
ld
.
_ResourceGuid
=
v
.
Guid
WHERE
hwl
.
Model
LIKE
'%SSD%'
Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads
Tags and Keywords
Related Entries and Links
No Related Resource entered.
Copyright 2019. All rights reserved.
Powered by Higher Logic