[Tutorial] Alle HA Entitäten per CSV auslesen und mit Analyzer Tool oder Excel auswerten

Danke @jayjojayson ! :slight_smile:

auch ich habe mein Dump Skript erweitert. es speichert nun auch Hersteller, Modell, HW/SW Version der Entitiät.

hier das erweiterte Skript

sequence:
  - variables:
      entity_ids_sorted: "{{ states | map(attribute='entity_id') | list | sort }}"
  - data:
      entity_id: notify.entity_dump
      message: >-
        "entity_id";"friendly_name";"device";"domain";"area";"floor";"active";"state";"state_tr";"manufacturer";"model";"model_id";"sw_version";"hw_version";"last_upd"
    action: notify.send_message
  - repeat:
      count: "{{ entity_ids_sorted | count }}"
      sequence:
        - variables:
            id: "{{ entity_ids_sorted[repeat.index-1] }}"
            obj: "{{ states(id) }}"
        - choose:
            - conditions:
                - condition: template
                  value_template: "{{ obj is not none }}"
              sequence:
                - variables:
                    name: "{{ obj.name | default('') }}"
                    dev: "{{ device_id(id) | default('') }}"
                    dev_name: "{{ device_name(id) or dev }}"
                    manufacturer: "{{ device_attr(id, 'manufacturer') | default('') }}"
                    model: "{{ device_attr(id, 'model') | default('')  }}"
                    model_id: "{{ device_attr(id, 'model_id') | default('') }}"
                    sw_version: "{{ device_attr(id, 'sw_version') | default('')  }}"
                    hw_version: "{{ device_attr(id, 'hw_version') | default('')  }}"
                    dom: "{{ id.split('.',1)[0] }}"
                    area: "{{ area_name(id) | default('') }}"
                    area_identifier: "{{ area_id(id) | default('') }}"
                    flo_id: "{{ floor_id(area_identifier) | default('') }}"
                    flo_name: "{{ floor_name(flo_id) | default('') }}"
                    aktiv: >-
                      {{ states(id) not in ['unavailable','unknown','none','']
                      }}
                    state: "{{ states(id) | default('') }}"
                    state_tr: "{{ state_translated(id) | default('') }}"
                    last_upd: |
                      {% set lu = states[id].last_updated %} {% if lu %}
                        {{ as_local(lu).strftime('%Y-%m-%d %H:%M:%S') }}
                      {% else %}
                        {{ "" }}
                      {% endif %}
                - data:
                    entity_id: notify.entity_dump
                    message: >-
                      "{{ id }}";"{{ name }}";"{{ dev_name }}";"{{ dom
                      }}";"{{area }}";"{{ flo_name }}";"{{ aktiv }}";"{{ state
                      }}";"{{state_tr }}";"{{ manufacturer }}";"{{ model }}";"{{
                      model_id }}";"{{ sw_version }}";"{{ hw_version }}";"{{
                      last_upd }}"
                  action: notify.send_message
  - action: shell_command.manage_entity_dump
    data:
      action: trim
  - action: shell_command.manage_entity_dump
    data:
      action: rename
  - action: shell_command.manage_entity_dump
    data:
      action: purge
alias: Entity Dump to File
description: ""