Display all the assets assigned to User

[Community Alums]

Hi Experts,

We have a requirement, it is to Display all the assets assigned to Affected user in a catalog item. Affected user is a reference variable pointing to (sys_user table).

If user has one asset it should display as below image (1)

If the affected user has multiple devices it should display as below image (2)

Note:  Assets should be displayed from cmdb_ci_computer table.

[Sai Kumar B]

@Sagar Garige @Community Alums  If my response is helpful, You can mark it as correct and close the question loop. It would help future readers as well.

[Sai Kumar B]

@Community Alums @Sagar Garige Any update on this?

[Sagar Garige]

Hi Sai Kumar,

I have tried your code but it is working partially.
eg: In our PDI Beth Anglin has three assets assigned to her but it displays only one among them.

What we can do to display all the three assets at a time?
Thanks in advance,

[Sagar Garige]

Hello @Sai Kumar B 

Your reply is Highly Appreciated.

Thanks in advance,

[James Rostron]

I too have the same issue with this code.

It only retrieves the first record found not all CIs.

There is also a missing syntax in the client script that I needed to add.

@Sai Kumar B - Are you able to review this code?