Birkaç kullanışlı Dataverse / Dynamics 365 SQL Sorgusu – 1

Audit özelliği etkinleştirilmiş tabloların listesini sorgulama :
SELECT logicalname,
displayname,
isauditenabled
FROM metadata.entity
WHERE isauditenabled = 1
ORDER BY logicalname;

Audit özelliği etkinleştirilmiş tablo başına alan listesini sorgulama :
SELECT entitylogicalname,
logicalname AS columnname,
displayname,
isauditenabled
FROM metadata.attribute
WHERE isauditenabled = 1
AND entitylogicalname IN (SELECT logicalname
FROM metadata.entity
WHERE isauditenabled = 1)
ORDER BY entitylogicalname, columnname;

Farklı aktivite türlerine göre toplam aktivite kaydı sayısını sorgulama :
SELECT activitytypecodename,
activitytypecode,
Count(activitytypecode) AS Total
FROM activitypointer
GROUP BY activitytypecode, activitytypecodename
ORDER BY Total DESC;

Tüm kullanıcıların saat dilimi (time zone) bilgilerini sorgulama :
SELECT su.fullname,
su.domainname,
us.timezonecode,
tz.userinterfacename,
tz.standardname
FROM usersettings AS us
INNER JOIN
systemuser AS su
ON us.systemuserid = su.systemuserid
LEFT OUTER JOIN
timezonedefinition AS tz
ON us.timezonecode = tz.timezonecode
ORDER BY su.fullname;

Belirli bir alanın referans alındığı/kullanıldığı bulut akışlarının (cloud flows) listesini sorgulama :
SELECT wf.name,
wf.workflowid,
wf.clientdata
FROM workflow AS wf
WHERE wf.category = 5
AND LOWER(wf.clientdata) LIKE ‘%custom_actualsettlementdate%’;