1.查看磁盘外设被禁用的查询Sql语句：

select r.name , ri.ip_address ,  'Blocked' as "DiskDrive Enabling Status" from managedcomputer m left join resource r on r.resource_id = m.resource_id left join resourcemacip ri on ri.resource_id = r.resource_id left join resourceusbdevicedetails rd on r.resource_id = rd.resource_id where m.managed_status = 61 and rd.blocked_list like '%diskdrive%';

2.查看磁盘外设被启用的Sql语句：

select r.name , ri.ip_address , 'Allowed' as "DiskDrive Enabling Status" from managedcomputer m left join resource r on r.resource_id = m.resource_id left join resourcemacip ri on ri.resource_id = r.resource_id left join resourceusbdevicedetails rd on r.resource_id = rd.resource_id where m.managed_status = 61 and (rd.unblocked_list like '%diskdrive%' or rd.unblocked_list is null);