This website uses cookies. By clicking OK, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
CharlesW
Flexera
Jan 20, 2021
12:56 PM
There is no built in functionality which would allow applications from the Microsoft Store Applications for Business to be targeted in App Broker..
... View more
Jan 19, 2021
08:58 AM
There's obviously more to it than this, but the following API documentation shows the basic calls that App Broker is making to connect to the IMAP server..
http://www.mimekit.net/docs/html/P_MailKit_Net_Imap_ImapClient_Inbox.htm
Perhaps your network team is aware of some type of limitation with regards to MimeKit?
... View more
Jan 16, 2021
10:53 PM
2 Kudos
There is currently no published schema available for the App Broker database. The following is an overview of some of the most commonly referenced tables. These are often queried for reporting and troubleshooting purposes:
WD_AppSettings – Stores the majority of the settings from the Admin tab
WD_PackageRequests – used to store the data for requests which have been submitted. Likely the most referenced table.
WD_WebPackages – Used to store information about catalog items which have been created.
WD_SiteToAdvert – Used to store information about mappings between catalog items and SCCM collections/advertisements.
WD_ApprovalProcess – Used to store approvers mappings for requests which have been submitted.. In general, the WD_ApprovalXXX tables store information about approvals.. Some of these are difficult to decipher.
WD_ApproverStatus – Stores alternate approver mappings and whether or not an approver is out of office.
WD_Actions – Stores mappings of actions to catalog items and the “events” which trigger them (on submit, on fail, etc…).
WD_WebPackages – Stores web service actions which have been created.. Referenced by WD_Actions.
WD_Profile – Contains information about users and their associated user GUID from AD
WD_Localizations – Stores localized strings (including English)
WD_Notifications – Stores notification text(email)
WD_Languages – Stores languages that are currently enabled.
WD_ITSM_XXX – Stores information about ITSM actions (Remedy, ServiceNow)
WD_MailQueue- Stores information about notifications which have been sent, and which need to be sent.. Older data is purged automatically to prevent the table from growing too large.
WD_ErrorLog – Stores errors. Same information as is typically written to log files.
WD_MyAppsAlert – Stores information about alerts which have been created by MyApps.. This is a necessity for debugging many My Apps issues.
WD_Question – Stores information about questions which have been created.
WD_ResponseQuestionAuditTrail – Stores answers to questions in addition to changes to answers.
WD_RequestTarget- Stores the “target” user/device for a request.. Tied to WD_PackageRequests table.
WD_NodeSecurity – Stores Admin permissions for users accessing the site.. Generally, only referenced when there is a problem. A typical problem would consist of a “bad” GUID being stored in the table. See the ValidateSecurityGUIDs.asmx web service to help identify.
WD_CatalogSecurity – Stores catalog permissions. Sync related tables – Populated during the nightly data sync from SCCM discovery data.
WD_User - Users imported from SCCM
WD_Computer - Computers imported from SCCM
WD_UserComputerMap – mappings between users and computer imported from SCCM.
In most cases, the built in reports (those available under the Reporting tab) in App Broker will reference many of the above tables. The queries used by the built in reports are actually stored in a XML file named AdminStudio.Reports.xml.. This file can be found in the web/ReportDefinition folder under the App Broker install directory.. The queries in this file can be a handy reference for those looking to create their own custom queries and reports.
... View more
Jan 15, 2021
01:30 PM
If you add read permissions to site management, then the user will be able to manipulate the feedback, but the will not be able to enable/disable site feedback. While they would still be able to view some of the other site management settings, there is not much that they could change.. the "save" button should be locked down..
... View more
Jan 15, 2021
01:14 PM
About all I can suggest would be to restart the ESD Service after changing the credentials.. It may be that the ESD Service is holding on to the old credentials you had specified for the incoming email settings.
... View more
Jan 15, 2021
09:45 AM
Yes, you will need at least read permissions to site management in order to view the site feedback.. No way to change this behavior without modifying the code..
... View more
Jan 15, 2021
07:44 AM
Lots of variables here.. probably something you will want to open a support case for, as logs may be necessary (including the request log).. I assume that in your "back to back" requests, you were not requesting for the same device?
... View more
Jan 15, 2021
07:38 AM
Ignore the test button error.. It is trying to validate all three fields pertaining to the custom user sync... You do not need to specify all three fields.. If you want to validate your query, just run it against the Config Mgr DB. If it works there, then it should also work in App Broker. The one thing you do need to do is restart the ESD Service after making a change to the settings.
... View more
Jan 14, 2021
08:39 AM
This does not look to be documented, but if I look at the REST API for "App Portal - Submit Order", as defined in service now, I see the following listed as the endpoint:
Essentially, this is used to submit a new request/order in App Broker.. The parameters are the serviceNow request ID, machine domain, user name and machine name.
The following is the only documentation I could find on the API/request endpoint: Requests API Endpoints
... View more
Jan 14, 2021
08:11 AM
Using a customer user sync ID query similar to the following should take care of the issue.. SELECT vru.ResourceID as UserResourceID FROM v_R_User vru WHERE Unique_User_Name0 IS NOT NULL
... View more
Jan 12, 2021
08:10 AM
1 Kudo
Correct, in order to sync with ServiceNow, the catalog item must be a software catalog item, tied to an Application, Package, or Task Sequence. General catalog items do not sync.. My assumption is that App Broker requires a status in order to know when to close the Request/RITM, and a general catalog item will not provide this.. I suppose you could always work around this limitation by tying your catalog item to a dummy package, which really does nothing but return a success..
With regards to what's happening....
Software successfully installed - App Broker sets the status on the request/RITM to closed_complete (both will be closed)
Software package not available - This assumes that the package was still tied to the software catalog item, and that there was simply a problem with the package at a later time.. Ultimately, this will result in a failure in App Broker, either due to a lack of status, or a failure being returned by SCCM.. This will result in App Broker setting the status on the request to closed_incomplete (both will be closed)
No licenses available - When requested through ServiceNow, the workflow will fail at the license check, so no request/RITM will be created.. As such, no request will be created in App Broker either.
... View more
Jan 11, 2021
07:57 AM
No, I don't see a way to change/filter the results for "new items".. Rather than using a view, the query for new items is hard coded, so there would be no way to modify. No surprises here, but the following is the query being used for new items:
Select Distinct PackageTitle, CreatedOn FROM WD_WebPackages Where Deleted <> 1 and PackageVisible = 1 AND CreatedOn IS NOT NULL and datediff(day, CreatedOn, getDate()) < <DAYLIMITVALUE> AND PackageID Not IN ( Select Distinct PM.PackageID from WD_PackageMapper PM Where PM.MapperType in (2,3,4) ) ORDER BY CreatedOn DESC
... View more
Jan 06, 2021
08:03 AM
1 Kudo
FNMS is not required to integrate with ServiceNow.. It is only required if you want to check the license position when requesting software.. If you look at the workflow in ServiceNow, you will see that if the software is not licensable (the item is not tied to FNMS), then the workflow jumps immediately to Submit Order Script.. See the screen capture below, which shows the workflow.
... View more
Dec 31, 2020
11:21 AM
Variables can play an important part when defining custom commands and web service actions.. In addition, they are frequently used in notifications. When editing a notification or a command there is a variable editor which will provide some of the variables which may be available.. The App Broker documentation lists a few of the variables which can be resolved, but it is by no means a complete list. The single best source for a list of variables can be found in the web service integration.asmx. This web service has a function named GetResolvedRequestVariables. You can invoke this web service by pasting http://localhost/esd/ws/integration.asmx into a browser on the App Broker server.. You will have to enter a RequestID for a request which has been submitted previously.. Once the invoke button is selected, a list of all available variables will be displayed in the browser, for the RequestID in question.. While the variables may vary somewhat between one request an the next, the list will be fairly static..
It should be noted that these variables will generally work with any command or notification.. There are exceptions to this rule, however. Those notifications pertaining to My Apps Alerts (those starting with the name My Apps) are very limited when it comes to resolving variables. Typically, a notification pertaining to My Apps can only resolve those variables which are defined in the default notification.. They will not resolve any additional variables. Likewise, those variables which are defined in the My Apps Notifications can not be used elsewhere, or even in other My Apps notifications.
ADDITIONAL INFO:
The following screen capture shows where the variable editor is located, when editing a notification (the editor is not obvious):
The following links are also pertinent to variables in App Broker:
Variables Reference Custom Variables
... View more
Dec 31, 2020
10:40 AM
1 Kudo
Symptoms:
One or more reclamation campaigns have been created, but software is not being reclaimed by the My Apps process.
Diagnosis:
First, look at the WD_MyAppsAlert table. Are there any alerts (i.e. rows) recently created? If not, then be sure that the scheduled task named App Portal - Process Computers for My Apps Alerts exists and is running.. If the scheduled task runs, but completes very quickly, then try running the AppPortal.App.MyAppsExecutables.exe from an administrative command prompt, to see if alerts get processed. AppPortal.App.MyAppsExecutables.exe is located in the directory <InstallDir>/Utilities/MyApps. When the scheduled task is run, or AppPortal.App.MyAppsExecutables.exe is invoked directly, you should see some type of activity logged in MyApps_ProcessAlerts.log. If there is still no activity logged, make sure that you have a reclamation campaign defined, and that “Enable License Reclamation Policy” has been selected for the campaign.
If new alerts have been created recently, then look at the RequestID and packageID columns in the WD_MyAppsAlert table in the App Broker DB. Assuming that you have selected the “Automatically uninstall unused software without any user intervention” option for the Reclamation Campaign, you should see a value in both the RequestID and PackageID columns. If both of these columns are not populated, then it will typically indicate a problem.
If the PackageID column does not have a value, then it will generally be caused by the following:
The catalog item to which the reclamation campaign is tied (using the flexeraID), does not have an uninstall collection.
The catalog item does not have the “Enable Uninstallation (remove from collection)” checkbox selected.
There is more than one catalog item referencing the same FlexeraID, and one or more of the catalog items do not meet the above criteria. As a best practice, only a single catalog item should reference a given FlexeraID.
An easy way to check the first two items is to simply look at the Has Uninstall Program column for the reclamation campaign, as shown below:
If the RequestID column does not have a value, then this will generally be caused by the following:
The target device for the alert is no longer active in SCCM.. Query the view v_R_System, in the Configuration Manager database to see if the target device can be found.
The Advanced License Check is enabled for the catalog item to which the campaign is tied. The advanced license check will prevent the reclamation from being submitted, due to a known issue in App Broker. If the advanced license check can not be disabled, then contact support, as there is a hotfix available for both App Portal 2019R1 and App Portal 2020R1. The following shows the catalog item setting which enables the Advanced License Check:
NOTE: Once an alert has been created, and if there was a problem processing the alert, then the alert will not be recreated again until the threshold period for the campaign has elapsed. As such, if a problem is discovered after alerts have been created, it is recommended that the affected alerts be deleted from the WD_MyAppsAlert table, and the scheduled task invoked again to recreate the alerts.
... View more
Latest posts by CharlesW
Subject | Views | Posted |
---|---|---|
38 | Jan 20, 2021 12:56 PM | |
32 | Jan 19, 2021 08:58 AM | |
103 | Jan 16, 2021 10:53 PM | |
54 | Jan 15, 2021 01:30 PM | |
76 | Jan 15, 2021 01:14 PM | |
82 | Jan 15, 2021 09:45 AM | |
44 | Jan 15, 2021 07:44 AM | |
41 | Jan 15, 2021 07:38 AM | |
63 | Jan 14, 2021 08:39 AM | |
59 | Jan 14, 2021 08:11 AM |
Activity Feed
- Posted Re: App Portal request for Microsoft Store Applications on App Broker Forum. Jan 20, 2021 12:56 PM
- Posted Re: Incoming Email Services Configuration on App Broker Forum. Jan 19, 2021 08:58 AM
- Posted A List of Commonly Referenced App Broker Database Tables. on App Broker Knowledge Base. Jan 16, 2021 10:53 PM
- Posted Re: Site Feedback Permissions on App Broker Forum. Jan 15, 2021 01:30 PM
- Posted Re: Incoming Email Services Configuration on App Broker Forum. Jan 15, 2021 01:14 PM
- Kudoed Re: Site Feedback Permissions for kevin_philpot. Jan 15, 2021 10:18 AM
- Posted Re: Site Feedback Permissions on App Broker Forum. Jan 15, 2021 09:45 AM
- Posted Re: License Exceeded Workflow Intermittently Triggering on App Broker Forum. Jan 15, 2021 07:44 AM
- Posted Re: Custom User Sync SQL Query on App Broker Forum. Jan 15, 2021 07:38 AM
- Posted Re: API Parameters for ServiceNow on App Broker Forum. Jan 14, 2021 08:39 AM
- Posted Re: Custom User Sync SQL Query on App Broker Forum. Jan 14, 2021 08:11 AM
- Got a Kudo for Re: App Broker and ServiceNow Clarification. Jan 13, 2021 08:57 AM
- Posted Re: App Broker and ServiceNow Clarification on App Broker Forum. Jan 12, 2021 08:10 AM
- Posted Re: Show new items search on App Broker Forum. Jan 11, 2021 07:57 AM
- Got a Kudo for Re: Can we Integrate App Broker with serviceNow without using FNMS. Jan 06, 2021 09:49 AM
- Posted Re: Can we Integrate App Broker with serviceNow without using FNMS on App Broker Forum. Jan 06, 2021 08:03 AM
- Got a Kudo for Re: Multiple Workflows on a Catalog item causing no workflow to be evaluated. Jan 03, 2021 12:05 PM
- Posted What Variables are Available in App Broker? on App Broker Knowledge Base. Dec 31, 2020 11:21 AM
- Posted Common Reasons why My Apps is Not Reclaiming Software on App Broker Knowledge Base. Dec 31, 2020 10:40 AM
- Posted Re: A List of Commonly Referenced App Broker Tables. on App Broker Knowledge Base. Dec 31, 2020 10:14 AM
Contact Me
Online Status |
Offline
|
Date Last Visited |
Jan 20, 2021
04:16 PM
|
Kudos given to