The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

wfa query

venkate_SAN

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

2 REPLIES 2

geringer

Try this:

 

Where    

    array.id = disk.array_id

    AND array.name = '${FilerName}'

    AND role.disk = 'spare'

 

Mike

venkate_SAN

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.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public