Hi Team,
We are actually working on Software Reclamation Process. We are using App Broker (2020 R1) to reclaim apps using SCCM.
And, w.r.t. some BAU requirements, we have come across the below queries, where we need your kind assistance:
1. When viewing Targeted Devices in AppBroker -> MyApps record, what is the source of Assigned User field? Is this data same as what we have as "Assigned User" in FNMS?
2. What user record/email ID is used to send MyApps alert emails? Is it using the WD_User record associated with the Computer Name from FNMS, so joining WD_User through WD_UserComputerMap to send emails?
Resolution/answer on the above queries will be very much appreciated. Many thanks in advance!
Thanks & regards,
Sourav Sengupta
‎Jan 31, 2022 06:50 AM
When viewing the targeted devices, the assigned user field is coming from FNMS. As an FYI, the following is the query being run by App Broker to get the targeted devices.. Note that the AssignedUserID in the query:
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'
The My Apps notifications should be sent based on the user/computer mappings defined in WD_UserComputerMap (vUserComputerMap).
‎Jan 31, 2022 07:49 AM
When viewing the targeted devices, the assigned user field is coming from FNMS. As an FYI, the following is the query being run by App Broker to get the targeted devices.. Note that the AssignedUserID in the query:
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'
The My Apps notifications should be sent based on the user/computer mappings defined in WD_UserComputerMap (vUserComputerMap).
‎Jan 31, 2022 07:49 AM