Jun 27, 2019 10:49 AM
If I recall correctly, the View link for targeted devices will only work if you have configured FNMS database connectivity under the Flexera Integration site settings. Have you configured the Database Server and Database Name under FlexNet Manager Suite Database Connection Settings? Does your App Portal service account have read permissions to that database?
Jun 27, 2019 11:04 AM - last edited on Aug 07, 2019 03:38 PM by ppohl57
There are quite a few things going on here, but Jim is correct in that App Portal is querying the FNMS DB.. To start with, it looks like the following query is being run against the FNMS Compliance DB:
select distinct cci.ComputerName, ccu.UserName, isd.LastUsedDate, isd.DiscoveryDate, ccs.DefaultValue as Status, sti.FlexeraID
from InstalledSoftware isd
inner join ComplianceComputerInfo cci on isd.ComplianceComputerID = cci.ComplianceComputerID
left join ComplianceUser ccu on ccu.ComplianceUserID = cci.AssignedUserID
left join compliancecomputerstatus ccs on ccs.compliancecomputerstatusid = cci.compliancecomputerstatusid
inner join SoftwareTitleInfo sti on sti.SoftwareTitleID = isd.SoftwareTitleID
where sti.FlexeraID = 'arl://MGS-APP-00000111742'
Where the arl would be that which you have specified for the retire campaign.. I'd start by ensuring that this query returns values.. In addition, I'd look at the App Portal log files in the logs/MyApps folder to see if there is any activity which could explain the behavior (conditions, etc...).
Jun 28, 2019 01:11 PM
Jun 28, 2019 01:41 PM
Jun 28, 2019 02:04 PM - edited Jun 28, 2019 02:06 PM
Looks like this query ran successful. We can perform other activities with FNMS integration such as license check in\out. Just can't see the devices.
Also, I do see the devices listed under the Alerts option.
Jul 01, 2019 09:08 AM - edited Jul 01, 2019 09:46 AM
What version is being used? We're on 2019 R1 and we have many active campaigns under My Apps and the Alerts link show devices and their status, but when I click the View link for targeted devices I'm getting the same result as you do. I'm wondering if the View link is not working correctly in 2019 R1
Aug 06, 2019 02:37 PM
Have either of you filed a support case on this issue in 2019 R1? If not, could you please do that?
Oct 01, 2019 10:40 AM
Oct 02, 2019 09:56 AM
Perhaps this has been resolved now in App Portal 2019 R1 SP1?
Performance issues with My Apps - targeted devices link times out.
See the SP1 announcement here.
Dec 23, 2019 01:08 PM
Please note that the connection to the FNMS database only works with the App Portal service account credentials. The alternate credentials that you can specify in the settings are only used to connect to the FNMS web service, which doesn't come into play here. I've asked engineering in the past why we don't use those credentials when connecting to SQL as well and have been told that we can't use impersonation on the SQL connection. I'm still not sure that's true, but haven't made any headway on it yet. In any case, the only way this will work for you in the current state of the product is if you give the App Portal service account read permissions to the FNMS compliance database.
Jun 28, 2019 01:17 PM