Client Management Suite

I am looking for a report in Altiris that matches the disk number to the drive letter.

Basically Disk 0 = Drive C

Disk1 =Drive E

I have 2 other reports I am trying to get data out of and one lists drive letter and the other uses Disk number (like it is listed if you run diskpart).

Is there anywhere in Altiris where I could dig this up?

Here's a table I found in the DB that might get you what you want. The disk # and partition # are in the same column so it might be a little hard to match up in SQL for your report.

SELECT *
  FROM [Symantec_CMDB].[dbo].[Inv_HW_Logical_disk_based_on_partition]

_ResourceGuid    Antecedent    Dependent
381CE358-2640-4111-B462-00052B10AE68    Disk #0, Partition #1    C:
381CE358-2640-4111-B462-00052B10AE68    Disk #1, Partition #0    D:
381CE358-2640-4111-B462-00052B10AE68    Disk #2, Partition #0    E:
381CE358-2640-4111-B462-00052B10AE68    Disk #3, Partition #0    F:
381CE358-2640-4111-B462-00052B10AE68    Disk #4, Partition #0    G:

Thanks for your response.  That does seem to give me the informaiton I wanted.  The issue now is that I have some information gathered using custom data classes that I can't seem to match up with this table.

The situation is that I have a table with disk status that lists the disk by "ID" like Disk 0 Disk 1 etc.

I have another system that reports some other disk info as Drive C drive D etc.

The goal I was trying to reach was to be able to use the data about which drive letter is on which physical drive to tie the other two reports together.  This seems to be very difficult.