Asset to CI sync report

[Kapilitsm]

Hi All,

I need to pull a report of Asset to CI sync by using alm_hardware table but whne I placed a filter stating that CI is not empty then get approximately 17K records I noticed that a few classes should be removed.

Accessory
Camera
Chrome book
printers
scanners
tablets
video and conferencing
voice system hardware

Shall I remove these classes and get the final count. I am not an experts in reporting hence looking for some suggestion.

Thanks,

[vaishali231]

hey @Kapilitsm 

I would suggest confirming the reporting requirement before excluding those classes. If they are out of scope, you can exclude them; otherwise, removing them may lead to missing valid Asset-to-CI records. It’s better to validate a few records from those classes first.

*************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.

Doing so helps others in the community and encourages me to keep contributing.

Regards

Vaishali Singh
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb