When we apply advance filter on the fixed asset screens with the table Asset management asset. The exist and not exists join should fetch information based on the filter.

This would help to know the fixed assets which are related/not related to an asset