How to remove entities without a unique_id? Where are they?

[WoJWoJ]

I have several entities withouta unique_id that I created when making some tests but that I cannot delete from the UI, there is no delete button.

When adding a unique_id during creation (via MQTT discovery), I have a better control of it though the UI, but still not possible to delete it - the delete button is grayed out

There are already numerous questions such as this one, but no answer (except mentioning known_devices.yaml that I do not have):

How do I delete old entities in June 2020?

check for those entities in the known_devices.yaml just in case they got stuck in there.

How to delete an item without a unique ID

I’m with you on this. I’ve got a similar situation and can’t find any way to clear out the “phantom” device. I’ve check all the YAML files. I’ve checked the “core.entity_registry” file too but cant find it listed anywhere.

How to delete old device tracker entities shown in UI as "this entity does not have a unique ID therefore it's settings cannot be managed from the UI"

Quick question, should the ones I want to keep still be in known_devices.yaml or is that no longer used with the 2.0 app that’s configured via UI?

Removing entities without unique ID?

When I added the Philipps Hue integration, HA duplicated a couple of entities with its internal Light integration. These are not needed and I would like to remove them as they just cause confusion. In the entity list they are read-only, (so not selectable, etc.) do not have a unique ID, are not in the .storage/core.entity_registry file (or .storage/lovelace) … Where are they defined? How do I remove them?

Entity without ID. How to delete?

I have inside the entities an entity i cannot delete as i am answered it has no ID. How to delete it? More, i cannot find this entity into the ‘core.entity_registry’ file inside ‘.storage’ folder. It has ‘device_tracker.tx9_pro’ as name.

(etc.)

In one of them, @tom_l mentioned

You can’t. You can only disable them

My question: is there indeed NO WAY to delete entities in Home Assistant? They must be stored somewhere!

I managed to find the second entity in core.entity_registry

[tom_l]

@WoJWoJ

When adding a unique_id during creation (via MQTT discovery), I have a better control of it though the UI, but still not possible to delete it - the delete button is grayed out

If it is an MQTT sensor all you have to do is send a blank retained message to the discovery topic.

Or use MQTT Explorer to delete the retained discovery topic.

[WoJWoJ]

Yes, for the MQTT entity this is possible (and I found it in one of the stores). It is still mysterious for the ones without unique ID.

[waank1]

Has anyone figured out how to assign a unique ID so they can be managed in the UI?

[tpantano]

@WoJWoJ - Were you ever able to find an answer to this?

[WoJWoJ]

Unfortunately not.

[Saxum]

The only solution I found for this was to modify the home-assistant_v2.db with SQLite DB Browser, which you can download and install for free. I am running home assistant in a docker instance on a Ubuntu server. The database file is found in the home assistant config folder.

*** Messing with the database is probably the best way to completely screw up your entire install if something goes wrong - so make a backup first. ***

Stop home assistant and make a backup of the database first. Then while home assistant is stopped, you can access the database with the SQLite DB Browser. For me, my orphan entities were caused by creating MQTT sensors in my configuration.yaml. I found these entities referenced in the “states” table of the database. I simply deleted every record I found which referenced the orphaned entities. Once I restarted home assistant, I checked the entities and found the orphan entities were all gone.

I had previously tried restarting home assistant to see if they would disappear, that did not work. I used grep to find any instances of the orphaned entities in the .storage folder. I removed every instance I found in that folder to only see them created by home assistant again. The only file left with references to the entities I wanted to remove was the database file. I found these things so annoying I was willing to risk a complete re-install and re-build if something went wrong in the database modifications. But hey, if it did go that wrong, a clean install would also fix the issue.

[Edwin_D]

If what is in home-assistant_v2.db is causing the entities to show up, most likely you simply need to wait until the recorder history is purged from the database to get rid of it. 10 days is the default setting for that. Then the last values from the old sensor are deleted automatically.

[Bogey]

If not want to wait, from developer-tools/service and “Recorder: Purge Entities” I was able clear my orphan entity.

[erktrek]

This worked for me… thanks again.

[MickPB (Jeff Mickens)]

I have also have an entity, created from HACS, that I cannot remove. Interestingly the entity is not displayed when I goto settings > devices > entities but is offered as an entity when adding to lovelace. The entity has not been used for many months. I ran recorder purge for it. Still there.
How can I remove it and isn’t this an inconsistency in the database? Is there possibly a service to check this and clean it?

[koldso (Niels Koldsø)]

Thanks Bogey.

This did not work for me however. Any suggestions?

FYI: I run HA on top a deconz system. Deleting the troublesome entities from deconz, reloading (from deconz), deconz:deleting orphans and recorder:purging still leaves the ghost entities

[Sophokles]

I have a lot of (maybe 30000?) sensor ble entities without unique id and with not (anymore) existing mac adresses. Recorder Purge entities does not delete them. I would be glad if anyone had an idea …
Many Thanks, Michael

[Sophokles]

Just tried to watch the Database (home-assistant_v2.db) with SQlite DB Browser. Can’t find the unused entries in “state” folder, but they are all listed under “event_data”. Can I delete them from there and might it help?

[ottelo]

Damn I have exactly the same problems! Any solution for it. With Recorder: Purge Entities it doesnt work.

PS:
Clear the browser cache works!

QUESTION: How to delete an invalid entity with no unique ID (UNSOLVED)

I had the same problem, what probably fixed it is that I opened home-assistant_v2.db with the SQLite extension in VSCode and did a cleanup in the states table. After restarting HA several times, and logging out and in again, the entities were finally gone. Hope it helps someone.

[edmcska]

Hi ,

Yes it helped , log out/log in removed the ones.

Thanks

[Joaquim_Monteiro (j-monteiro)]

After purging the entity, log out/log in will make it go away.

Thanks guys.

[AkaMrBill (Bill Kendall)]

The question still remains; “How do you purge an entry that does not appear in the list of entities or when typed out?”

[James62370]

For me I went to “Developer Tools”, “Statistics” tab, then clicked “Fix Issue” on all the entities without unique ID’s.

[peterbarkun]

Thanks a lot,
I just had to clear the cache