On windows there is a program called SqliteBrowser. On the WD My Cloud located at /var/local/autoMount/autoMount.db. This database contains information about all USB devices that have been attached to the My Cloud. This database contains a devices structure and a partitions structure. When mounting a USB device. The partition table is checked to see if the partition type is one of the following: XFS, NTFS, EXT2, EXT3, EXT4, HFS+, and VFAT (FAT16 & FAT32). It checks that the partition usage is filesystem. Checks that the partition is not a swap, vfat, EFI, or Boot OS.
I create two files one called select1.sh which contained
echo “SELECT connected, id, device_handle, partition_number, share_name, label, type, uuid, read_only, media_serving, description, public_access, mount_time, devname FROM Partitions WHERE connected=‘0’;”|sqlite3 /var/local/autoMount/autoMount.db
And one called select3.sh which contained
echo “SELECT connected, handle, vendor, model, serial_number, revision, ptp, smart_status, lock_state, password_hash, password_hint, standby_timer, vendor_id, product_id, usb_port, usb_version, usb_speed, timestamp, devname, devpath, scsi_devname FROM Devices WHERE connected IS NOT NULL;”|sqlite3 /var/local/autoMount/autoMount.db
The output of select1.sh looks like
0|2|2|1|VERBATIM|VERBATIM|vfat|3022-DC3F|false|any||true|1444947600|
0|3|3|1|My_Book|My Book|ntfs|54D8D96AD8D94ABE|false|any||true|1445790235|
0|4|2|1|STORE_N_GO||ext3|4de82c91-2a45-4c0dad85-229349cfa244|false|any||true|1445706318|
0|5|4|1|My_Book_2|My Book|ntfs|A2CA0AEBCA0ABC13|false|any||true|1451332048|
The output of select3.sh is
1|1|Generic|USBStorage|000000000272|2.72|false|unsupported|unsupported|||unsupported|05e3|0736|1|2.0|480|1456606070.91548||/devices/platform/xhci-hcd/usb1/1-1/1-1.4|/dev/sg1
0|2|Verbatim|STOREN GO|071058E9225F9527|1.10|false|unsupported|unsupported|||unsupported|18a5|0245|1|2.0|480|1445706313.27801|||
0|3|Western Digital|My Book 1140|574343315430343538343933|1.019|false|good|security_off|||unsupported|1058|1140|1|3.0|5000|1445790214.64051|||
0|4|Western Digital|My Book 1230|574343344532594141315543|1.065|false|good|security_off|||unsupported|1058|1230|1|3.0|5000|1451332036.4963|||
0|5|SanDisk|Cruzer Glide|4C532000050803116181|2.01|false|unsupported|unsupported|||unsupported|0781|5575|1|2.0|480|1455481843.72188|||
The output should only have 5 lines. Each line starts with 1|1 0|2 0|3 0|4 0|5
I hope this will help.
RAC
