If you know how to make Report Data Objects in Service Catalog then here is the foundation for a query to list all the CIs directly related to a contact:
SELECT own_resource_uuid
, resource_name
FROM ca_owned_resource
JOIN usp_lrel_cenv_cntref ON usp_lrel_cenv_cntref.nr = ca_owned_resource.own_resource_uuid
JOIN ca_contact ON ca_contact.contact_uuid = usp_lrel_cenv_cntref.cnt
WHERE userid = 'lnestabrooks'
Cheers
------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------
Original Message:
Sent: 12-06-2019 05:40 PM
From: Jose Romero
Subject: how to make catalog filter cis by user in a form of ca service catalog
Good afternoon
Dear Community
There is a requirement to make a form filtering Ci´s associated to the user that raises the requirement something similar as does service desk, is this possible? how would I have to tie up the problem
Cheers