- Flexera Community
- App Broker
- App Broker Forum
- Re: Compliance Management
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
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?
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...).
select * from vUserComputerMap where MachineName like '<machineName>'
At this point, I'm speculating that there is no relationships defined for the devices returned by the FNMS query. Note that this second query should be run against the App Portal DB.
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.
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
Yep 2019 R1 as well here.
Have either of you filed a support case on this issue in 2019 R1? If not, could you please do that?
I do have a case currently open for this.
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.
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.