Client Management Suite

Looking for a SQL query or report that shows all the running (active) manage delivery policies.

Here is simple query to see all available enabled Items in your database

SELECT
ia.Guid,
i.Name,
ia.Enabled,
i.CreatedBy,
i.CreatedDate,
i.ModifiedBy,
i.ModifiedDate

FROM ItemActive ia
JOIN Item i
ON i.Guid = ia.Guid
WHERE ia.Enabled = 1
ORDER  BY i.Name
ASC

To piggy-back off of Igor's comment, this can help narrow it down a bit more. Notice I did not include 'ia.Enable = 1'. You can add this into the where clause if needed to find active. Otherwise, the Enabled column will be 1 for enabled and 0 for disabled.

select ia.Guid,
	i.name,
	ia.Enabled,
	i.CreatedBy,
	i.CreatedDate,
	i.ModifiedBy,
	i.ModifiedDate
from item i
left join itemactive ia
	on ia.guid = i.guid
where ProductGuid = 'AD3F5980-D9E9-11D3-A318-0008C7A09198' --Software Management Solution 8.1 RU1
	and ia.guid is not null
	and i.name != ''
order by i.name asc

To piggy-back off of Igor's comment, this can help narrow it down a bit more. Notice I did not include 'ia.Enable = 1'. You can add this into the where clause if needed to find active. Otherwise, the Enabled column will be 1 for enabled and 0 for disabled.

select ia.Guid,
	i.name,
	ia.Enabled,
	i.CreatedBy,
	i.CreatedDate,
	i.ModifiedBy,
	i.ModifiedDate
from item i
left join itemactive ia
	on ia.guid = i.guid
where ProductGuid = 'AD3F5980-D9E9-11D3-A318-0008C7A09198' --Software Management Solution 8.1 RU1
	and ia.guid is not null
	and i.name != ''
order by i.name asc