cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Resource for reporting

Re: Resource for reporting

Added link in the TIPS and TRICKS section:

How to create a query builder report that accepts multiple inputs (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS190138

How to hide the "Saved Reports" for particular user (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS190136

Query Builder Report displays duplicate entries (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS146646


Query builder report to fetch all the values of the multivalued attribute in single row (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210938

Marco

Re: Resource for reporting

Added link as shown below.

TIPS and TRICKS

Multi-valued attributes display multiple times within a Query Builder report
https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS53268

Possibility to make reports in the query builder default to search in the current container

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS96881

Search on Windchill Report Builder are case sensitive though the Select criteria is "like"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS168769

Where is the documentation for how to add Business Reporting to an existing Windchill installation?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS115821


ADMINISTRATIVE REPORT (User/Roles/Group/ACL's)

Global Attribute Enumeration

https://www.ptcusercommunity.com/thread/119387?sr=stream&ru=281467

How to export all ACL's related to a specific user

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS123564

Query builder report to fetch product, role and user from role

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS189509

Query builder report to fetch "last logged in" of users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS220318

Query Builder Report to list all objects shared between projects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS209852

Query Builder report to show folders with associated domains

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS44018


CHANGE MANAGEMENT

How to get "Promoted on" attribute into a Change Notice report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS115668

Query Builder report for counting the Affected Objects in a Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS213950



EPMDoc REPORT

Query Builder report to fetch checked out objects in user's workspace

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS134496

Query builder report to fetch the EPMDocuments having annotation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210700

PROMOTION and WORKFLOW

In which database tables are stored the workflow execution objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS214035

QML report returning runtime routing list for Setup Participants from a workflow

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210243

Report to find out values of Promotion Preferences

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS215586


WTDOCUMENTS

Query builder report to list Documents from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS208539

Report to find WTDocuments went for Approval Routing in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS207521

Report to search for Documents by Effectivity

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS209206

What are the tables and joins required for generating a query builder report for Documents without any Primary Content and Attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS209629


WTPARTS

How to create a Where Used report for WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210416

QML Report to to show association between Deviation and it's associated WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS205475

Query builder report to list WTParts from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS208537

Query Builder Report to list all the OEM part which do not have AML\AVL Part associated

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS210102

Query builder report to fetch parts at level 0 in structure tab

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS215346

Which Database tables store classification attributes in Windchill PartsLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS172788

TROUBLESHOOTING

Change Requests not automatically associated with corresponding Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS211530


Failed to delete some report templates from Site>Utilities>Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS185149


Generating a report from Context > Reports > Change Request Logs caused MethodServer to crash with OutOfMemoryError

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS203309


Reports imported or created at Organization level are not available for non-admin users on Homepage

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS52000

Report Builder is inadvertently removing a condition from the subquery while attempting to modify the qml with user entered data

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS186246


Using Date Picker in a OOTB Report in a browser that is not in English results a "Timestamp format" Error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS215342

Marco

Re: Resource for reporting

Added link as shown below

TIPS and TRICKS

How to create bar chart report with number of records created in each month

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS223720

Use of Options in the Select Tab of Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS35281

Information regarding how to use the Query Builder functions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS83196

How can a report be run on a schedule and emailed to a user in Windchill PDMLink?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS140996

Query builder report to display "Comments" column of Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS157262

How to allow users to see all part numbers even though they do not have access to all parts?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS223072

How to add Info (Details Page) button and email links in query builder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS227239

Query Builder Criteria Logic for getting last month

https://www.ptcusercommunity.com/thread/130187?sr=stream&ru=357802


ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)


How to generate a Query builder report to display Maturity History of the object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS28221

How to get "Download" event information in Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS135740

Query Builder report to fetch latest version of WTDocument,EPMDocument and WTPart in Library Context for particular state

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS142076

QML Report to list all the Users in Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS198022

How to list Classification Nodes and their related attributes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS220979

QML report to retrieve the Distinguished Name of all Users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS221494

Query builder report for listing prohibit publishing objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226376

Is there a way to Search Check in comments for CAD or Documents

https://www.ptcusercommunity.com/thread/130236?sr=stream&ru=364762


CHANGE MANAGEMENT

How to create a visual monitor report that shows open, in progress and complete Change Requests

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS224065

Query builder report to fetch problem report with associated part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226330

Change object Date Completed

https://www.ptcusercommunity.com/thread/129761?sr=stream&ru=5134


EPMDoc REPORT

How to get a list of all family table instances with a status of "Unverified" or "Unknown"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS40247

Query Builder Report to fetch the universally uploaded object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS227691

How to build a report for latest version of EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS33305




WTDOCUMENTS

QML report to count the number of documents by different document types

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS216381


WTPARTS

QML report to query latest version of all WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS138336

How to get a query builder report for Classification details for Parts and/or Part Structure

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS145972

Query builder report to list WTParts of particular view

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS208737

https://www.ptcusercommunity.com/message/425216#425216

How to create a Query Builder report to list all Parts that do not have Parent Part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS223922


TROUBLESHOOTING

When a variable is used in Select and Criteria section of Query Builder with Input Parameter, report page generated doesn't display alias name of variable in Input Parameters section

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS133386

Not able to Save reports having Chart using Organization Admin user giving secured action error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS179575

Failed to export the results generated for Reports using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS204259

Information or Details page for Report Templates shows Creator attribute value as ???createdby??? where creator is not available

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS221397

Data monitor criteria filter for created on time of "Yesterday" not covering entire day

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226634

In Report Builder, like operator does not returns exact searched string

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS224643

Report result will not be merged even select the "HTML (with merging)" in "Generate Legacy Mode Output"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS222197

Soft types created at the organization level not available in Query Builder launched from "Site" > "Utilities"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS227163

Marco

Re: Resource for reporting

Hi,

I'm looking to build a report that gives me the number of days spent at each state for each Change Notice. Can anyone recommend how to do this using functions within the Query Builder?

Thanks

Conor

Re: Resource for reporting

Conor,

I suggest you a couple of things.

First: you should create a dedicated discussion with your request, because you made it in an article.

Second: if you can't get an answer in few days, and have an active maintenance, you should also submit your request to PTC support.

Many of the reports linked in my document are taken from article written by TS.

Marco

Re: Resource for reporting

Thanks Marco, will do that now

Re: Resource for reporting

Hi ,

  I just posted a large amount of reports to the group. I do believe there are a few in regards to process and activity completion time. Please take a look at these reports and see if one can be modified to meet your need.


‌, Please feel free to add these to the document as needed.

Best Regards,

Dax

Re: Resource for reporting

Hi Dax,

thanks for sharing your reports.

I'll take a look into them and then I'll link your reports in my document.

Marco

Re: Resource for reporting

Hi Dax, thanks for these. These will come in useful!

Re: Resource for reporting

Added link to reports taken from Dax Williams documents.

ADMINISTRATIVE REPORT

Action Item with Workflow Process

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111660/ACTION%20ITEM_Action%20I...

Attribute Ids by Name

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111682/ADMINISTRATIVE_Attribute...

Attribute Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111683/ADMINISTRATIVE_Attribute...

Document Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111686/ADMINISTRATIVE_Document%...

User Login Audit

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111789/ADMINISTRATIVE_User%20Lo...

User Login Totals

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111788/ADMINISTRATIVE_User%20Lo...

User Specified Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111696/ADMINISTRATIVE_User%20Sp...

Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111680/ADMINISTRATIVE_9.1%20Pre...

Quantity of Measure

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111692/ADMINISTRATIVE_Quantity%...

Report Manager Report List

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111693/ADMINISTRATIVE_Report%20...

Team Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111694/ADMINISTRATIVE_Team%20Te...

Part Version Scheme

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8682-1-111704/AUDIT_Part%20Version%20S...

Lifecycle Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111688/ADMINISTRATIVE_Lifecycle...

Library_Product_Project Templates

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111687/ADMINISTRATIVE_Library_P...

Total EPMDocuments and File Size by Context

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111791/ADMINISTRATIVE_Total%20E...

WTDocuments with File Size

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111787/ADMINISTRATIVE_WTDocumen...

Marco