# Connected Systems Data Snapshot Summary

- Date: 2026-06-18
- Goal: pull together the current data situation for systems already connected to `zhctprompt` and deliver it as one Excel workbook.
- User-facing workbook: `outputs/2026-06-18-connected-systems-data-snapshot/zhctprompt-connected-systems-data-snapshot-20260618.xlsx`
- Builder: `work/2026-06-18-connected-systems-data-snapshot/scripts/build_connected_systems_snapshot.mjs`

## Scope

Included systems and data surfaces:

- `zhctprompt` task index and work evidence files.
- Codex thread archive from `notebooklm-mcp`.
- PM Skills marketplace and PM-skill 5 data analytics route.
- Enterprise WeDrive derived indexes and online document index.
- NotebookLM local library health.
- WeKnora local RAG health.
- Youdao CLI and Aliyun CLI availability.
- Codeup / `zhctproject` repo manifest and current Git status snapshot.
- Apifox sync readiness.

Sensitive data rule:

- The workbook does not expose tokens, cookies, credentials, raw private chats, or production payloads.
- For auth-based systems, it reports only connection/config status and next action.

## Key Counts

| Surface | Count |
| --- | ---: |
| Systems listed | 13 |
| Task index rows | 243 |
| Codex archived threads | 1237 |
| PM imported skills | 69 |
| WeDrive file inventory rows | 59135 |
| WeDrive document index rows | 7083 |
| WeDrive project index rows | 455 |
| Registered `zhctproject` repos | 10 |
| Current-status repo rows | 46 |

## Main Findings

- Local control data is healthy: task index, PM Skills, thread archive, WeDrive indexes, and repo manifest all have readable local data.
- NotebookLM is present but currently `authenticated=false`, so notebook content queries require `setup_auth` / `re_auth`.
- WeKnora local RAG health endpoint returned `{"status":"ok"}`, but historical full sync still has failed packages, so no no-miss coverage is claimed.
- Apifox sync is not ready for direct API write because no local Apifox env file was found in this pass.
- Yunxiao CLI is installed, but this pass did not find `config/local/yunxiao.env`; real work-item pulls still need the user's personal token.

## Validation

- Workbook generated with bundled Node runtime and `@oai/artifact-tool`.
- `Dashboard!A1:H20` inspected successfully.
- Formula error scan matched 0 entries.
- All seven workbook sheets rendered to PNG successfully:
  - `Dashboard`
  - `System Status`
  - `Data Inventory`
  - `Task Index`
  - `PM Skills`
  - `Thread Archive`
  - `Access & Blockers`

## Boundary

This is a local/control-plane snapshot. It does not claim fresh live data from cloud systems unless a health check or connector response was actually available in this run.