About joan_mckinley

joan_mckinley · ‎May 04, 2022

We are testing My Apps and license reclamation in our environment. We would like to send an email to user that would include the link to Keep or Uninstall. We updated the notification that gets sent and included the variables: ##UninstallLink## and ##KeepLink## in it. However, the email just shows the variable name and it is not an actionable link. Management would prefer the user click on it from the email rather than have to launch My Apps and click Keep or Uninstall from My Current Alerts. Is there a way to do that? Thanks! Joan

joan_mckinley · ‎Mar 09, 2022

We are trying to add a custom field to the “All Licenses” node Consumption tab. We want to add a “Comments” field for each user that is consuming. We are using this code: EXEC dbo.AddPropertyToWebUIPropertiesPage @TargetTypeID = 12, @ExcludeTargetSubTypeIDs = '', @Name = 'GDMS_Comments', @CultureType = 'en-US', @DisplayNameInPage = 'Comments', @DisplayNameInReport = 'Comments', @RelativePositionTo = 'Used', @TabName = 'Tab_Consumption', @UIInsertTypeID = 2, @UIFieldTypeID = 4, @Position = 0, @Width = 5, @StringLength = 100, @ReadOnly = 0 It executes but we receive an error when we try to go into a license. If we delete that custom field, the licenses page works again. Do you see anything wrong with the script? Thanks! Joan

joan_mckinley · ‎Jan 05, 2022

Thanks jdempsey! We ended up switching our SQL Server to IaaS instead of PaaS. It worked after that.

joan_mckinley · ‎Dec 08, 2021

Thank you Chris, that is very helpful!

joan_mckinley · ‎Nov 01, 2021

Does Flexera have antivirus exclusion recommendations documented anywhere for FlexNet Manager Suite on Prem? We are currently at 2020R1 but will be upgrading to 2021R1 in a month. This does not help us since it isn't in Flexera documentation: Anitivirus Exclusions - Community (flexera.com) Thanks! Joan

joan_mckinley · ‎Oct 01, 2021

Hi Chris, Thanks for the reply. By default the config files are referencing system.data.sqlclient. How do we change to Microsoft.data.sqlclient within the App Portal application? Thanks, Joan

joan_mckinley · ‎Sep 30, 2021

We migrated our App Portal environment to Azure. We are only able to get it to connect to the database by using a plain text user ID and password in the connection strings in the web.config files. We can't leave it with a plain text password. We want to use Active Directory MSI for authentication. We updated the files in: <AppPortal Install Location>\App Portal\Web\web.config <AppPortal Install Location>\APM\Web.config <AppPortal Install Location>l\Service\ESDService.exe.config <AppPortal Install Location>\Utilities\MyApps\AppPortal.App.MyAppsExecutables.exe.config With this connection string but it gives us an error when we try to start the ESD Service: <SQLServerName>;Initial Catalog=AppPortalDEV;Authentication="Active Directory MSI"; Error is: App Portal could not load its required settings. Error is : Invalid value for key 'authentication'. at System.Data.Common.DbConnectionStringBuilderUtil.ConvertToAuthenticationType(String keyword, Object value) at System.Data.SqlClient.SqlConnectionString.ConvertValueToAuthenticationType() at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at System.Data.SqlClient.SqlDataAdapter..ctor(String selectCommandText, String selectConnectionString) at SelfService.ESDConfig.getConfigValue(String strName) at ESDService.ESDService.GetConfig(Boolean bIsFurstRun) Thanks, Joan

joan_mckinley · ‎Sep 01, 2021

Hi Chris, Thanks for the response. We have a development server that we can point to for FNMS but we would want to point to our production SCCM server. We are trying to understand what the risks are. If we delete a catalog item in the Dev App Portal, will it delete the deployment in SCCM? We are going to test this when the DB is restored. We could create a new DB for our Dev environment but we would still want to point to our production SCCM server. Can you help us see what the risks are?

joan_mckinley · ‎Aug 30, 2021

We would like to clone our production App Portal to create a development environment. The virtual server would be clone and the databases would be backed up and restored on a different SQL Server. We realize we have to change the admin settings to point to the new DB server. Has anyone done that? Do you think it will work? Thanks! Joan

joan_mckinley · ‎Aug 10, 2021

We are also trying to import licenses via Business Adapter Studio. We have the License Object with Name, License Type, Duration, Expiry Date, Publisher ID (above we have Vendor Object for matching) Override Unit Price and Comments. It is not creating any of the licenses; it is rejecting all of the licenses although it matched on Vendor, License Type and License Duration. I have the Debug log but can't quite tell the rejection reason. Are we missing something required/obvious? I looked in the documentation for FNMS 2020R2 and it only indicates the "name" field is required. Thanks, Joan

joan_mckinley · ‎Jul 29, 2021

Thank you Markward! That was exactly the problem. This user doesn't need to do anything in the WebUI so had not launched it. Once he launched it, he was able to run the queries successfully. (Yes he is using the same account for both FNMS and SQL access). Appreciate that tip! Our DBA spent quite a bit of time diving into the backend tables and we figured out we needed to add the user's account to FNMS but it never occurred to us to have him launch the WebUI. Thanks! Joan

joan_mckinley · ‎Jul 28, 2021

We are trying to give an employee db_datareader rights to the FNMSCompliance database. He can run some queries and receive results but other queries return 0 records. The same query returns data for another user account. We made this user an admin in FNMS Accounts but he still gets 0 results. Our DBA did some investigative work on the exact tables that are not returning records. SELECT COUNT(*) FROM dbo.EntitlementProcessInfoDeferred SELECT COUNT(*) FROM dbo.EntitlementProcessInfoProcessed SELECT COUNT(*) FROM dbo.LicenseComplianceSummary SELECT COUNT(*) FROM dbo.PublisherComplianceSummary He said it seems to be related to this: LicenseComplianceSummaryAllowed Does anyone have any ideas? Thanks!

joan_mckinley · ‎Jun 09, 2021

@jdempsey yes here is a screenshot. The dialog itself is getting cut off the screen. Thanks, Joan

joan_mckinley · ‎Jun 08, 2021

We are wondering if there is a way to customize the placement of an alert in a catalog item? We have quite a bit of information in the alert and when it launches (when the user adds the catalog item to the cart), half of the box is cut off. The box can be moved, but it isn't a very good user experience. I looked in the database tables and the config files but not finding it. Thanks! Joan

joan_mckinley · ‎Mar 31, 2021

Thank you @jdempsey! We will test that out and see if it will work for our customer. Thanks, Joan

Online Status	Offline
Date Last Visited	‎Mar 23, 2023 10:35 PM

My Apps Notifications

Adding a Custom Field to the FNMS On Prem All Licenses Consumption tab

Re: App Portal Connection String For Azure

Re: Antivirus Exclusions

Antivirus Exclusions

Re: App Portal Connection String For Azure

App Portal Connection String For Azure

Re: App Portal Clone Prod to create Dev Environment

App Portal Clone Prod to create Dev Environment

Re: License import with Business Adapter Studio

Re: Unable to receive results from a few SQL Tables in FNMSCompliance Database

Unable to receive results from a few SQL Tables in FNMSCompliance Database

Re: App Portal Catalog Item Alert Box

App Portal Catalog Item Alert Box

Re: Send One Approval Notification to all Users in a DL

Re: Bulk Update Catalog Items Actions

Bulk Update Catalog Items Actions

Re: App Portal Database Schema Question

Re: App Portal Database Schema Question

App Portal Database Schema Question

FlexNet Inventory Agent Support for MacOS 13.0 Ventura

Re: My Apps Keep Selection Questions

Re: My Apps Keep Selection Questions

My Apps Keep Selection Questions

Re: Request Variable not translating in “My Apps - Alert Email Notification”