How to find all PCs with a Disk Array

Use this query to find all PCs with a Disk Array

 

SELECT distinct

            v_GS_COMPUTER_SYSTEM.Name0 as ‘PC Name’

            , v_GS_COMPUTER_SYSTEM.UserName0 as ‘User Name’

 

FROM

            v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM,

            v_GS_DISK v_GS_DISK

WHERE

            v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_DISK.ResourceID

            AND ((v_GS_DISK.Description0=’Disk Array’))

Leave a Reply

Your email address will not be published. Required fields are marked *