Pulse Database: Process Error Rate

Pulse Pulse Questions
1

Hi all,

we currently want to use Pulse data for some more analysis: In our current case we want to query and report the error rate of TI-Processes for all TM1 instances on our environment for a given period. Therefore we had a look in the database and queried the table [ProcessLog].

It will give us the result (see screenshot), but it is only giving us the full history. Is there any other table we can query, so we can report the error rate for a particular month? (e.g. 01.05.2024-31.05.2024).

Thanks for any hint!

image

2

Hi @ecarmona,

Are you familiar if we are able to pull this information from Elasticsearch? Or any existing report that can be used in Pulse Explorer for this already?

Cheers!

Paul

3

Hi @plim,

Yes, it is important to clarify that the mentioned table is populated from Elasticsearch. the pulse-chore-process-history* index can be searched in discover and produce a similar result. However, in the current version of Kibana there is no export feature to csv. In the coming release with open search, SQL queries can be executed against the Elastic indices and export the results to csv.

Regards,

Erik

4

Hi @ecarmona,

Like are we able to provide a sample filter on how to achieve the above?

Can they start off from Process and Chore History for example?

image
image1832×707 73.5 KB

Do we have those RunCount and ErrorCount information readily available?

Cheers,

Paul

5

Hi Paul,

I will work something out and comeback to them

6

Hi @ecarmona, do you already have an update for us?

Thanks
Dominic

7

Hi Dominic,

I am still working on this. I will post it soon.

Regards,

Erik

1 Like
8

Dear Dominic,

I hope this message finds you well. Please upload the following file in Pulse Explorer:

ErrorCount_by_Instance.json (2.6 KB)

To do so follow these steps:

A) Open Pulse Explorer from the Pulse Web Application

B) Go to Management and Click on Saved Objects, then use the import feature to import the attached file.

image
image1657×628 125 KB

C) Once the Visualisation is uploaded you should find Under Visualise/ErrorCount_By_Instance

image
image1442×443 99.6 KB

D) Click on the visualisation and you will see a table with export to csv (called RAW export) as the following image:

image
image1603×579 58.8 KB

Let us know if you have further questions on the above.

Regards,

Erik