Workflows- Run against the *_MSCRM database
SELECT name , createdbyname,createdon,statuscodename
FROM FilteredWorkflow
Reports run against the ReportServer database
Select [Name],
[Description],
SubString([Path],1,Len([Path]) - (CharIndex('/',Reverse([Path]))-1)) As [Path],
Case
When [Hidden] = 1
Then 'Yes'
Else 'No'
End As [Hidden]
From [Catalog]
Where [Type] = 2
Order By SubString([Path],1,Len([Path]) - (CharIndex('/',Reverse([Path]))-1)),
[Name]
No comments:
Post a Comment