Creating Views to Include or Exclude Machines from My Apps

App Portal / App Broker for ServiceNow 2016

You can create views, named vMyAppsInclude and vMyAppsExclude, that contain a list of machines that can be included or excluded from the My Apps tab.

To create views to include or exclude machines on the My Apps tab:

  Include view—To define your own data source of machines for license reclamation using My Apps, create a view named vMyAppsInclude. The following is sample code:

CREATE VIEW [dbo].[vMyAppsInclude]

AS

SELECT MachineName, UniqueName

FROM vUserComputerMap

WHERE [YOUR INCLUDE CONDITION]

ORDER BY UniqueName

GO

  Exclude view—To exclude machines for license reclamation using My Apps, create a view named vMyAppsExclude. The following is sample code:

CREATE VIEW [dbo].[vMyAppsExclude]

AS

SELECT MachineName, UniqueName

FROM vUserComputerMap

WHERE [YOUR EXCLUDE CONDITION]

ORDER BY UniqueName

GO

Important • If you define a vMyAppsInclude view, then do not also define a vMyAppsExclude view. The vMyAppsInclude view is the exclusive data source of machines for license reclamation; you can define a condition that specifies which machines to exclude within the WHERE clause of this view.