mysql -h 10.80.3.8 -D nms2 -u nmsuper -predpoint -N -e "select smgr_host, dev_alias, model_name, ifindex, ifdescr, pollinst_desc, concat(d.sys_name,'_',i.ifindex) from service_managers s, devices d, device_models m, interfaces i, pollinst p where s.smgr_id=d.dev_owner AND p.device_id=d.device_id AND d.model_id=m.model_id AND p.pollinst_id=i.interface_id AND p.pollinst_enabled=1 and d.class_id in (1,7)" > NVInterfaces.txt
No comments:
Post a Comment