Creating Views to Include or Exclude Machines from Upgrade or Retire Campaigns
App Portal 2020 R1
You can create views that contain a list of machines that can be included or excluded from upgrade or retire campaigns.
Creating Views to Include or Exclude Machines from Upgrade Campaigns
To create views to include or exclude machines from upgrade campaigns, perform the following steps.
To create views to include or exclude machines from upgrade campaigns:
| • | Include view—To define your own data source of machines for upgrade campaigns, create a view named vUpgradeInclude. The following is sample code: |
CREATE VIEW [dbo].[vUpgradeInclude]
AS
SELECT MachineName, UniqueName
FROM vUserComputerMap
WHERE [condition]
GO
| • | Exclude view—To exclude machines for upgrade campaigns, create a view named vUpgradeExclude. The following is sample code: |
CREATE VIEW [dbo].[vUpgradeExclude]
AS
SELECT MachineName, UniqueName
FROM vUserComputerMap
WHERE [condition]
GO
Important:If you define a vUpgradeInclude view, then do not also define a vUpgradeExclude view. The vUpgradeInclude view is the exclusive data source of machines for upgrade campaigns; you can define a condition that specifies which machines to exclude within the WHERE clause of this view.
Creating Views to Include or Exclude Machines from Retire Campaigns
To create views to include or exclude machines from retire campaigns, perform the following steps.
To create views to include or exclude machines from retire campaigns:
| • | Include view—To define your own data source of machines for retire campaigns, create a view named vRetireInclude. The following is sample code: |
CREATE VIEW [dbo].[vRetireInclude]
AS
SELECT MachineName, UniqueName
FROM vUserComputerMap
WHERE [condition]
GO
| • | Exclude view—To exclude machines for retire campaigns, create a view named vRetireExclude. The following is sample code: |
CREATE VIEW [dbo].[vRetireExclude]
AS
SELECT MachineName, UniqueName
FROM vUserComputerMap
WHERE [condition]
GO
Important:If you define a vRetireInclude view, then do not also define a vRetireExclude view. The vRetireInclude view is the exclusive data source of machines for retire campaigns; you can define a condition that specifies which machines to exclude within the WHERE clause of this view.
See Also
App Portal / App Broker 2020 R1 Administration GuideAugust 2020 |