Packaged scripting (SQL, QueryBuilder, Info*Engine) for capturing Windchill Content Download Count and Content Download Size for EPMDocument and WTDocument

[habat]

We are wondering if anyone can share a packaged scripting (SQL, QueryBuilder, Info*Engine, PSM Extension...?), for capturing Content Download Count and Content Download Size for EPMDocument 3D, EPMDocument 2D and WTDocument Items which were created over a particular period of time (daily, weekly or a specific range of hours, ...)

This is for monitoring purpose and this can be finally embedded within either (or both) PSM and WBR (Windchill Business Reporting a.k.a Cognos)

[satre-2]

Download any content from windchill is one event (Read Content) which you need to enable.See below article for details

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS135740&art_lang=en&posno=1&q=configAudit.xml&source=search

If event is enabled then each time when you download the Document (it includes opening document in CAD Application or publishing  document in CAD worker ) event is recorded in auditevent and auditrecord table. 

Enabling this event recording may put some additional load your database

Thanks

Shreyas

[habat]

Shreyas - Seems interesting. Is there a way to consider Event splitting (segregated reporting) for considering three distinct categories with:

#1. EPM Document 2D content

#2. EPMDocument 3D Content

#3. WTDocument content?

[BineshKumar1]

Herve,

There is a column in security audit report for download, Object Identity - this will have the type of object downloaded  say CAD document, WTDocument, Markup. The good thing is it will even let you know the softtypes as well.

If you download or open a top level assembly, it would log only one event for the asm which you chosen, not all the child parts

These are the column headers if it helps

Event Label

Event Key

Event Time

User Name

User ID

IP address

User Organization

Object Type

Object ID

Object Type Branch ID

Object Name

Object Number

Branch ID

Working Branch ID

Version

Master ID

Organization ID

Organization Name

Context ID

Context Name

Context Type Branch ID

Folder Path

Domain Path

Identity

Lifecycle State

Transaction Description

Object Identity

Security Labels

Event Specific Data

Thank you

Binesh Kumar

[BineshKumar1]

As for the PSM. you have two business transactions OOTB

1. Content download by User Name
2. Content Download by Database ID

Owing to different download mechanisms, PSM cannot capture the username for all the transactions. In that event it captures the database id. A combination of results from the both the reports would give an accurate picture on download. To interpret the username from id a, qml has been provided which queries the wtuser table. - http://www.ptc.com/WCMS/files/142899/en/User-Name-Report.zip

Thank you,

Binesh Kumar