Subscribe

wfa query

Can you help me to query to list the unassigned disk in workflow.

 

SELECT

   disk.pool AS pool  

FROM

    storage.disk as disk,

    storage.array as array

Where    

    array.id = disk.array_id

    AND array.name = '${FilerName}'

ORDER BY

    disk.pool

 

 

FilerA> disk show -n

  DISK       OWNER                    POOL   SERIAL NUMBER         HOME                    DR HOME

------------ -------------            -----  -------------         -------------           -------------

0b.02.6      Not Owned                  NONE   S3Z0Y0BH

0b.02.20     Not Owned                  NONE   S3Z0YLSM

0b.02.21     Not Owned                  NONE   S3Z0YLQ1

0b.02.1      Not Owned                  NONE   S3Z0TRYT

0b.02.23     Not Owned                  NONE   S3Z0Y0BY

0b.02.13     Not Owned                  NONE   S3Z0T190

0b.02.19     Not Owned                  NONE   S3Z0YLKR

0b.02.18     Not Owned                  NONE   S3Z0Y05J

0b.02.16     Not Owned                  NONE   S3Z0Y0AV

0b.02.22     Not Owned                  NONE   S3Z0Y3L8

0b.02.12     Not Owned                  NONE   S3Z0T07C

0b.02.9      Not Owned                  NONE   S3Z0Y1R6

0b.02.17     Not Owned                  NONE   S3Z0Y2X0

0b.02.15     Not Owned                  NONE   S3Z0T089

0b.02.10     Not Owned                  NONE   S3Z0XQ75

0b.02.4      Not Owned                  NONE   S3Z0TRXK

0b.02.14     Not Owned                  NONE   S3Z0VC1L

0b.02.11     Not Owned                  NONE   S3Z0Y0E9

0b.02.8      Not Owned                  NONE   S3Z0TS2F

0b.02.3      Not Owned                  NONE   S3Z0Y3QH

0b.02.7      Not Owned                  NONE   S3Z0X6MF

0b.02.5      Not Owned                  NONE   S3Z0YLY7

0b.02.0      Not Owned                  NONE   S3Z0YLM8

0b.02.2      Not Owned                  NONE   S3Z0TRN4

Re: wfa query

Try this:

 

Where    

    array.id = disk.array_id

    AND array.name = '${FilerName}'

    AND role.disk = 'spare'

 

Mike

Re: wfa query

Mike,

 

Thank you for the reply, already i have query for spare disk which will list the spare disks.

 

SELECT
COUNT(disk.name) AS 'Spare Disk Count'
FROM
storage.disk as disk,
storage.array as array
Where
role = 'spare'
AND array.id = disk.array_id
AND array.name = '${FilerName}'
ORDER BY
disk.name

 

I need query to list the unassifgned disk.