mqmathews
Level 4

Notifications

Jump to solution

Can I get a email notification when new packages are added to app portal?

0 Kudos
1 Solution

While there is no feature in App Portal that allows for this, you could create a report in SQL Server Reporting Services using the following query:

SELECT [PackageID]
      ,[PackageTitle]
      ,[BriefDescription]
      ,[PackageVisible]
      ,[Deleted]
      ,[CreatedBy]
      ,[CreatedOn]
      ,[UpdatedBy]
      ,[UpdatedOn]
  FROM [AppPortal].[dbo].[WD_WebPackages]
  WHERE [CreatedOn] > DATEADD(HOUR,-24,GETUTCDATE())

This will show all catalog items created in the previous 24 hours.  Then set up a subscription to send yourself the report each day.   If you only want to see catalog items that were created and not subsequently archived, you could modify the query to move the [Deleted] column to the WHERE clause as "AND [Deleted] = 0".

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".

View solution in original post

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

2 Replies
dpiarowski
Level 3 Flexeran
Level 3 Flexeran

Unfortunately at this time, there is no feature in App Portal to send out emails when new packages have been added.  

0 Kudos

While there is no feature in App Portal that allows for this, you could create a report in SQL Server Reporting Services using the following query:

SELECT [PackageID]
      ,[PackageTitle]
      ,[BriefDescription]
      ,[PackageVisible]
      ,[Deleted]
      ,[CreatedBy]
      ,[CreatedOn]
      ,[UpdatedBy]
      ,[UpdatedOn]
  FROM [AppPortal].[dbo].[WD_WebPackages]
  WHERE [CreatedOn] > DATEADD(HOUR,-24,GETUTCDATE())

This will show all catalog items created in the previous 24 hours.  Then set up a subscription to send yourself the report each day.   If you only want to see catalog items that were created and not subsequently archived, you could modify the query to move the [Deleted] column to the WHERE clause as "AND [Deleted] = 0".

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".