How can i get total number of presents and models in pyramid for version 2025.01.004 using pyramid sql repository.

Hi everyone,

We are running Pyramid in a single‑tenant deployment on our own VMs, and I am trying to generate daily stats for:

• total active Models
• total active Presents

This is to help us track adoption trends and “work in progress” over time.

From what I understand, the content_tbl_item table stores all content objects, and item_type identifies the object type. Based on documentation and older forum references, I have the following mappings:

• item_type = 4 → Models
• item_type = 8 → Presents

To calculate the active counts, I am using these queries:

Models

SQL

SELECT COUNT(*) AS etl FROM dbo.content_tbl_item WITH (NOLOCK)

WHERE item_type = 4 AND (is_deleted = 0 OR is_deleted IS NULL)

AND is_active = 1;

 

Presents

SQL

SELECT COUNT(*) AS present FROM dbo.content_tbl_item WITH (NOLOCK)

WHERE item_type = 8 AND (is_deleted = 0 OR is_deleted IS NULL)

AND is_active = 1;

 

---

My questions

1. Are these item_type values correct (4 = model, 8 = present) in a single‑tenant Pyramid install?
2. Is this the correct and supported way to count active content items in Pyramid?
3. Are there any other flags or joins I should include to ensure accuracy (e.g., multi-version rows, ownership, tenant filters, etc.)?