GET SDM CI COUNT & LIST FROM IT PAM

[Legacy User]

Am a heavy CA Advanced Workflow user and migrating over to IT PAM.

Within CA Advanced Workflow I was able to pull the Asset Count and List by
calling the Get Change Asset Count - Service Desk r12 and Get Change Asset
List - Service Desk r12 processes

I leveraged the asset count to enforce the rule that at least one CI must be
attached to the Change Order before proceeding and the asset list to display the
CI(s) on the Workflow form

How do I perform function of pulling back the CI count and CI List from a SDM Change Order ticket within IT PAM? I can pull back other variables from the ticket sucg as assignee, type, summary, scheduled start date etc but not the CI related information.

Thanks
Craig

[DEREK JOHNSON]

I'm sure there are better ways but I'd be prone to just query the DB directly. Tables are ca_owned_resource, chg and usp_lrel_asset_chgnr. This (poorly formatted query) should work on SQL:

----------------------------


USE MDB

GO



SELECT


OW.resource_name






FROM




usp_lrel_asset_chgnr

AC

,




ca_owned_resource

OW

,


chg


CG




WHERE


OW.own_resource_uuid = AC.nr


AND AC.chg = CG.id


AND chg_ref_num = '65'-- or whatever you pass in

----------------------------

If you get a NULL result then enforce your rule.



Derek-

[Anon Anon]

I would only use that query with the clause "with" in order to avoid unwanted locks to the table ca_owned_resource ( i already had problems doing querys on the table ca_contact and call_req now i always use with clause)

http://stackoverflow.com/questions/12552288/sql-with-clause-example

[Anon Anon]

There is a Custom Operator:  Get CI Details Process . This is part of the 'CA IT PAM Workflows - Pre-built for CA Service Desk Manager' from the Best Practices page.

Or you can use the 'Base Select ServiceDesk Elements Operator' from the 'CA Service Desk Connector Guide' (on which the above is based).  You want to specify 'lrel_asset_chgnr' as the ServiceDesk Object type and '"chg=" + <your change order id variable>' for the Where Clause.

-Jeff