Help with SWQL report on Windows, and Linux Servers

Dweik2022

So I found this SWQL on Thwack but it pulls in all servers, Windows, and Linux.  I am new to this and I am having trouble filtering.

I want to add something like " WHERE (Vendor LIKE 'Windows'), but I dont know how to add it in the current code.

I added the code below.  Thank in advance for helping

SELECT v.Node.Caption AS NodeName
     , v.DisplayName AS VolumeName
     , CASE 
          WHEN v.Size >= 1099511627776
               THEN CONCAT (
                         ROUND(v.Size / 1099511627776, 2)
                         , ' TB'
                         )
          WHEN v.Size >= 1073741824
               THEN CONCAT (
                         ROUND(v.Size / 1073741824, 2)
                         , ' GB'
                         )
          WHEN v.Size >= 1048576
               THEN CONCAT (
                         ROUND(v.Size / 1048576, 2)
                         , ' MB'
                         )
          WHEN v.Size >= 1024
               THEN CONCAT (
                         ROUND(v.Size / 1024, 2)
                         , ' KB'
                         )
          ELSE '0'
          END AS VolumeSize
     , CASE 
          WHEN v.VolumeSpaceAvailable >= 1099511627776
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1099511627776, 2)
                         , ' TB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1073741824
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1073741824, 2)
                         , ' GB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1048576
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1048576, 2)
                         , ' MB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1024
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1024, 2)
                         , ' KB'
                         )
          ELSE '0'
          END AS SpaceAvailable
     , ROUND(VolumePercentUsed, 1) AS PercentUsed
     , v.Node.DetailsUrl AS LinkForNode
     , v.DetailsUrl AS LinkForVolume
FROM Orion.Volumes AS v
ORDER BY VolumePercentUsed DESC

KMSigma.SWI

WHERE clauses typically go just before any sorting.  I wrapped this is some comments so it would be obvious.

SELECT v.Node.Caption AS NodeName
     , v.DisplayName AS VolumeName
     , CASE 
          WHEN v.Size >= 1099511627776
               THEN CONCAT (
                         ROUND(v.Size / 1099511627776, 2)
                         , ' TB'
                         )
          WHEN v.Size >= 1073741824
               THEN CONCAT (
                         ROUND(v.Size / 1073741824, 2)
                         , ' GB'
                         )
          WHEN v.Size >= 1048576
               THEN CONCAT (
                         ROUND(v.Size / 1048576, 2)
                         , ' MB'
                         )
          WHEN v.Size >= 1024
               THEN CONCAT (
                         ROUND(v.Size / 1024, 2)
                         , ' KB'
                         )
          ELSE '0'
          END AS VolumeSize
     , CASE 
          WHEN v.VolumeSpaceAvailable >= 1099511627776
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1099511627776, 2)
                         , ' TB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1073741824
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1073741824, 2)
                         , ' GB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1048576
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1048576, 2)
                         , ' MB'
                         )
          WHEN v.VolumeSpaceAvailable >= 1024
               THEN CONCAT (
                         ROUND(v.VolumeSpaceAvailable / 1024, 2)
                         , ' KB'
                         )
          ELSE '0'
          END AS SpaceAvailable
     , ROUND(VolumePercentUsed, 1) AS PercentUsed
     , v.Node.DetailsUrl AS LinkForNode
     , v.DetailsUrl AS LinkForVolume
FROM Orion.Volumes AS v
-- Filter added here
WHERE v.Node.Vendor = 'Windows'
-- ^ this is the filter
ORDER BY VolumePercentUsed DESC