Report on asset assigned to users (count) each month

[Sam198]

Hi all

I need to create a report to show how many users are assigned to assets each month. Trying to do this by running monthly snapshot of ootb PA historical job"[PA CMDB] Historic Data Collection"

Indicators, indicator source, and breakdown created as follows, but the data is not showing as expected > just shows same numbers for three month period (ran the job for three months in dev environment to test)

Table can be any, I am using: cmdb_ci
Fields on cmdb_ci table: assigned_to, and department 

Indicator:

Indicator source with condition below, which is where i am suspecting i am going wrong with "Assigned to is not empty" but i am not sure:

Breakdown is ootb cis.department:

[emir]

If you are targeting computers only then go to the cmdb_ci_computer table, cmdb_ci is the entire CMDB and the queries can take time. Assigned_to is used for group assignment

Where are your computers coming from (Source)? Relationship between user and CI is usually in: cmdb_rel_person table

Do you have HAM installed?

[Sam198]

Hi Emir,

Thanks for the reply.

No we dont have HAM. Yes the main data i am after is from comdb_ci_computer so i could change it to that, i was using cmdb_ci as there was ootb PA content available (as we have the PA pro subscription) > and than i had condition for class is computer - But this should not be a problem in what i am trying to achieve and what i currently have and its devlopment environment so i am not too worried about running on cmdb_ci or either, as long as i can achieve what i am after.

For Assigned_to there is field on asset table that i am using see below:

The relationship bit i did not get it, if you saying that the cmdb_rel_person table holds this data, i checked my instance it is empty:

[emir]

alm_hardware is a table in Asset Module. It's assigned to means something different.

In the CMDB the relationship table should be populated. It seems you have some deviations form the "best practices". Do you have access to an admin who can look where the fields are mapped to?