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.