Data Extraction

Export Device Data

# Export device properties to CSV
Get-LMDevice | Select-Object name, displayName, hostGroupIds, properties |
    Export-Csv -Path "device_properties.csv" -NoTypeInformation

# Export device instance data
$devices = Get-LMDevice -Filter "displayName -contains 'prod'"
foreach ($device in $devices) {
    $data = Get-LMDeviceData -Id $device.id -StartDate (Get-Date).AddDays(-7)
    $data | Export-Csv -Path "device_$($device.id)_data.csv" -NoTypeInformation
}

Export Alert Data

# Export critical alerts from last 24 hours
Get-LMAlert -Severity Warning -StartDate $(Get-Date).AddDays(-1) |
    Export-Csv -Path "critical_alerts.csv" -NoTypeInformation

# Export acknowledged alerts with notes
$alerts = Get-LMAlert -Filter "ack -ne '$true'"
foreach ($alert in $alerts) {
    $notes = Get-LMAlertNote -Id $alert.id
    [PSCustomObject]@{
        AlertId = $alert.id
        Resource = $alert.resourceTemplateName
        Notes = $notes.note -join "; "
    }
} | Export-Csv -Path "alert_notes.csv" -NoTypeInformation