Hi folks,
I'm building a SQL report for checking Policy Compliance. I am finding problems however trying to find where the English name of a Managed Software Delivery Policy Name is. I can find a table with the GUID only; Inv_Policy_Compliance_Status...which is part of the report. I would rather someone could show me the table where both the GUID and the name is so I can join them and then re-use the report with the name of the policy as a parameter, but for some reason this is eluding me.
Any help appreciated.
Mike
Or there's maybe a view with it aready done.
Or look at the relevant report.
Yes, although Item had it as you said, we went with the third option: opened the report by saving it and editing. This led us to vNonResourceItem which is more specific and faster from a third party search view.
Cheers