I checked my SDW environment and I can see snapshots I created manually from the CLI with the same naming convention as SMSQL, but only from the "connect disk wizard":

When I try to look at them from the actual connected disks, I only see snapshots from my SMVI backups:

But I can see snapshots created with SDW:

This might just be expected behavior. From the docs:
https://library.netapp.com/ecm/ecm_download_file/ECMM1278950 - page 141
Restrictions on Snapshot copy creation
You must keep in mind some restrictions for creating Snapshot copies.
• You can keep a maximum of 255 Snapshot copies with Data ONTAP. After the number of Snapshot copies has reached the limit, the Snapshot Create operation fails, and you must delete some of the old Snapshot copies before you can create any more.
• SnapDrive does not support Snapshot copies that are created from the storage system console, because such a practice can lead to inconsistencies within the NTFS file system. Therefore, use
only SnapDrive to create Snapshot copies of LUNs.
• You cannot create a Snapshot copy of a LUN connected to a Snapshot copy.
• SnapDrive automatically turns off the Snapshot copy schedule on a storage system volume that stores LUNs, so that the storage system does not create automatic Snapshot copies.
Note: Any Snapshot copies inadvertently made at the storage system console, or through System Manager or FilerView are dimmed (unavailable) in the SnapDrive MMC plug-in and are not usable by SnapDrive.
Is there any particular reason why you need to see these snapshots from SnapDrive?