We actually had a pretty lengthy discussion on this recently, at HP Enterprise SSD - Critical firmware update
The short version is, “It Depends ™”
If it’s just Windows, and only directly-available drives, it’s pretty easy to retrieve with WMI.
If it’s in a RAID volume, you may need to add your RAID vendor’s WMI providers and know which classes to query to get the underlying hardware info. I think we ran it to ground for HP Smart Array in that discussion.
If you need Linux systems as well, we also retrieved those using a different method.