FDE - Deleting unused computers/licenses

[biskit]

Hello,

I'm looking for suggestions on how best to determine which laptops are no longer used so they can be deleted from FDE to put the licenses back in the pool for someone else?

My customer has 1000's of computers on their system, they're out of licenses, and they know for sure there will be a load of computers still taking up a license which were crapped a long time ago.  What are your best practice suggestions to discover which old computers can be deleted to free up the licenses?

Is the best/only way to run a report on Endpoint Connectivity and just remove ones that haven't connected in say 6 months?

[jcortez]

Yes usually by going through which old machines, like you said, that are no longer connecting to the Harmony Endpoint Management Server and have been offline for a long time now.

The other option and what we could look at is running a database query (psql query) to understand how many licenses each machine is using.

There could be a situation where there are machines using multiple DA/Container licenses and multiple Software Blade license if machine have been reimaged or our client has been uninstalled and reinstalled multiple on these machine but a 'reset computer data' has not been done for there machines in the Smart Endpoint Console or Harmony Endpoint Web Management Portal as part of the reimaging process or client uninstall process. Each client should only be using 1 DA/Container license and 1 Software Blade license per blade being used.

Please run this psql query and provide the output file, /home/admin/Licenses_being_used_per_machine.txt, in a direct message to me, so the information is not public, and I will review it and let you know if this could be part of the issue and what the next steps would be.

psql -p 18272 uepm endpoint -c "select distinct device.common_name, device_license.blade_name from device_license inner join device on device.nid=device_license.nid join license on license.licuid=device_license.licuid order by common_name;" >> /home/admin/Licenses_being_used_per_machine.txt

If this is not a Harmony Endpoint On-Premise Server/Setup but a Harmony Endpoint Cloud/EPMaaS Server/Setup please let me know. If it is a Harmony Endpoint Cloud/EPMaaS Server/Setup then I can connect to the server and get the data myself.

[biskit]

Great, thank you!  I'll get the customer to run that and I'll sent the results over 👍

[G_W_Albrecht]

sk153872: How to see old machines that are still using license seats in the Endpoint Security Server

[jcortez]

@G_W_Albrecht 

Nice find. I forgot about that SK.

[G_W_Albrecht]

See also sk122119: License counter showing incorrect number of seats

I do have the psql -d uepm release procedure, too...

[jcortez]

I have the license release psql cmd as well but I want to confirm what the issue is first and not just throw spaghetti at the wall.

[G_W_Albrecht]

You do not need to explain that to me 😎.

[jcortez]

@biskit 

Just wanted to follow up on this. Are you still needing assistance with this?

[biskit]

Hi guys,

Thanks so much for your help, and sorry for my delay in responding...  Never enough hours in the day 🙂

The customer didn't get back to me.  I happen to know he has much bigger fish to fry at the moment though...

Cheers,

Matt