echo "- LICS IN USE -"
echo "---------------"
echo "--- container1 ---"
psql -d uepm -p 18272 -U endpoint -c "select count(*) from device_license where device_license.blade_name = 'container1';"
echo "--- epfw1 ---"
psql -d uepm -p 18272 -U endpoint -c "select count(*) from device_license where device_license.blade_name = 'epfw1';"
echo "--- fde1 ---"
psql -d uepm -p 18272 -U endpoint -c "select count(*) from device_license where device_license.blade_name = 'fde1';"
echo "--- antimalware1 ---"
psql -d uepm -p 18272 -U endpoint -c "select count(*) from device_license where device_license.blade_name = 'antimalware1';"
echo "---------------------------------------------------------------------------------------------------------------------------------------"
echo "- (sk92328) Machines, that take up license seats but do not communicate with EPS in more than the configured purging interval (default 30 days) -"
echo "---------------------------------------------------------------------------------------------------------------------------------------"
psql -d uepm -p 18272 -U endpoint -c "select distinct (device.nid), device.distinguished_name from device, device_license where device.nid = device_license.nid AND device.nid NOT IN (select nid from emon_status_data) AND device.is_in_domain=true;"-bash-3.2$