![]() ![]() When tblEncryptableVolume.ProtectionStatus = 0 Then 'OFF' ![]() Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon, No guarantees this is what you're after, but hopefully it helps guide you in. TblDiskDrives, despite what the table name suggests, offers volume information rather than drive information. TblFloppy offers physical characteristics of the drives: model, serial, partitions, size, etc. You can't, in fact, as they're recording two different things: tblFloppy is a record of the physical characteristics of the drive while tblEncryptableVolume is a record of volume (not drive) drive letters and their encryption status.ĭepending on what you want/need, you might try using tblDiskDrives instead of tblFloppy. You don't have a relationship between tblEncryptableVolume and tblFloppy. But is there a report out there that I can pull that info that is already shown under Config->Disk? And then include that with the Volumes Encryptable report? I see that when I go to the computer and then Config->Disk that it shows drive letters and Description like Removable and Fixed. Seems there should be a way to grab data from 2 tables and then match on computer name and something else. ![]() I just copy/paste and hope it doesn't error and I got it right. Worst case, it may be necessary to manually build yourself a cross-reference list of something like (AssetName+DriveLetter) = tblFloppy.Name so that you can make the inter-table link you need. Looking at my own inventory, I don't think I could safely make the assumption that any given PHYSICALDRIVE x value can consistently be assumed to be any given drive letter, especially beyond C. \\.\PHYSICALDRIVE0) and tblEncryptableVolume.DriveLetter (e.g. If you only have one volume (drive letter assigned to a partition) per physical drive and if they're consistently assigned sequentially, you can make a relationship between tblFloppy.Name (e.g. ![]() The closest you're likely to come involves making assumptions. The data comes from two different sources, each reporting different things. Unfortunately, there isn't a direct relationship. There must be a way to join a relationship between the data. I need the physical Interface Type and the Drive Model information of the Physical Disk that the Logical Volume Drive Letter is using. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |