Jump to content
gary@mti

Identify SSD disks

Recommended Posts

You can do and advanced search on Computers.

Computer.Drives.IsSSD=True. 

That will render this SQL query posted below.

SELECT 
   computers.computerid as `Computer Id`,
   computers.name as `Computer Name`,
   clients.name as `Client Name`,
   computers.domain as `Computer Domain`,
   computers.username as `Computer User`,
   Drives.SSD as `Computer.Drives.IsSSD`
FROM Computers 
LEFT JOIN inv_operatingsystem ON (Computers.ComputerId=inv_operatingsystem.ComputerId)
LEFT JOIN Clients ON (Computers.ClientId=Clients.ClientId)
LEFT JOIN Locations ON (Computers.LocationId=Locations.LocationID)
LEFT JOIN Drives ON (Drives.ComputerId=Computers.ComputerId)
 WHERE 
((Drives.SSD<>0))

You can also go to Dataview -> Drives -> Hard Disks and  select Drive Model for te affected HPE drives you want to search for.

Edited by p_ern

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...