Hi Monica,
The views you might use are: RPT_SolutionView, RPT_UserView (if you want to know who created it), RPT_AppGroupView (the closest I could get to a list of AppNames - had to use a standard group name in the where clause to get app names only once) or table UG_TeamSpace which lists the app names.
I used this SQL, which may include more or less info than you want - swap
yourdbname for your database name:
SELECT
t.[Name] as AppName,
t.[Description] as AppDescription
,[Title]
,s.[Description]
,[SAPConnectionName]
,[SapSystemId]
,[SapClient]
,[SystemPost]
,[Autorun]
,[Runnable]
,[RunnerRequired]
,u.[DisplayName] as CreatedByName
,s.[CreatedDate]
,s.[ModifiedDate]
,[Status]
,[Version]
,[MultipleScriptType]
,[DataReviewProcess]
,[DataReviewProcessName]
,[DataSource]
,[Category]
,[LinkedScriptFiles]
,[LinkedScriptDescription]
,[ScriptVersion]
FROM [
yourdbname].[dbo].[RPT_SolutionView] s , [
yourdbname].[dbo].[UG_TeamSpace] t, [
yourdbname].[dbo].[RPT_UserView] u
where s.AppId = t.[TeamSpaceId] and s.createdBy = u.UserId and t.[Name] <> 'Administration'
order by t.[Name], Title
I used the table name UG_TeamSpace, even though tables are not recommended for reporting . You could use RPT_AppGroupView to get the appname, but it has all apps and all groups in the apps. So, you would have to filter on a standard group, adding to the WHERE clause: and Groupname = 'Solution Reviewer'
Hope that helps,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 04-29-2022 09:34
From: Monica Anicito
Subject: Studio Manager Reports
Hi Community!
Anyone out there have a SQL query for a Studio Manager report that will return a list of solutions contained in an App? We would like to be able to download a list of all the solutions in excel. Any help would be appreciated!
------------------------------
Monica Anicito | Master Data Project Lead
Ortho-Clinical Diagnostics, Inc., Raritan, NJ
------------------------------