Sep 18, 2020
01:23 PM
2 Kudos
Summary This article discusses how to create views to include or exclude machines from My App reclamations. Synopsis This article discusses how to create views to include or exclude machines from My App reclamations in App Portal. Discussion 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
Additional Information 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.
... View more
Labels:
Nov 12, 2019
09:18 AM
Yes the new 2019 R2 on-prem release is now available and can be downloaded from the Product and License center. The link can also be accessed from the community site under Other Resources.
... View more
May 31, 2019
12:46 PM
@TeriStevenson Thanks for letting us know! I've updated the article to include the My Apps scheduled tasks.
... View more
Jan 21, 2019
07:49 PM
1 Kudo
Summary
This article descibes additional changes that are required after a password change is done for the App Portal Service account.
Synopsis
This article describes additional changes that are required after a password change is done for the App Portal Service account.
Discussion
Some organizations have a security policy that require account passwords to be changed periodically. If the App Portal Service account's password is changed, the new password would need to specified in the following areas: 1) For the ESDService under the services view
- Stop the service - on the "Log On" tab, re-enter the account info with the new password - Restart the service
2) In IIS manager, under application pools. select SelfService.
- Click on Advanced settings - For the Identity field, click on the ellipsis and for the custom account, specify the account name with new password
3) If using the App Portal Service account for forests/domain in the Active Directory view of App Portal the password at that location needs to be changed
- Click Admin -> Site Management -> Active Directory -> Integration - Check the configuration for each forest and domain to see if App Portal Service account is being used and change password as needed
4) Do an IISRESET from an admin command prompt window
5) Update the account running the following My Apps Scheduled tasks under the Task Scheduler | Task Scheduler Library
App Portal - Process Computers for My Apps Alerts
App Portal - Send out My Apps Email Notifications
Additional Information
To change the password for the App pools and sites please open IIS and perform the following: 1) Open IIS 2) Select Application Pools in the Connections tree 3) Select the Application Pool 4) Right Click and select Advance Settings. 5) Find Process Model / Identity. The default may read ApplicationPoolIdentity 6) Click to the value (e.g. ApplicationPoolIdentity) 7) Click the ellipsis that appears to the right 😎 Select a built in account or click custom account 9) If Custom account was chosen, click Set and specify the Windows account and password 10) Click OK to close the Set Credentials dialog 11) Click OK to close the Application Pool Identity dialog 12) Click OK to close the Advanced Settings dialog. 13) Recycle the Application Pool. For sites please navigate to each site and change the authentication settings as appropriate.
... View more
Labels:
Nov 07, 2018
07:23 PM
Summary This article provides information on the fixes included in App Portal 11.0.3 (App Portal 2016 Service Pack 3) version. Synopsis This article provides information on the fixes included in App Portal 11.0.3 (App Portal 2016 Service Pack 3) version. Discussion App Portal 11.0.3 version includes the following fixes: App Portal 2016 Cumulative Service Pack 3
IOJ-1822979 - LastStatusID not set correctly for Task Sequences in DB IOJ-1824955 - App Portal does not enumerate AD groups correctly hence tabs not appearing correctly for users IOJ-1824959 - User/Device data sync error results in stop of sync process IOJ-1743586 - EULA notification does not support translation IOJ-1823376 - Having an apostrophe in the email address causes Single Sign-On mapping to fail IOJ-1823682 - Jobs Based Reclamation Process handles MyApps crashes when running the reclamation through task scheduler IOJ-1823474 - Catalog Categories view no longer appears after installing SP2 IOJ-1823626 - App Portal Does Not Support Re-Install of an AirWatch Mobile Catalog Item that has been Previously Installed (and Optionally Deleted) IOJ-1760343 - All icons, and red exclamation, displayed on My Requests page IOJ-1824684 - Searching Apps list from New Catalog Wizard not finding any results IOJ-1772747 - Reclamation alerts not created when more than one CI targets the same flexera ID IOJ-1772594 - Invalid column name error thrown in the MyApps_Exceptions.log file IOJ-1824960 - EULA does not display on the Browse Catalog page
The latest App Portal 2016 Service pack can be downloaded by logging in to the Product and License Center.
... View more
Nov 07, 2018
07:21 PM
Summary Resolve the execute permission error being thrown. Symptoms In the databaseCalls_Error.log file the following exception may be seen: The EXECUTE permission was denied on the object 'fn_GetAppState', database 'CM_CAS', schema 'dbo'. The EXECUTE permission was denied on the object 'fnGetSiteNumber', database 'CM_CAS', schema 'dbo'. Cause This appears to be a database permissions issue on the SCCM database. Workaround To workaround this issue, add the App Portal service account to the smschm_users role on the SCCM database. The smschm_users role grants Execute permission to the SCCM database. Additional Information This issue is being tracked internally as Issue #IOA-000124115
... View more
Labels:
Nov 07, 2018
07:20 PM
Summary
When attempting to access the App Portal Site, HTTP Error 500.19 is encountered
Symptoms
When attempting to access the App Portal Site, the following error may be displayed in the browser:
Cause
The Windows Authentication section is locked for the Default Web Site
Resolution
To unlock Windows Authentication at the Default Web Site level, 1. Using IIS manager, select Default Web Site under the Sites view 2. Under the Management section, select Configuration Editor 3. In the Section field, select System.WebServer/Security/authentication/WindowsAuthentication 4. Select "Unlock Section"
... View more
Labels:
Nov 07, 2018
07:18 PM
Summary Notifications can be customized to include the type of action selected in the request by using the standard variable ##Action## Synopsis Notifications can be customized to include the type of action selected in the request by using the standard variable ##Action## Discussion By default, some of the notifications indicate requests being submitted and executed successful, however these notifications do not differentiate whether the request action was an install or uninstall. These notifications can be customized to include the variable ##Action## within the message which would end up resolving to the type of request that was submitted. E.g. The ?Software - Install Successful" notification has the following wordings:
"The installation of ##PackageTitle## has succeeded for the following computer:"
The notification can be customized to:
"The ##Action##ation of ##PackageTitle## has succeeded for the following computer:" Additional Information For additional information, see Managing Notification Email Templates and Messages
... View more
Labels:
Nov 07, 2018
07:14 PM
Summary This article provides information on the fixes and the link for App Portal 2015 R2 Service Pack B (10.0.2 version) Synopsis This article provides information on the fixes included in App Portal 2015 R2 Service Pack B (10.0.2 version) and the download link for that version. Discussion App Portal 10.0.2 version includes the following fixes: App Portal 2015 R2 Service Pack B
IOJ-1745634 - Cross-Site Request Forgery in Web forms IOJ-1736414 - Input Validation IOJ-1736412 - Potential File Upload IOJ-1736411 - Cross-Site Request Forgery in MVC views IOJ-1736410 - Unencrypted Login Request IOJ-1736408 - Penetration Test and Vulnerability Assessment IOJ-1745077 - Catalog Items that are not enabled get displayed in the what's new and most popular section IOJ-1745467 - Default answers are not selected for Drop-down and Radio button answers IOJ-1744229 - Hide Sites from software publication setting not being saved IOJ-1744231 - Disable Approval for Leased Installations setting not working IOJ-1736413 - Session Identifier Expiration IOJ-1748660 - Collection Conditions for Altiris evaluated incorrectly
The hotfix can be downloaded from the following link: App Portal 2015 R2 Service Pack B Additional Information The App Portal hotfixes and service packs are cumulative. Only the latest release would need to be installed. Current Available Hotfixes or Service Packs for App Portal 2015 R2 Version
... View more
Nov 07, 2018
06:55 PM
Summary This article provides information on the fixes included in App Portal 11.0.1 (App Portal 2016 Service Pack 1) version Synopsis This article provides information on the fixes included in App Portal 11.0.1 (App Portal 2016 Service Pack 1) version Discussion App Portal 11.0.1 version includes the following fixes: App Portal 2016 Cumulative Service Pack 1
IOJ-1774302 - Error in ESDService.log IOJ-1777476 - Group permissions not taking effect after upgrade. IOJ-1770970 - Non Admin user gets error when attempting to add catalog item from "Most Popular" IOJ-1781012 - OU Conditions are not evaluated correctly. IOJ-1781259 - MyApp Action Alerts not working IOJ-1781148 - Link to Request is not redirecting to App Portal on using SAML settings IOJ-1780781 - Ampersand in the machinename causes an XML parsing error during 'data sync' IOJ-1590772 - Provide way to block the request from being made, if made within "X" number of days. IOJ-1805166 - OS Deployment has exception on submit for new machines. IOJ-1773790 - User Impersonation doesn't work
The latest App Portal 2016 Service pack can be downloaded by logging in to the Product and License Center.
... View more
Nov 07, 2018
06:54 PM
Summary This article provides information on the fixes included in App Portal 9.0.2.0 (App Portal 2014 Hotfix B) version Synopsis This article provides information on the fixes included in App Portal 9.0.2.0 (App Portal 2014 Hotfix B) version. Discussion App Portal 9.0.2.0 version includes the following fixes: App Portal 2014 Hot Fix B
IOJ-1666808 - Add Support for App Portal integration with FNMS-Cloud IOJ-1666836 - Clicking on the Catalog Item Icon does not do anything IOJ-1666837- Announcement section in App Portal header flashes in the new browse UI IOJ-1665667 - Unable to search for targets when using "request on behalf of" IOJ-1666835- Catalog Item text in tile view does not wrap IOJ-1667122- The search bar in browse page does not shrink based on the browser size IOJ-1665432 - Welcome menu is hidden after browser resize IOJ-1665845 - Use SCCM 2012 to trigger a policy refresh on the client instead of doing a policy refresh directly on the client machine IOJ-1665846 - Provide support for a cost range when adding a condition for approval IOJ-1665970 - Add a new API in Integration.asmx set status on a request IOJ-1666747- Error generating proxy message thrown when running Orchestrator Action IOJ-1662906- Allow for app titles to wrap to multiple lines in "tile" view (App Portal v9.x) IOJ-1667057- Issue in displaying the logo in details view when the logo is larger IOJ-1699368- User Readiness Import using XLSX file does not work IOJ-1700058- When user types a Japanese character response to a question during checkout, it does not get saved correctly. The response is shown as ???? IOJ-1666665 - Sometimes the categories are hidden/visible for end-user even though the visibility condition is set correctly. IOJ-1667188- Search button description Additional Information If you are experiencing similar issues in your environment, please contact Technical Support to obtain this hotfix version
... View more
Nov 07, 2018
06:53 PM
Summary This article provides information on the fixes included in App Portal 8.5.0.2 (App Portal 2013 R2 Hotfix B) Synopsis This article provides information on the fixes included in App Portal 8.5.0.2 (App Portal 2013 R2 Hotfix B) version. Discussion App Portal 8.5.0.2 version includes the following fixes: App Portal 2013 R2 Hot Fix B
IOA-000084558 Reverse DNS does not work in 7.5.5.x IOA-000082548 ##ORDER_NO## does not resolve in "request for approval" notification IOA-000082836 Cloned request not inserting into install collections when machine name is typed in lowercase IOA-000080126 Certain variables not being resolved in notifications: IOA-000084482 Unable to cast object error when expanding a group order IOA-000084246 Can no longer filter requests according to Install Status IOA-000083444 ##RequestID## is a variable in a scripted command works and equivalent ##Order_No## variable does not work IOA-000084023 Requester information incorrect on some reports IOA-000084726 Execute Reader: CommandText property has not initialized is received when user clicks on an order that is part of group catalog IOA-000084835 After saving workflow group based on SCCM collections, collections are not displayed after saving IOA-000079785 Deployment settings of applications do not pass over to SCCM IOA-000082769 Apply to OU and child OUs will not stay checked on IOA-000080504 Question Manager - lost the ability to set defaults for questions IOA-000085139 Apostrophe in catalog item name creates deployments with advertid -1 IOA-000084838 Collection Variables and Computer variables button does not work in SCCM 2007 IOA-000085006 License cost not displayed during checkout if locale is different from en-US Approve/Reject tab throws server Error as 'lblRequester' were found. FindControl requires that controls have unique IDs. When SCCM 2007 is configured to use central site for deployment, during Checkout App Portal still validates if the package exists in the client's site and display a warning message App Portal now syncs collection memberships from both SCCM 2012 and SCCM 2007 uses it to check for evaluating conditions that use collection membership IOA-000084911 Deselecting the Create DDR option in settings displays a blank page when an end-user logs in IOA-000123875 Deployment status is not updated correctly under My Requests in SCCM 2012 App Model deployments when application has multiple deployment types and each of them has different requirement conditions set Added support to show Imported Users/Computers/User Computer Relationships. This is available in Admin->Site Settings Added support to allow selecting collections from both SCCM 2007 and SCCM 2012 in standard conditions Fixed a performance issue during logon where synching a single user and device was taking a long time in some cases Fixed an issue where the lease duration could not extended beyond 1 day In SCCM 2007 when submitting OSD request, computer variables written to the device does not honor the install sequence
App Portal 2013 R2 Hot Fix A
OSD request does not populate computer variables for applications that needs to be migrated Added support for using SSL when configuring SMTP email Correctly enabling/disabling the Leasing option based on whether or not the uninstall program is available in added deployment types in the catalog item Correctly selecting only the CAS server when adding a SCCM 2012 Application/Package to an existing catalog item
Additional Information If you are experiencing similar issues in your environment, please contact support to obtain this hotfix version
... View more
Nov 07, 2018
06:53 PM
Summary This article provides information on the fixes included in App Portal 10.0.4 (App Portal 2015 R2 Service Pack 4) version Synopsis This article provides information on the fixes included in App Portal 10.0.4 (App Portal 2015 R2 Service Pack 4) version Discussion App Portal 10.0.4 version includes the following fixes: App Portal 2015 R2 Service Pack 4
IOJ-1745757- Support for Microsoft System Center Configuration Manager (Current Branch) IOJ-1590664 - Web Service API returnValueVariable is being set to MethodName instead of the webservice name. IOJ-1743802 - When using System Center 2012 Configuration Manager, status updates for packages and task sequences were not getting updated in the user?s environment. To address this issue, a new option was added to the SCCM 2012 and ConfigMgr tabs on the Site Management > Settings > Deployment view entitled Use v_ClassicDeploymentAssetDetails to get package deployment status. If this option is selected, App Portal will obtain the deployment status from an alternate view in System Center Configuration Manager. IOJ-1745926 - When an alternate message that used an apostrophe character was specified on the Visibility > Alternate Message tab of the Catalog Item Properties dialog box, instead of hiding the catalog item that has visibility conditions, App Portal was displaying the catalog item, but nothing would happen when you attempted to add the catalog item to the cart. IOJ-1748310 - When only one announcement was defined, HTML code was being displayed instead of being rendered. Also, the announcement title was not being displayed and the announcements window would not open. Exclude conditions on announcements were being ignored. There were also permissions issues on announcements. IOJ-1751696 - When the Check for license position during checkout option on the FlexNet Manager Suite > Mapping tab of the Catalog Item Properties dialog box setting is not selected, you cannot add the ?most popular? and ?net? catalog items on the Browse Catalog tab to the cart IOJ-1752387 - On the Browse Catalog tab, when viewing a category that has no catalog items, the text 0 item is displayed. It should say 0 items. IOJ-1754150 - User requested the ability to remove links from email notifications. IOJ-1754239 - ITSM actions were not being invoked in some cases when a catalog item request required an approval. The first time the user submitted the request, the ITSM actions associated to the catalog item were not run even though it had been approved. If the same user submitted the request a second time, the ITSM actions would run. IOJ-1754794 - Some labels for check boxes are wrapping incorrectly when displayed. If the label of a check box question is too long, the entire word is moved to the line below the check box. leaving the check box on a line by itself. IOJ-1755254 - My App alert email notifications are not being sent out for unused software and catalog item action alerts. IOJ-1755263 - Request to have App Portal perform a client inventory update in Casper after a successful deployment. IOJ-1755460 - Request to provide a web service to check and update database for status updates. IOJ-1755611 - The My Apps notification date was being displayed in UTC time instead of local time. IOJ-1756072 - The creation of default operations for BMC Remedy failed when HTTPS site protocol was used. IOJ-1756083 - Request to provide API support for adding a catalog item for a task sequence with existing deployment, similar to existing support for adding application or package catalog items. IOJ-1756483 - The email notification to ?Notify user once the uninstallation of unused software is complete? was incorrectly being when a request was submitted. IOJ-1756487 - When App Portal checked the deployment technology of a Mac Casper device, it mistakenly detected it as an SCCM 2012 device IF the Define order for detecting client deployment technology setting had SCCM 2012 listed first. IOJ-1756604 - Request to add a Test button to the License View field on the Settings > Web Site > General tab. IOJ-1756894 - The legacy license reclamation feature was generating errors and not creating uninstall requests. IOJ-1757323 - When checking out a General catalog item which requires approval, if you specify that you are ?requesting on behalf? of someone else during checkout, the checkout fails. IOJ-1757748 An exception is generated when you attempt to disable legacy license reclamation.
The latest App Portal 2015 R2 Service pack can be downloaded by logging in to the Product and License Center. Additional Information App Portal 2015 R2 Service Pack 4 Release Notes Current Available Hotfixes or Service Packs for App Portal 2015 R2 Version
... View more
Nov 07, 2018
06:51 PM
Summary This article provides information on the fixes included in App Portal 2015 R2 Service Pack A (10.0.1 version) Synopsis This article provides information on the fixes included in App Portal 2015 R2 Service Pack A (10.0.1 version). Discussion App Portal 10.0.1 version includes the following fixes: App Portal 2015 R2 Service Pack A
IOJ-1743078 - Add support for using Proxy Server in App Portal when connecting to Internet Services IOJ-1743040 - Exception is thrown in the DataSync.log when synching a device having multiple IP Addresses IOJ-1742772 - When updating LastStateTime take greater of the InsertDate and LastStateTime returned from SCCM IOJ-1742538 - In logs the details about the 'Webservice' and the 'Command Action' are logged even though there is no webservice or command action attached to the CI. IOJ-1664328 - Collation conflict when adding variable to roles IOJ-1743329 - Add cost/currency and deployment details to API response IOJ-1743495 - Cannot enter form data, receive error on submit IOJ-1743555 - German language translation are cutoff in the toolbars IOJ-1743557 - Day, month, year date setup does not work in dashboard IOJ-1743792 - ITSM actions are not applied from Catalog Templates IOJ-1743777 - Get Email from App Portal database if AD fails
The service pack can be downloaded from the following link: App Portal 2015 R2 Service Pack A Additional Information The App Portal hotfixes and service packs are cumulative. Only the latest release would need to be installed. Current Available Hotfixes or Service Packs for App Portal 2015 R2 Version
... View more
Nov 07, 2018
06:47 PM
Summary The error is encountered when accessing the admin security or catalog security tab Symptoms The following error might be encountered when accessing either of the following tabs:
Admin | Site Management | Admin Security Admin | Site Management | Catalog Security tab
Server Error in '/ESD' Application. The source contains no Datarows. Cause The error is caused when App Portal attempts to load an invalid Admin security mapping or Catalog Security mapping stored in the App Portal database. This can happen when an Active Directory user or group that is currently mapped in the database is no longer valid in Active Directory. Workaround To workaround the issue, make a backup copy of the database and run the following SQL queries against the App Portal database to remove all the current security mappings. You can then repopulate the security mappings with valid Active Directory entries. If the error occurs under the Admin -> Site Management -> Admin Security tab, run the following SQL query: delete from WD_NodeSecurity If the error occurs under the Admin -> Site Management -> Catalog Security tab, run the following SQL query: delete from WD_CatalogSecurity After the manual database update, do an IISRESET on the App Portal Server. Log in to the App Portal site and repopulate the security mappings with valid Active Directory groups/users. Additional Information This issue has been fixed in App Portal 2015 R2 where the invalid Active Directory entry is shown as a blank account and can be deleted by the administrator account.
... View more
Latest posts by saleman
Subject | Views | Posted |
---|---|---|
1180 | Sep 18, 2020 01:23 PM | |
3521 | Nov 12, 2019 09:18 AM | |
2234 | May 31, 2019 12:46 PM | |
2378 | Jan 21, 2019 07:49 PM | |
671 | Nov 07, 2018 07:23 PM | |
1602 | Nov 07, 2018 07:21 PM | |
1264 | Nov 07, 2018 07:20 PM | |
603 | Nov 07, 2018 07:18 PM | |
648 | Nov 07, 2018 07:14 PM | |
589 | Nov 07, 2018 06:55 PM |
Activity Feed
- Posted How to Do My App Reclamation on Specific Machines in App Portal on App Broker Knowledge Base. Sep 18, 2020 01:23 PM
- Posted Re: FlexNet Manager Suite 2019 R2 - on-premises release on FlexNet Manager Release Blog. Nov 12, 2019 09:18 AM
- Posted Re: App Portal Service Account Password Change on App Broker Knowledge Base. May 31, 2019 12:46 PM
- Posted App Portal Service Account Password Change on App Broker Knowledge Base. Jan 21, 2019 07:49 PM
- Posted App Portal 2016 Service Pack 3 on App Broker Knowledge Base. Nov 07, 2018 07:23 PM
- Posted Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber' on App Broker Knowledge Base. Nov 07, 2018 07:21 PM
- Posted Error 500.19 when Accessing the App Portal Site on App Broker Knowledge Base. Nov 07, 2018 07:20 PM
- Posted Customize Notifications to Include the Action Type (Install or Uninstall) of the Request on App Broker Knowledge Base. Nov 07, 2018 07:18 PM
- Posted App Portal 2015 R2 Service Pack B on App Broker Knowledge Base. Nov 07, 2018 07:14 PM
- Posted App Portal 2016 Service Pack 1 on App Broker Knowledge Base. Nov 07, 2018 06:55 PM
- Posted App Portal 9.0.2.0 HotFix on App Broker Knowledge Base. Nov 07, 2018 06:54 PM
- Posted App Portal 8.5.0.2 HotFix on App Broker Knowledge Base. Nov 07, 2018 06:53 PM
- Posted App Portal 2015 R2 Service Pack 4 on App Broker Knowledge Base. Nov 07, 2018 06:53 PM
- Posted App Portal 2015 R2 Service Pack A on App Broker Knowledge Base. Nov 07, 2018 06:51 PM
- Posted Server Error in '/ESD' Application. The source contains no DataRows. on App Broker Knowledge Base. Nov 07, 2018 06:47 PM
- Posted Catalog Item Is Not Available at the Site for User/Machine on App Broker Knowledge Base. Nov 07, 2018 06:39 PM
- Posted App Portal 2015 Hot Fix A on App Broker Knowledge Base. Nov 07, 2018 06:32 PM
- Posted App Portal 2016 Service Pack 4 on App Broker Knowledge Base. Nov 07, 2018 06:32 PM
- Posted App Portal 2015 R2 Service Pack C on App Broker Knowledge Base. Nov 07, 2018 06:31 PM
- Posted App Portal 2015 R2 Service Pack C Update 1 on App Broker Knowledge Base. Nov 07, 2018 06:30 PM