SQL query filter

Question

Hi,

Can you please help of SQL filer for Top 10 Volumes by Disk Space Used ,

below syntax I check below syntext work but need to filter out Node name start from " 'SVRE-NL" but it not working,

can someone help on filer out the node caption part, please

(OS like '%Windows%' OR OS like '%ESX%') AND Server_Managed_by like 'Windows' AND Volumes.VolumeType='Fixed Disk'  AND (Nodes.Caption like'SVRW-NL-*'OR Nodes.Caption like 'SVRE-NL-*') and VolumePercentUsed >= Percentage_Threshold

khanwasimit · Answer

Thanks Dan but finally I got the success node database name change after upgrade as NodesData.

i_like_eggs · Answer

why not use the 'NOT LIKE' ?

so something like:

select Caption

from Nodes

where Caption NOT LIKE 'SVRE-NL'

cheers,

Dan