Skip to main content
A
AK_109957676-Contributor
6-Contributor
April 9, 2025
Solved

Windchill BLOB Data - Stream Data Table analysis

  • April 9, 2025
  • 3 replies
  • 859 views

Version: Windchill 12.1

 

Use Case: Analysis of Stream data


Description:

Analysing the stream data - count of object types per organization

Best answer by Shreyas_Atre

If you are looking to count how many objects from each organization are stored in blobs (in stream data), you need to build a query using the application data table.

Below is a sample query that will give you the object types stored in the blob table. Please join the holdertoContent  table to WTDocument, EPMDocument, and other objects as necessary:

SELECT hc.CLASSNAMEKEYROLEAOBJECTREF, COUNT(1)
FROM ApplicationData a, holdertoContent hc
WHERE hc.IDA3b5 = a.ida2a2
AND a.classnamekeya5 = 'wt.content.StreamData'
GROUP BY hc.CLASSNAMEKEYROLEAOBJECTREF;

Hope this helps 
Thanks

3 replies

Catalina
CatalinaCommunity Manager
Community Moderator
April 9, 2025

Hi @AK_10995767 

 

Thank you for your question! 

 

Iā€™d like to recommend to bring more details and context to your initial inquiry. For example:

  • Which specific object types are you interested in counting?
  • Are there particular organizations you want to analyze, or should the analysis include all organizations?
  • Is the stream data currently in BLOB format, or has it been converted to a different format?

Please add screenshot(s) to better understand what you are trying to do in your process. 

 

Please refer to this guideline to make your questions more likely to receive a quick and useful answer. 

This will increase your chances to receive meaningful help from other Community members. 

 

What is a good question? 

Windchill 

 

Thank you for your participation and please let me know if you need further assistance! 

 

Best regards,

Catalina | PTC Community Moderator
avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
April 9, 2025

Normally, settings are set to force content to vaults. Its not recommended to store files in BLOBs. Do you think that is your case, the file data is ending up in BLOBS. You should be able to change your vaulting rules and move that content out. Can you elaborate on your question?

Some links:

https://www.ptc.com/en/support/article/CS37197

https://www.ptc.com/en/support/article/CS371703?source=search

 

    S
    Shreyas_Atre12-AmethystAnswer
    12-Amethyst
    April 9, 2025

    If you are looking to count how many objects from each organization are stored in blobs (in stream data), you need to build a query using the application data table.

    Below is a sample query that will give you the object types stored in the blob table. Please join the holdertoContent  table to WTDocument, EPMDocument, and other objects as necessary:

    SELECT hc.CLASSNAMEKEYROLEAOBJECTREF, COUNT(1)
FROM ApplicationData a, holdertoContent hc
WHERE hc.IDA3b5 = a.ida2a2
AND a.classnamekeya5 = 'wt.content.StreamData'
GROUP BY hc.CLASSNAMEKEYROLEAOBJECTREF;

    Hope this helps 
    Thanks

      A
      AK_109957676-ContributorAuthor
      6-Contributor
      April 9, 2025

      @Shreyas_Atre Thanks for the solution.
      Can you please let me know based on which identifier I can join holdertoContent  table to WTDocument, EPMDocument, and other table?

      avillanueva
      23-Emerald I
      avillanueva23-Emerald I
      23-Emerald I
      April 9, 2025

      Hc.IDA3A5 joins to IDA2A2 of either WTDocument or EPMDocument

        Terms & ConditionsCookie settingsAccessibility statement