Home Computer Audio Asylum

Music servers and other computer based digital audio technologies.

RE: Nope!, Never had that problem .......................

They sure are screwed up, no argument there.

Powershell (see below) plus SQL Server could do the job. Maybe I will give it a try. Have to work on the data model first. I am surprised I am the only one to have this problem/need.

p.s. I always got a kick out of colleagues who called themselves software engineers. I spent 20+ years as a programer (now retired). But engineering is based on mathematics and physics. We have a long way to go
in th software industry before we have a right to call ourselves engineers IMHO. There hasn't yet been a software program written that can be proved mathematically to be correct.

Anyway, as expected, powershell can do the job. No question it can read file metadata and record into database...


PS C:\Users\Lt> Get-WmiObject Win32_DiskDrive | sort Index | ft Index,DeviceID,@{l='Signature';e={"{0:X}" -f $_.Signature}},Model -a

Index DeviceID Signature Model
----- -------- --------- -----
0 \\.\PHYSICALDRIVE0 WDC WD80EFZX-68UW8N0
1 \\.\PHYSICALDRIVE1 68354F71 Crucial_CT480M500SSD1
2 \\.\PHYSICALDRIVE2 4EC01F6F CT1000BX100SSD1
3 \\.\PHYSICALDRIVE3 97B36446 HGST HTS725050A7E630
4 \\.\PHYSICALDRIVE4 F15D9 WDC WD1002FAEX-00Z3A0
5 \\.\PHYSICALDRIVE5 1F33A37 Samsung SSD 850 EVO M.2 500GB
6 \\.\PHYSICALDRIVE6 A4B57300 Seagate FreeAgent Go USB Device


This post is made possible by the generous support of people like you and our sponsors:
  Schiit Audio  


Follow Ups Full Thread
Follow Ups

FAQ

Post a Message!

Forgot Password?
Moniker (Username):
Password (Optional):
  Remember my Moniker & Password  (What's this?)    Eat Me
E-Mail (Optional):
Subject:
Message:   (Posts are subject to Content Rules)
Optional Link URL:
Optional Link Title:
Optional Image URL:
Upload Image:
E-mail Replies:  Automagically notify you when someone responds.