Hello,

we would like to display a list of computers where the disk space is running low. The query will be run directly against the ZenWorks database (zendb). We are using ZCM 2017 and a MS SQL Server.

The current query looks like this:

Code:
SELECT 
	TOP 10
	MachineName, FreeHardDiskSpace, TotalHardDiskSpace, LastSuccessfulScanDate
FROM NC_Workstation
where 
	IsDeleted is null
ORDER BY FreeHardDiskSpace ASC
This query lists all computers where the disk space is running low. There are also some test computers in the results where the low disk space doesn't matter. How do I need to amend the aformentioned query, so that test computer are excluded from the result list?

Thanks.