topic Re: FDE - Deleting unused computers/licenses in Endpoint

FDE - Deleting unused computers/licenses

biskit — Wed, 16 Feb 2022 18:19:26 GMT

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?

Re: FDE - Deleting unused computers/licenses

jcortez — Thu, 17 Feb 2022 13:58:57 GMT

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.

Re: FDE - Deleting unused computers/licenses

biskit — Thu, 17 Feb 2022 14:32:37 GMT

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

Re: FDE - Deleting unused computers/licenses

G_W_Albrecht — Thu, 17 Feb 2022 21:11:45 GMT

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

Re: FDE - Deleting unused computers/licenses

jcortez — Fri, 18 Feb 2022 08:58:04 GMT

@G_W_Albrecht

Nice find. I forgot about that SK.

Re: FDE - Deleting unused computers/licenses

G_W_Albrecht — Fri, 18 Feb 2022 10:40:10 GMT

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

Re: FDE - Deleting unused computers/licenses

jcortez — Sun, 20 Feb 2022 07:15:32 GMT

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.

Re: FDE - Deleting unused computers/licenses

G_W_Albrecht — Sun, 20 Feb 2022 08:13:45 GMT

You do not need to explain that to me 8).

Re: FDE - Deleting unused computers/licenses

jcortez — Mon, 07 Mar 2022 15:51:57 GMT

@biskit

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

Re: FDE - Deleting unused computers/licenses

biskit — Fri, 11 Mar 2022 10:25:28 GMT

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