Having trouble collecting historical server data in PA

[joseph_johnson]

Hi Everyone!

This is my first question to the community thank you in advance for your responses. I'm having trouble gathering Historical server data in PA. What I'm looking for is operational servers. We use the field install_status so my condition on the indicator source is: install status is installed.

I have pulled this data from the cmdb_ci_server table and the cmdb_ci_computer table and received the same results.

My indicator has some additional conditions:

Manufacturer does not contain vmware
and
Class is Windows Server
or Class is Linux Server
or Class is ESX Server
and
location does not contain azure.

When i run a historic job it pulls data but the count is the same for every day ( 205). I have reviewed the data and found that there have been changes, some servers retired where the install status DID change, but the score did not update change from one day to the next with the number of installed servers.

Some of the currently retired servers (previously installed and active) do not show in the report at all during the time frame that they met the conditions, as if it's gathering current data only instead of a snapshot of each day.

An example is on March 17th a server was retired, it doesn't show in the records/score Prior to March 17th.

Is there something I am missing, or is there a way that i can get this data? I am trying to create a historical trend report to show operational servers by month.

Thank you,
Joe Johnson