Opmanager query

Hi,

i m using below query to take output for certain field of opmaanger , this query is general and it gives me output of all device in opamanger

if u can reply me sure it will be easy for u ..

mysql.exe -u root -P 13306 -e "use OpManagerDB;select oo.name as DeviceName,mo.displayname as DisplayName,topo.ipaddress as IpAddress,mo.type as DeviceType,sn.sysdescr as SysDescr,cfd.udf1 as SerialNumber,vd.name as Vendor from OpManagerObject oo left join TopoObject topo on oo.name=topo.name left join SnmpNode sn on sn.name=topo.name left join CustomFieldsForDevices cfd on cfd.devicename=topo.name left join ManagedObject mo on mo.name=oo.name left join MANAGEDOBJECTTOVENDOR mobjvd on mo.moid=mobjvd.moid left join VENDORDETAILS vd on vd.vendorid=mobjvd.vendorid;"

if i want this query to be executed only on devices which are routers how can i do it and same for switches .

thanks in adv,

best regards,

arpit