HPSM report query

Hi,

In HPSM report query, I use following query format:

cm3r;affected.item;device;logical.name;device;sm.device.display.name like "*locomotive*"

 

By this query format, how to filter "device" table both by "sm.device.display.name" field and "istatus" field please?

 

Thanks

Ada