Tuesday, 29 April 2014

List of Reports and Workflows

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