---
updatedAt: 2025-08-14T18:01:12.000Z
agentTools:
  siteIndex: https://developer.n-able.com/llms.txt
  projectIndex: https://developer.n-able.com/n-central/llms.txt
---

# Which laptops have less then 8 GB of memory Direct Data Access (DDA)

```powershell SQL
SELECT
device.DEVICE_NAME,
DOMAIN,
URI,
TOTAL_MEMORY_BYTES/1024/1024/1024,
FROM "SHARED_ANALYTICS_DATA"."SHARED_DATA"."DIM_DEVICE_SUMMARY_LATEST" as device
JOIN  "SHARED_ANALYTICS_DATA"."SHARED_DATA"."FACT_ASSET_COUNT_DAY" as fact
on device.device_dk = fact.device_dk
WHERE TOTAL_MEMORY_BYTES/1024/1024/1024 < 8  and fact.snapshot_date = ( select max(snapshot_date) from SHARED_ANALYTICS_DATA.SHARED_DATA.FACT_ASSET_COUNT_DAY ) and num_device = 1 and device_class ilike '%laptop%'
```

```json Response Example
{"success":true}
```

# SQL