In configuration.yaml :
notify:
- name: notifier_hangouts
platform: hangouts
default_conversations:
- id: UgzeEijx9wzdysrrfx14AaABAagBgbmCCw
- platform: file
name: entity_log
filename: /config/www/entity_log.txt
timestamp: false
Cool. I’ll try that. Before I do… if it goes FUBAR, is there a way to restart HASS without just pulling the plug on the Pi if I don’t have access to the UI? SSH seems to be disabled.
If you are running Home Assistant OS or Home Assistant Supervised, just install the Web Terminal and SSH add-on. Just don’t forget to enable port 22 :
Perfect! That’s done the trick, thank you!
I would also like a list of entities. Where do I place that information?
edit: I figure it out - it goes under notify: in the configuration.yaml as per File - Home Assistant
So I had it set as
notify:
- platform: file
name: entity_log
filename: /config/www/entity_log.txt
timestamp: false
This has stopped working for me, anyone else?
I’m getting this when tying to call the service…
Failed to call service notify/entity_log. required key not provided @ data['message']
This script will work without the error.
print_entities_to_file:
alias: Print Entities To File
sequence:
- service: notify.entity_log
data:
message: "{% for state in states %}\n - {{- state.entity_id -}}\n{% endfor\
\ %}\n"
mode: single
That worked, thanks!
Hi,
I’m trying to export the info that you can find when clicking under “entities” in configuration.
In other words, a table file with
Name, Entity_id, Integration, Area, Status
Sadly that web page is not exportable, or selectable, not even printable.
Is that possible?
I cannot find how to call the “integration” info such as “Deconz”, “Tuya”, etc.
{% for state in states %}
{{ state.domain, state.entity_id, state.object_id, state.name, }}
{%- endfor -%}
Edit: after discussing on Discord, it seems this is simply not possible using tempaltes as the data is not available there.
I solved my issue with the next trail below
I’m almost scared to explain how I did this in 30 seconds (since I didn’t use code but brute forced it somehow)… but
Voilà. A beautiful table with everything posiible 
Edit: This is the list of data field available in this file:
entity_id
config_entry_id
device_id
area_id
unique_id
platform
name
icon
disabled_by
supported_features
device_class
unit_of_measurement
original_name
original_icon
capabilities/hvac_modes/0
capabilities/hvac_modes/1
capabilities/max_temp
capabilities/min_temp
capabilities/preset_modes/0
capabilities/preset_modes/1
capabilities/preset_modes/2
capabilities/preset_modes/3
capabilities/preset_modes/4
capabilities/source_list/0
capabilities/source_list/1
capabilities/min_mireds
capabilities/max_mireds
capabilities/effect_list/0
capabilities
This is fantastic, just what I was looking for. Thanks so much!
This worked so good, I want to do the same for devices rather than entities. I tried changing this around like so:
In the config:
notify:
- platform: file
name: device_log
filename: /config/www/device_log.txt
timestamp: false
script:
print_devices_to_file:
alias: '2.) Print Devices To File'
sequence:
- service: notify.device_log
data_template:
message: >
{% for state in states %}
- {{- state.device_id -}}
{% endfor %}
put all I received was a list of dashes. I am assuming this section:
{% for state in states %}
- {{- state.device_id -}}
{% endfor %}
is incorrect but not sure what to use instead? Can anyone assist?
There is a much simpler solution.
Simply navigate to Dev tools>> Template and paste below
{% for state in states %}
- {{- state.entity_id -}}
^ {{- state.name -}}
{% endfor %}
The resukt will be shown at right side. You can copy paste into excel and use text to columns to split using ^ symbol for ID and Name and find replace to remove leading - on the entity. Boom - you will have a neat excel in less than a minute
Another option…
With ssh set up its straightforward to access the entities from a terminal on your PC, at home I’m using Linux (Fedora) - any Linux would do. For example:
kiat@fedora:~ ?} ssh ha "cat /config/.storage/core.entity_registry | awk '\$1 ~ /entity_id/ {print \$2}' | sed 's/\(\"\|,\)//g' | sort | egrep ^switch" | tail
switch.wled_island_sync_send
switch.wled_porch_nightlight
switch.wled_porch_reverse
switch.wled_porch_sync_receive
switch.wled_porch_sync_send
switch.wled_utility_nightlight
switch.wled_utility_reverse
switch.wled_utility_sync_receive
switch.wled_utility_sync_send
switch.zbbridge
and
{kiat@fedora:~ ?} ssh ha "cat /config/.storage/core.entity_registry | awk '\$1 ~ /entity_id/ {print \$2}' | sed 's/\(\"\|,\)//g' | sort | egrep ^binary_sensor" | tail
binary_sensor.watersensor_wc_water_leak
binary_sensor.wled_bench_firmware
binary_sensor.wled_hall_firmware
binary_sensor.wled_island_firmware
binary_sensor.wled_porch_firmware
binary_sensor.wled_utility_firmware
binary_sensor.yard_all_occupancy
binary_sensor.yard_person_occupancy
binary_sensor.zigbee2mqtt_running
binary_sensor.zigbee2mqtt_update_available
where I’m using “tail” to truncate, but any prefered output of data is available by tweaking the “awk” and “sed” commands.
Thanks!! One would think an export option would be available but this solved my problem
hello @francisp
Thanks a lot for your script. It is working well. Quick question, is there a way to erase the Txt file before writing on it? Atm the script is appending data and for my purposes an erase/write process would be better.
Thanks again
You are a hero! Thanks!
The most cool way to get this overview. I just used File Editor to get the JSON. Before you can access it in the .config path you must configure File Editor to not hide files and folders with pattern .storage:
I did it even easier 
Added HA as networkdrive with Samba Share and pull the JSON directly into Excel, now i have a tableview in excel and its always uptodate.
Thanks for your tip where to find it
Edit:
To import this JSON data into Excel, follow these steps: