header
docker exec -it $(docker ps | awk '/s_postgres/ {print $1}') bash -c 'psql -d campus -U apic_em_user -h localhost -P pager service''off
select * from deviceinfo where networkdeviceid in(select instanceuuid from networkdevice where managementipaddress like '10.0.255.2');
select * from deviceinterfaceinfo where deviceinfo_id=1674676;
select * from dvcintrfcinfshssgmnts where deviceinterfaceinfo_id=2349347;
delete from dvcintrfcinfshssgmnts where deviceinterfaceinfo_id=2349347;
delete from deviceinterfaceinfo where deviceinfo_id=1674676;
delete from customerfacingservice where id=1674676;
select * from deletedeviceblacklist where deviceuuid='51c5a0d8-6de0-4d7d-9aa2-f06625e4ba81';
delete from deletedeviceblacklist where deviceuuid='51c5a0d8-6de0-4d7d-9aa2-f06625e4ba81';