How to get Aging report on CI Attributes

[Anil74]

Hi Team,

Is it possible to get aging report on attributes for different CI types.

Ex- Need to pull the aging report on "Environment" attribute when it was updated with some value from Null value and how many days it has Null value in it for Personal Computer CI Type.

Thank you.

[Dr Atul G- LNG]

Hi @Anil74 

NOt 100% sure, but by discovery we can see. There is last run field or something which can be used for aging.

@AJ-TechTrek any thoughts

[AJ-TechTrek]

Hi @Anil74 

Yes you can create the report on Sys_history_set for each class level for Attribute ageing.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

[Anil74]

Thank you Atul and Ajay for your response. 

Hi @AJ-TechTrek , can you please provide more details how can we generate report on Sys_history_set table?

[AJ-TechTrek]

Hi @Anil74 

Use the Sys_history _set table to create a Report, you can open any CI and open the History list view of CI from three Parallel Line in left , You can Easily understand how the report will be created.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/