This attached XML definition summarizes TIE Server information using ePO reporting capabilities.
To import it go to ePO | Menu | Queries and Report | Report | Actions | Import.
To schedule a periodic run you can use a dedicated ePO Server Task, choosing Run Report as action and Email File as sub-action.
Find a sample run over a demo environment also attached.
Thanks for sharing this
always helpfull since the TIE console even with 2.1 updates is still very unflexible and has soom bugs with IE in sorting.
If i try to import the XML into EPO 5.3.2 i get an error.
"The query could not be imported because an error occurred while trying to read the uploaded content."
* If i open the XML with a XML-Editor it looks valid
* EPO 5.3.2 (BUILD 156)
* ENS 10.5.1
* TIE 2.10 (323)
Did you BUILD the query in GUI qith report only or DID you built in own query. The info you QUERY is ALL on the SQL from EPO and not the POSTGRE DB on tie right?
I think from EPO 5.X to 5.2/5.3 most TABLE names changed (appended ********MT) like EPOProductEvents to EPOProductEventsMT
Thanks for any feedback whihc may be usefull for other also. ;-)
Greetings from Switzerland
Thanks for the input, I could reproduce what you are experiencing.
The report was manually created in ePO 5.1.1, and it is not importing in ePO 5.3.2 without modifications.
Most of the included queries use TIE Server database thru the ePO registered server connection. However, there are few queries that rely on the ePO database as well.