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

# Which windows devices have less than 8 GB of memory - Direct Data Access (DDA)

```curl SQL
SELECT
NAME,
device.DEVICE_NAME,
DOMAIN,
URI,
OS_NAME,
OS_VERSION,
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
JOIN "SHARED_ANALYTICS_DATA"."SHARED_DATA"."DIM_CUSTOMER_LATEST" as customer ON customer.CUSTOMER_DK = fact.CUSTOMER_DK
WHERE OS_NAME LIKE '%Windows%'  and 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
```

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

# SQL Script