@CharlesW In searching along the same questioning am I confusing the statement in the following forums entry regarding deploying MS Store apps? Maybe they're speaking to actually packaging them (Solved: Re: Deployment tab - Global settings - Community (flexera.com)? I'm trying to find out if there's a better way to present the MS Store apps our company has access to in App Portal. I've already tested using straight links and icons from the store placed in the description field and that works fine. Although it would be nice to be able to click the title so it linked straight to the store entry. ... View more

Also, since we're having the user syncing discussion, I found this in the documentation and was never brought up before. Is there any correlation or significance to the this statement: IMPORTANT:If you are using a custom source for user syncing, be sure to set the Syncing Users property to Not Defined. ? Does it need to be set this way if a custom user sync scenario is being used? ... View more

I guess my main concern isn't the ones that should be deleted, but once I rerun the sync to replace the licensed users in WD_User will the users be able to see their old "My Request" data after the sync? Kind regards, Jeffrey Weidle ... View more

@CharlesW Hi Charles,  Does this mean after updating my licensing collection and needing to delete the WD_User count so it's reflected correctly that I'll loose all old request data? ... View more

So based on your last comments regarding the User license query, once I update the 2 queries do I not need to "delete the old data in WD_User prior to performing another sync" as Charles recommended in a previous thread? If that's the case than I would just need to restart the ESD service so that the new values will be picked up by the sync process.  Is that correct? ... View more

Hi Charles, We're on a user based license. What I meant by licensed collection is the collection we have the custom query pointing to in SCCM to limit the numbers. That SCCM collection is querying AD so the numbers fluctuate as employees are terminated and added but they are not in App Portal (only rising, I noticed recently) I then thought about what you said that users are never purged only added. So I was wondering if that's what I'm experiencing. See below: SELECT DISTINCT givenName0 AS FirstName, sn0 AS LastName, DisplayName0 AS DisplayName, Network_Operating_System0 AS OS, physicalDeliveryOfficeNam0 AS Office, l0 AS City, vru.postalCode0 AS PostalCode, department0 AS Department, title0 AS Title, User_Name0 AS UserName, mail0 AS Email, manager0 AS Manager, vru.ResourceID AS UserResourceID, distinguished_Name0 AS ADSPath, Full_User_Name0 AS FullName, Name0 AS Name, Unique_User_Name0 AS UniqueName, Windows_NT_Domain0 AS UserDomain, company0 AS Company, ra.User_OU_Name0 AS UserOU FROM v_R_User AS vru left JOIN v_RA_User_UserOUName ra on ra.ResourceID = vru.ResourceID Right JOIN v_CM_RES_COLL_LY202C54 vcm on vcm.ResourceID = vru.ResourceID where ra.User_OU_Name0 = 'XXXXXXXX.COM/USER ACCOUNTS' Kind regards, Jeffrey Weidle End User Devices LBT 4-190 Office +1 713.309.4348 Cell +1 832.405.7516 Jeffrey.Weidle@LyondellBasell.com [cid:image003.png@01D7110D.045511D0] Information contained in this email is subject to the Disclaimer and Privacy Notice found by clicking on the following link: http://www.lyb.com/en/about-us/disclaimer ... View more

Hi Charles, I have a working Custom User Sync SQL Query as you know but I don't see my numbers matching up with my collection anymore. It seems that the "Licenses Used" number in App Portal aren't dropping to match my SCCM "licensing/limiting collection" they're only climbing. Should they drop or is it as you explained in the past when I changed the query and then needed to delete the WD_Users? Is it that the users only get added and not purged as they do in my SCCM collection with the AD query? Thanks in advance , Jeff @CharlesW  ... View more