About NicOla

NicOla · ‎Jun 15, 2022

Hello, Is it possible to change a catalog type from General to Application. We have some General Applications that run custom actions and have their Questionnaires and Approval workflows set up. We now have SCCM assignments for some of these catalog Items and would like for a user to be added to the SCCM collections on Approval. I tried just adding a SCCM deployment (it looked like it added it correctly), but the type is still General. I’d prefer not to have to archive these Catalog items just to reimport them in again as Application types. Thanks.

NicOla · ‎Apr 30, 2022

I want to be able to display catalog item request questionnaire answers in the email that gets sent to approvers for General catalog items (General - Request For Approval) I’m using the ##Questions## variable. I would like for all the text that is presented in the email to be the same size, currently the values in the email that are inserted using ##Questions## seem random and the email looks unsightly. Is there a way to control this? Do I need to edit the questions then selves or ideally is there a way to do this in the ‘General - Request For Approval’ template? The questions we have are a mostly a mix of Rich Text box, drop down and check box questions. Thank You.

NicOla · ‎Feb 24, 2022

Thanks, I suspected that direct SQL Updates would be the only way to manage this. We should be able to build it into our automation.

NicOla · ‎Feb 23, 2022

We need to import 700+ General Catalog Items into our 2019R1 App Portal.We have 1400+ Application Items in currently. We would like the email notification (for example ‘Software/General Catalog Item Request Order’) to be different for General Items than what it is for Application items. Is there any way to do this, without having to manually modify each of the 700 notifications for the General Catalog items?

NicOla · ‎Jan 03, 2022

Thanks Jim, I will try to use those API's by calling them from a powershell script. I see the identifier for the APIs are the Catalog Item Title. If I have archived Catalog items with the same Title - will that cause any issues? Will the active Catalog items update correctly? Cheers.

NicOla · ‎Dec 02, 2021

We have been hard at work collection descriptions and key search words for our 1500 App Portal Catalog items. I’m trying to get the SQL updates together so I can run against the DB. Update Description is easy: Update WD_WebPackages Set PackageDesc = 'This is an app description' WHERE PackageID_FK = 1234 My question is how to run updates for the key words. Do we only need to update the WD_WebPackageKeyword table? Is the update something like this Update WD_WebPackageKeyword Set Keyword = ‘keyword1 keyword2’ WHERE PackageID_FK = 1234 What if we have more than one key word per catalog item? What if that catalog item already has a key work in it (and we want to add more)? I can run the queries past our DBA team also, but thought I should ask here in case there are other tables we need to consider when updating WD_WebPackageKeyword. Thanks.

NicOla · ‎Nov 23, 2021

Completing the following steps resolved the issues we were seeing. 1 – Updating the request processing batch size, by running the following SQL update: update wd_appsettings set value = '600' where keyname ='RequestProcessingBatchSize' We restarted the ESD Service after this. 2 - Deleted failed inserts We also had a number of failed inserts that were preventing valid requests from inserting correctly. We ran a query to delete these, it looked like this UPDATE WD_PackageRequests SET IsLeased = 0, LeaseExpire = NULL, Deleted = 1, Inserted = 0, InsertDate = NULL, monitor = 0 WHERE requestID in( <--insert comma seperated request numbers here-->)

NicOla · ‎Nov 10, 2021

Thanks Jim, I already did that, but no joy. Charlie is helping us via a support case now. It is a strange one for sure. When we get a solution I'll post back up here.

NicOla · ‎Nov 09, 2021

It looks like about 4 catalog items are having the issue. The rest of the 1200+ catalog items are processing correctly. I've also raised a case and Charles took a look at the logs and said he could see it looked like there were insert issues all right. I have archived some of the affected catalog items and recreated them from scratch - but will experience the same issue with them. What is confusing is that we can manually add users to the SCCM Collections, and that the catalog items had been working fine before. I can't think of anything that changed.

NicOla · ‎Nov 09, 2021

We can manually add users to the SCCM collections, it just does not seem to work using App Broker.

NicOla · ‎Nov 09, 2021

Over the last week we have noticed that there have been (App Portal 2019 R1) Requests raised and processed as successful but the users have not been added to the SCCM collections (we have user based deployments). The issue seems to be with a small number of catalog items. Users raise a request, everything looks to be fine (even the request log files look ok) but then the user does not get the install and when investigated – the users has not been added to the SCCM Collection. The rest of our 1200+ catalog items seem fine. The affected catalog items were all created at different times over the last two years. Some of the affected Catalog items require approval – and other do not. Previous requests to these catalog items did process correctly – and users were added correctly. Users who request an affected catalog item will find that they don’t get added to the SCCM collection but the same users can then go on to request a working catalog item successfully. Any advice on how to troubleshoot this issue would be greatly appreciated, Thanks.

NicOla · ‎Oct 13, 2021

Thanks Charles for clarifying.

NicOla · ‎Oct 13, 2021

Thanks for letting me know. I'll read that 🙂

NicOla · ‎Oct 07, 2021

We have an Dev App Portal in a separate test environment – integrating with test AD and test SCCM. Our Prod App Portal is integrated with our prod AD and Prod SCCM. I’d like to build a UAT App Portal, I’m wondering if it was possible to set up a UAT App Portal (with it’s own DB) – but have it also integrated to prod AD and Prod SCCM. Can this work?

NicOla · ‎Oct 07, 2021

I’m interested in using the approveRequest API. If I have a Catalog item which has an approval workflow with two or more levels of approvers, can I use this API to approve just one level? If I approve a request with this API – does it approve for all approvers? Thanks

Online Status	Offline
Date Last Visited	‎Feb 07, 2023 10:33 AM

Changing a Catalog Item Type

##Questions##

Re: Different Notification Templates for different Catalog Item Types

Different Notification Templates for different Catalog Item Types

Re: Updating WD_WebPackageKeyword

Updating WD_WebPackageKeyword

Re: users not being added to SCCM Collections

Re: users not being added to SCCM Collections

Re: users not being added to SCCM Collections

Re: users not being added to SCCM Collections

users not being added to SCCM Collections

Re: approveRequest API

Re: UAT App Portal

UAT App Portal

approveRequest API

Re: Multiple approval workflows on checkout

Re: Multiple approval workflows on checkout

Multiple approval workflows on checkout

Re: Query to get users groups within named Approval Groups

Re: Query to get users groups within named Approval Groups

Query to get users groups within named Approval Groups

Re: SetAlternateApproverAndOutOfOffice API

Re: SetAlternateApproverAndOutOfOffice API

SetAlternateApproverAndOutOfOffice API

Re: Order on Behalf of Limit