Create a new asset report. Only Hardware and its child asset types have the ‘Asset state’ property. Therefore, filter by the appropriate asset type. ‘Asset state’ should now be available in the report filters. Use this to get the required data.