Windchill BLOB Data - Stream Data Table analysis

[AK_10995767]

Version: Windchill 12.1

Use Case: Analysis of Stream data

Description:

Analysing the stream data - count of object types per organization

[Catalina]

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,

[avillanueva]

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

[Shreyas_Atre · Accepted solution]

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

[AK_10995767]

@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]

Hc.IDA3A5 joins to IDA2A2 of either WTDocument or EPMDocument