Apr 21, 2022
10:30 AM
Based on all of this, we will go ahead and delete campaigns and make sure our queries do not rely on the LRTargets table but rather the Alerts and WebPackages table to report on reclamation uninstall data. We did one lower volume record today and behavior was as mentioned - active alerts got Expired but request history and reporting data still present. Thanks!
... View more
Apr 20, 2022
10:10 AM
Does deleting the campaign delete the record of the campaign in this table also: WD_MyAppsLRTargets ? I ask because we have some queries that bridge the alert data to the catalog items using Flexera IDs between the two tables and just trying to assess impact depending on whether we just disable the campaigns and query update Expired = 1 for the pending alerts OR just delete the campaign. 🙂 Arguably we could just bridge directly from the Alert data table to the Catalog data with FUID/Flexera ID also. Thanks!
... View more
Aug 05, 2021
10:36 AM
Hello - two things on this: 1. in the last FNMS query shared, this line throws an issue for me - I have to comment it out to get the query to work: -- 'Is file linked to application for usage' = CASE --WHEN stfe.EvidenceExistenceRuleID IN (1 /* required */, 2 /* not for recognition */, 4 /* at least one */) NULL THEN 'Yes' ELSE 'No' END, 2. When File Installation Status = Not Installed as per SCCM, we see FNMS also shows not installed for this file evidence, which we are assuming is why the metering data in SCCM is not feeding over to the Application / devices in FNMS Last Used Date data (using the installed File Evidence as link) . Any suggestion/guidance as to how to correct this? It's called out as point #2 above as possible cause if issue but I missed guidance on how to fix. We were also thinking of contacting our SCCM support team with this analysis and get their further review.
... View more
May 27, 2021
03:15 PM
I am trying to analyze usage of the scheduling functionality against Uninstall and Install requests. Are these the right flags to help me get this data: WD_PackageRequests Field: AutoDelivery = '0' -> means false, this was a Scheduled request Field: AutoDelivery = '1' -> means true, this was NOT a scheduled request; it was delivered immediately post approvals. Field: RequestType = '1' -> Uninstall request, '0' -> Install request Thanks!
... View more
May 13, 2021
11:48 AM
Actually the problem is that the alerts didn't generate for these two machines at all so there's nothing to remove. I'll try to see if we create two separate local FNMS app records, one per catalog item, to see if I get better results. Understanding that the FNMS status of an application shouldn't impact My Apps in AppBroker was really helpful, thanks!
... View more
May 12, 2021
02:44 PM
@jdempsey Thanks for the review and the response on this. I did check the Eligible for Alert - we had a collection created for a POC we were doing to have only 2 machines so I had validated that both machines did show Yes for Eligible for Alert status. However I'm noticing now that Is Active status when viewing Target Devices is showing False for these 2 machines. But the Asset status in FNMS for these machines shows Installed and the Inventory status for the machine also shows Active. Could this Is Active = False status in AppBroker be causing the issue? If so, I'm not sure why it's showing False when inventory/devices in FNMS show Installed/Active.
... View more
May 10, 2021
02:33 PM
Currently we use MyApps often for handling automated reclamation processes. I have a few further questions on leveraging the MyApps reclamation functionality in AB 2020 R1 with FNMS data. We set up the following scenario: 1. We recently set up one MyApps record but the one Flexera ID is mapped to 2 different catalog items. 2. We enabled the policy. 3. Two of the devices in the Targeted devices, one device was definitely picked up and processed during our recent job run, but it said there were 0 applications installed for the device that had reclamation campaign configured. Even though the Last Usage Date was BLANK and the discovery date was from Oct 2017. The threshold criteria on the AppBroker record is 60 days so the device met the criteria. The ideas I have that could possibly explain why this didn't work - can someone confirm: 1. Can we have 2 different catalog items in AppBroker mapped to 1 FNMS record? Will AppBroker trigger uninstall requests for both catalog items when filtering by Flexera ID as the parent? 2. The Flexera ID in FNMA is status = Unmanaged and Classification = Freeware. Does this FNMS record status affect whether AppBroker will process the application or not? Any further insight would help us on our proof-of-concept we are working on, thanks! Let me know if you need any further clarity.
... View more
Apr 28, 2021
02:30 PM
@CharlesW - Thanks for the response. We use answers from AppBroker requests and push the data to Workflow Manager (ex: Application/Software Name) to help auto create workflows. I agree - what you said got me thinking that it would be worth pulling up list of special characters that aren't allowed with Windows file explorer as it could be this is where the corruption is happening. Thanks for the below link; this is really helpful. We are reviewing ServiceNow integration with WFM directly and trying to see if we can improve this issue today to possibly implement error validation on ServiceNow form to avoid pushing to WFM and breaking folder name.
... View more
Apr 27, 2021
12:38 PM
We integrate our AppBroker 2020 R1 with Workflow Manager 2019 to auto create workflows. It was brought to my attention that many special characters seem to "break" the workflow share path when getting auto created - so if someone submits an AB request with a Brazilian character, for instance, it seems this messes up the auto creation of our sharepath and not link it properly to the workflow. The best way to fix at this time is to create a new request and remove the special character before it hits WFM, when still in AB. Is there any list of special characters Flexera has that have been reported to cause such issue? My one team member thought our previous tech support had a list from Flexera of special characters to avoid using. Any tips on this would be much appreciated!
... View more
Apr 05, 2021
10:53 AM
1 Kudo
THANK YOU! This query got me what I needed: select * from WD_ApprovalProcessTemplateMembers where QuestionID_FK is not null I completely missed the QuestionID_FK value.
... View more
Apr 05, 2021
09:10 AM
I saw this post regarding routing Approval groups within a workflow based on answers to questions. We have at least one solution like this today in our environment. Is there guidance on how to dump the data for this logic? Currently we are auditing our system and I need to see how many approval workflows use this Conditional Question logic but I am unable to find the data table that contains this. I've managed to pull other data like approval workflows, groups, conditions that route to different groups based on User AD property data, etc, but I cannot find this question condition logic. I thought a table like WD_ApprovalTemplateCondition or WD_ApprovalGroupCondition or WD_ConditionalQuestion would contain such mapping but these tables are pulling BLANK when I run a select * query. Any guidance on this would be much appreciated!
... View more
Feb 03, 2021
09:33 AM
I have a requirement to see about configuring the CC property of our License Reclamation notification emails to have the Manager of the Target user of the alert. We have some scenarios where some of our targets do not always check email, and business has asked if we can CC the manager in these scenarios. Of course the Manager is dynamic so I can't statically configure each manager on the email. I've tried to see if App Portal has a property similar to ##Manager## email address but so far no luck in sending email. I know in the WD_User table there is the Manager field but it is more the metadata associated to manager including name, unique identifier, etc. 1. Is there a list somewhere of what all possible variables App Portal can use for configuring? I know there is like ##TargetUserName##, ##OrderName##, I've also seen you can pull in Question responses into Actions (ex: to push to Workflow Manager project), and so on. What all can App Portal handle? 2. Any suggestions or similar use cases on how to meet this requirement?
... View more
Feb 03, 2021
07:37 AM
1 Kudo
Wow that was more obvious than I realized. Usually I can find the tables pretty instinctively but that one drew me a blank. Thank you!
... View more
Feb 02, 2021
10:54 AM
I'm trying to do a custom query to report out on the Search Keywords (under Title & Description tab) associated on a catalog item in App Portal. I'm searching the WD_WebPackages table and cannot find such a field. I'm struggling locating the Search Keywords value in any other data tables. Does anyone know what table the Search Keywords data is stored in App Portal so I can update my query? Thanks!
... View more
Dec 03, 2020
03:22 PM
Thanks for the quick response on this! Super helpful to know I was on the right track with understanding current functionality/gaps. I'll also take note of your suggestions and review internally.
... View more
Latest posts by elewis
Subject | Views | Posted |
---|---|---|
476 | Apr 21, 2022 10:30 AM | |
513 | Apr 20, 2022 10:10 AM | |
3269 | Aug 05, 2021 10:36 AM | |
589 | May 27, 2021 03:15 PM | |
700 | May 13, 2021 11:48 AM | |
714 | May 12, 2021 02:44 PM | |
738 | May 10, 2021 02:33 PM | |
551 | Apr 28, 2021 02:30 PM | |
568 | Apr 27, 2021 12:38 PM | |
573 | Apr 05, 2021 10:53 AM |
Activity Feed
- Posted Re: App has been removed as part of Reclamation Process but user is still getting alerts on App Broker Forum. Apr 21, 2022 10:30 AM
- Kudoed Re: App has been removed as part of Reclamation Process but user is still getting alerts for CharlesW. Apr 21, 2022 10:29 AM
- Posted Re: App has been removed as part of Reclamation Process but user is still getting alerts on App Broker Forum. Apr 20, 2022 10:10 AM
- Kudoed Re: App has been removed as part of Reclamation Process but user is still getting alerts for CharlesW. Apr 20, 2022 10:06 AM
- Kudoed Re: App has been removed as part of Reclamation Process but user is still getting alerts for jdempsey. Apr 20, 2022 10:06 AM
- Kudoed Re: App has been removed as part of Reclamation Process but user is still getting alerts for CharlesW. Apr 20, 2022 10:06 AM
- Posted Re: Understanding and troubleshooting usage metering data imported from Microsoft Endpoint Configuration Manager (SCCM) on FlexNet Manager Knowledge Base. Aug 05, 2021 10:36 AM
- Posted AppBroker/App Portal Scheduling Analysis on App Broker Forum. May 27, 2021 03:15 PM
- Kudoed Re: MyApps - Reclamation Review - Further Insight Needed for jdempsey. May 13, 2021 11:49 AM
- Posted Re: MyApps - Reclamation Review - Further Insight Needed on App Broker Forum. May 13, 2021 11:48 AM
- Posted Re: MyApps - Reclamation Review - Further Insight Needed on App Broker Forum. May 12, 2021 02:44 PM
- Posted MyApps - Reclamation Review - Further Insight Needed on App Broker Forum. May 10, 2021 02:33 PM
- Posted Re: WFM 2019 - Broken fileshare path on AdminStudio Forum. Apr 28, 2021 02:30 PM
- Posted WFM 2019 - Broken fileshare path on AdminStudio Forum. Apr 27, 2021 12:38 PM
- Got a Kudo for Re: How to pull data for Question Conditions for Approval Workflows. Apr 05, 2021 11:00 AM
- Kudoed Re: How to pull data for Question Conditions for Approval Workflows for caweber. Apr 05, 2021 10:56 AM
- Posted Re: How to pull data for Question Conditions for Approval Workflows on App Broker Forum. Apr 05, 2021 10:53 AM
- Posted How to pull data for Question Conditions for Approval Workflows on App Broker Forum. Apr 05, 2021 09:10 AM
- Posted CC'ing Target Manager on Notification Requirement on App Broker Forum. Feb 03, 2021 09:33 AM
- Got a Kudo for Re: Where are catalog Search Keywords stored in the DB?. Feb 03, 2021 07:38 AM