Skip to main content

Creating Views to Include or Exclude Machines from My Apps

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]
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]
GO
info

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.