About CharlesW

CharlesW · ‎Sep 06, 2022

No idea if this is what you were looking for, but the following query should give you all of the workflows, and the approval groups attached to each workflow. select templatename as WorkflowName, ag.GroupName, CASE WHEN aptm.ID_FK= 0 THEN 'Dynamic Approval Group (manager)' WHEN aptm.ID_FK!= 0 THEN 'Standard Approval Group' END AS ApprovalGroupType, aptm.Position as Level from WD_ApprovalProcessTemplate apt inner join WD_ApprovalProcessTemplateMembers aptm on apt.ApprovalTemplateID = aptm.ApprovalTemplateID_FK left join wd_approvalgroup ag on ag.ApprovalID = aptm.ID_FK Manager (dynamic) approval groups do not get entered into the WD_ApprovalGroup table, so they really don't have a name, so I added an ApprovalGroupType column to indicate if it is a static approval group, or a dynamic approval group. In this case, the groupName shows up as NULL

CharlesW · ‎Aug 23, 2022

For those that are interested, it turns out that App Broker could not create new collections, as the collection name specified for the "limiting collection for device" setting (under settings->deployment->Config Mgr) no longer existed. It had been renamed at some point.

CharlesW · ‎Aug 19, 2022

Thank. I've opened a support case in your name, and have requested the ESD Web Service and App Portal log files. I think that this issue is subtle enough that I'm going to have to go through some of the logs line-by-line. We might also jump on a call if necessary, depending upon what I find.

CharlesW · ‎Aug 18, 2022

What is the exact name of the application as defined in Config Mgr? I seem to remember that there was an issue with applications containing "special" characters in their name. for instance, a single quote, etc.

CharlesW · ‎Aug 18, 2022

What about in the CreateESDObjects.log log file? Anything of apparent interest there? Also, not sure what the package ID is for this new catalog item, but can you look in the WD_siteToAdvert table to see if you have any values defined for the CollectionID and AdvertID columns, where PackageID is the package ID of your catalog item. Also, do you see anything written to the Error column in this packageID?

CharlesW · ‎Aug 18, 2022

What do you see in the CreateESDObjects.log file on the App Broker server at approximately the same time as the esdwebservice.log entry? In addition, can you see anything in DatabaseCalls_error.log at approximately the same time? Normally, the entry "created successfully" in the esdwebservice.log file would be accurate, so I'm not sure what might be going on here.

CharlesW · ‎Aug 01, 2022

Something similar to the following should give you what you need. select packageVisible, packagetitle, sta.CollectionID, CASE WHEN sta.Type = 0 THEN 'install' WHEN sta.Type =1 THEN 'uninstall' END AS operation from WD_WebPackages wp inner join WD_SiteToAdvert sta on wp.PackageID = sta.PackageID where PackageVisible = 0

CharlesW · ‎Jul 28, 2022

Jim - Correct 0=install and 1=uninstall. cobb8774 - I noticed that you mentioned the "SCCM DB". If you are truly querying the SCCM DB to get the info, then you can look at the DesiredConfigType column in v_ApplicationAssignment to determine if the request was an install or uninstall (1=install, 2=uninstall). This is for applications, anyways. I'm sure that there must be a similar location for packages.. This is just one place I found.. There are likely multiple ways to get this info in the SCCM DB. Even the collection/deployment name is indicitive of the action taken.

CharlesW · ‎Jul 28, 2022

If you would, please refrain from both opening a support case and posting to the community. It causes duplicated efforts. If you are seeing an "invalid target user" message in the logs, then it typically indicates that the target user for the request can not be found in the WD_User table. Please verify that the user account you are checking out as is in the WD_User table.

CharlesW · ‎Jul 26, 2022

I'd do a couple of things. First, for each Microsoft 365 integration, go to overview tab, and select the application details. For each integration give the Display Name a unique value to uniquely identify the tenant. For example: Second, I'd give the License Name for each Tenant a unique value to identify the tenant. By default, the license will be named "Automatically generated license agreement for managed application id:". I'd name it something to uniquely identify the tenant. For example this will ensure that you can uniquely identify the licenses when they are imported into ITAM.

CharlesW · ‎Jul 22, 2022

In most cases (if not all), the My Apps notifications will only be able to resolve those variables that are defined in the original notification. This being the case, I do not see a way that you would be able to resolve the user's email address in the My Apps - Alert Email Notification.

CharlesW · ‎Jul 21, 2022

We're looking like a couple of rookies 😀 I guess I did not realize we had an API to do this either. Seems to me that I created a custom web service to do just the same thing, at one point. In any event, I just ran a brief test, and the API worked as expected. the uniqueUserName is the person who is out of the office, the uniqueApproverName is the alternate approver, and outOfOffice would be set to true if the uniqueUser is out of the office. When the API is invoked, the changes should be seen in the table WD_ApproverStatus.

CharlesW · ‎Jul 19, 2022

Not sure how much time this will save you 😀 . There are two things you would need to do.. First, in WD_WebPackages, you would need to set the VisibleMessage column to the message you wished to display, and the VisibleShowMessage column to "1". You would do this for each of the general catalog items. For example: update wd_webpackages set visibleMessage='Please Contact Procurement', VisibleShowMessage = 1 where packageID in (1,2,3) Second, you would need to insert a row for each catalog item into the table WD_VPackageProperty. The row would be the same for each catalog item, except for the PackageID_FK column, which would reflect the package ID of the general catalog item you wanted to add a condition to. If you decide to do this, then you can simply do this for one catalog item to see the values, and then copy the row. Note that the propertyValue will be the GUID of the group that you wish to exclude. Its easiest to add a condition first, so that you can get the GUID of the group.

CharlesW · ‎Jul 18, 2022

That's funny! I was just looking for that setting on Friday.. I finally gave up, assuming that the App Broker engineering team had hidden the setting.. I ended up changing it in the DB using the following: update WD_AppSettings set value ='30' where keyname = 'roblimit'

CharlesW · ‎Jul 11, 2022

Symptoms: After entering the Intune settings in App Broker, the error is displayed upon selecting the Test button: "Failed to communicate with Intune. Please verify the configuration settings and make sure minimum permission is provided. In addition to the above error message, the intune.log file will contain an exception that states: Failed to communicate with Intune, either the configuration settings are invalid or minimum permission is missing (Application.Read.All): Response status code does not indicate success: 404 (Not Found). Diagnosis: While this error may occur for multiple reasons, the most common reason is entering the incorrect value for the Principal ID setting in App Broker. Solution: When entering the Intune configuration settings, The Tenant ID/Tenant Name and Client ID can be captured directly from the Application overview page in Azure. In the following screen capture, the properties on the App registration are displayed. The Application (client) ID and Directory (tenant) ID shown in yellow should be entered into the Intune settings directly. The Object ID that is highlighted in red is not the correct Principal (Object ID) to use. To retrieve the correct Principal ID, you must select the link under "Managed application in local directory". This is shown in green. Once the link is selected, the correct Principal ID (Object ID) is displayed, as shown below: For additional information on Configuring Intune in App Broker, see Entering Intune Settings at Initial Start Up in the Administration Guide

Online Status	Offline
Date Last Visited	‎Sep 19, 2022 12:17 PM

Re: Query to get users groups within named Approval Groups

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: SQL query to list all disabled App Portal Catalog items with the associated install and uninstal...

Re: SCCM Table details

Re: App Portal - Invalid Target user name when submitting catalog items

Re: SaaS Manager - Multiple M365 Tenants

Re: Request Variable not translating in “My Apps - Alert Email Notification”

Re: SetAlternateApproverAndOutOfOffice API

Re: Adding a visibility message and exclusion to items in bulk

Re: Order on Behalf of Limit

Unable to Successfully Register Intune with App Broker

Re: Query to get users groups within named Approval Groups

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: AppPortal - Failing to create new collections for new app's

Re: SQL query to list all disabled App Portal Catalog items with the associated install and uninstal...

Re: SCCM Table details

Re: App Portal - Invalid Target user name when submitting catalog items

Re: SaaS Manager - Multiple M365 Tenants