topic Re: Identify LUN for each dt.entity.disk on a windows server in DQL

Identify LUN for each dt.entity.disk on a windows server

AlanFoley — Thu, 28 Nov 2024 10:39:25 GMT

Hi All

I have a simple DQL Disk query which provides basic Disk info - I need more 🙂

fetch dt.entity.disk
| fieldsAdd belongs_to[dt.entity.host]
| filter belongs_to[dt.entity.host] =="HOST-xx"
| filterOut startsWith(entity.name,"\\")

I would like to know if the following info is accessible within Dynatrace

1. On a windows server to be able to identify the Logical Unit Number (LUN) for each drive as seen by the OS

2. Identify if the windows drive is physically on the server or is a mapped drive (excluding \\servername\folder type mappings)

If the info above is not accessible by default in Dynatrace how could it best be extracted within Dynatrace

Yes I can run a PowerShell script against each server to extract this but ideally I want to be able to consume this within Dynatrace

Any suggestions?

Appreciate the help

Thanks

Alan

Re: Identify LUN for each dt.entity.disk on a windows server

MaciejNeumann — Fri, 29 Nov 2024 06:58:47 GMT

Hello @AlanFoley,

I've asked your questions our developers, and this is the information that they've provided:
" 1. On a Windows server to be able to identify the Logical Unit Number (LUN) for each drive as seen by the OS -> not possible
2. Identify if the Windows drive is physically on the server or is a mapped drive (excluding \\servername\folder type mappings) -> not many options here other than what is already done (starts with "\\"). Alternatively, this condition can be checked: verbatimFilesystem != ntfs && verbatimFilesystem != smb
In general, in Dynatrace DISK entity does not represent a physical device but rather a logical partition or a mount point on Linux. It's not actually hardware monitoring but monitoring of the OS-related entities."

Re: Identify LUN for each dt.entity.disk on a windows server

AlanFoley — Fri, 29 Nov 2024 09:01:45 GMT

Thank you for the feedback
I can extarct the details as follows for Azure and then I will use ServiceNow to populate the LUN information into our CMDB - similar to the PowerShell command below

Use the following command to list disks and their LUNs:

Azure PowerShell:

Get-AzVM -ResourceGroupName <ResourceGroupName> -Name <VMName> |

Select-Object -ExpandProperty StorageProfile |

Select-Object -ExpandProperty DataDisks |

Select-Object Lun, Name

Windows Server PowerShell:

On the Windows VM, use:

Get-Disk | Select-Object Number, FriendlyName, OperationalStatus, Size,

@{Name='DriveLetters';Expression={($_ | Get-Partition).DriveLetter}},

@{Name='LUN';Expression={$_.UniqueId}}

Re: Identify LUN for each dt.entity.disk on a windows server

AlanFoley — Fri, 29 Nov 2024 09:02:10 GMT

we can close this request