From which tables does the Data Collector Jobs collecting historical data

[kkissing]

Hi,

i have a generel question concerning the data collection process in PA.

Where are the historical information stored ? Is there special/separate table for that?

e.g.: If i want to collect incident information for the last 3 months

Do i have enable the audit for incident first ?

If yes, is audit creating a second table for incident only for audit purposes ? With with prefix does this table start ?

If no, how can the data collector job collect this kind of historical data and determine all the changes on a record ?

Many thanks in advance,

Karsten

[Chuck Tomasi]

HI Karsten,

The data collector stores the meta information (not a copy of the records) in pa_scores table. You do not need audit turned on to have PA work. PA only tracks what you tell it to track based on the indicator source and indicators.

[kkissing]

Thanks for you answer.

[Chuck Tomasi]

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you