Oct 10, 2022
12:13 PM
Also, if you have scripts (e.g. PowerShell) that are accessing the ITAM SOAP APIs outside of App Portal/App Broker, please let me know that as well.
... View more
Oct 10, 2022
12:12 PM
3 Kudos
Hello, App Broker community!
I'm trying to determine who is using App Portal/App Broker on-premises and connecting to Flexera One ITAM (formerly FNMS Cloud) for license checks/reservations/reclamation/other. If you are a customer using this integration (or a partner with one or more customers using this integration), please reply here with the version of App Portal/App Broker currently in use and whether or not you are using the new IAM-based authentication referenced here. If you're not sure, feel free to post here and tag me so I can follow up and help you figure that out.
The current plan is to retire the old AGW at the end of this year, so if there are customers who are still using the AGW to access the Flexera One ITAM SOAP APIs, I want to understand how we can help them migrate off of it before it is retired.
Thanks in advance!
... View more
Sep 30, 2022
01:54 PM
1 Kudo
@tertiusd @Ralph_Crowley - not being in Product Management, I can't comment officially, and @Shiremath (while in Product Management) doesn't own the FSG or AGW. Unofficially, I have been following an internal conversation on this topic, and what I can share is that this is a work-in-progress discussion internally and we don't have answers right now. As I learn more, I'll update here.
... View more
Sep 06, 2022
03:24 PM
3 Kudos
If you're asking what AD Security Groups are included as members within each Approval Group in App Portal, you're probably out of luck with just a SQL query. The Approval Group memberships are stored in SQL as AD GUIDs within the WD_ApprovalGroupMember table. You could query the list of GUIDs using something like this...
SELECT ag.[GroupName]
,agm.[Position]
,agm.[Approver]
FROM [AppPortal].[dbo].[WD_ApprovalGroup] ag
JOIN [WD_ApprovalGroupMember] agm ON ag.[ApprovalID] = agm.[ApprovalID_FK]
GROUP BY ag.[GroupName], agm.[Position], agm.[Approver]
ORDER BY ag.[GroupName], agm.[Position]
But then you'd need some code (e.g. PowerShell) to look up the GUIDs in AD and return a meaningful display name for the group/user.
... View more
Aug 01, 2022
09:58 AM
1 Kudo
Yes, PackageVisible = 0 corresponds with Enabled = False in the UI. However, the UI will only show you non-archived catalog items. That's why I suggested including the Deleted = 0 condition in your WHERE clause, which will filter out the archived catalog items.
... View more
Aug 01, 2022
09:24 AM
1 Kudo
I just saw Charlie's reply, and it looks like we had similar answers, so just a couple notes:
I like Charlie's CASE statement for showing 'install' vs. 'uninstall' (or you could just show 0/1 if you know what those mean
He used INNER JOIN while I used LEFT JOIN. An INNER JOIN will only show you disabled catalog items that have a deployment attached. LEFT JOIN will show you all disabled catalog items, including ones without a deployment (e.g. General Catalog Items or Software Catalog Items where the deployments have been deleted). For catalog items without a deployment, the CollectionID column would simply be displayed as NULL. So, this is a matter of preference as to what you want to see in the results.
The Deleted column in WD_WebPackages tells you if a catalog item has been archived. If you want to see all catalog items (archived or not), then exclude that condition. If you only want to see disabled catalog items that are "active", then include the Deleted = 0.
... View more
Aug 01, 2022
09:16 AM
I don't currently have a site with an SCCM connection, so I may not be able to provide an exact query, but I don't believe we store collection names in our database. The WD_WebPackages table has most of the catalog item information, so you can look at
SELECT PackageID, PackageTitle
FROM WD_WebPackages
WHERE PackageVisible = 0 AND Deleted = 0
Note: Deleted=0 only grabs non-archived catalog items.
If you want collection IDs (not names), you could get those from the WD_SiteToAdvert table using something like this
SELECT wp.PackageID, wp.PackageTitle, sta.CollectionID
FROM WD_WebPackages wp LEFT JOIN
WD_SiteToAdvert sta ON wp.PackageID = sta.PackageID
WHERE wp.PackageVisible = 0 AND wp.Deleted = 0
Edit: Corrected the column name from "Visible" to "PackageVisible".
... View more
Jul 28, 2022
07:40 PM
It is possible, but not necessarily easy. The DataSync process can read from any SQL data source. So, if you have an existing SQL data source that includes all of the information App Broker normally gets from SCCM, you can use the custom sync queries to connect to that custom data source. If you don't have an existing data source, you could write some scripts (e.g. PowerShell) to query Active Directory and write the necessary data to a custom table (either in your App Broker database or a separate database on an accessible SQL server). Then you can configure the custom sync queries to point to that custom table.
... View more
Jul 28, 2022
10:58 AM
You should find most (if not all) of what you're looking for in the [vMyRequestsCatalogUpdated] view. Install versus Uninstall should be either the Type column or the RequestType column. I don't recall which one (the latter, I think), and since the environment I'm looking at right now doesn't have any install/uninstall data, I can't tell you how 0/1 maps to install/uninstall. But off the top of my head, I think 0 maps to Install and 1 maps to Uninstall. @CharlesW keep me honest.
... View more
Jul 28, 2022
10:49 AM
You can also check this in the Admin UI under Site Management > Imported Users and Computers > Users. If the user isn't present, then you'll need to check your data sync settings under Site Management > Settings > Deployment > Common. If the settings look correct, check your DataSync.log, DataSyncExceptions.log, and DatabaseCalls_Error.log files to see if there are any errors syncing user data. If you don't see any errors, check your original data sources (SCCM/Active Directory).
... View more
Jul 27, 2022
11:11 AM
I can't speak for what Charlie tested, but yes, any time you see a reference to "Unique...Name", this is referring to the DOMAIN\UserName format that you would find in the UniqueName column of WD_User.
... View more
Jul 22, 2022
09:50 AM
Here's some additional context:
Visitor variables are only available during the shopping/checkout process and represent the currently logged in user for that browser session.
##Visitor_sAMAccountName## ##Visitor_givenName##
Requester and Target variables are related to a request that has been submitted in App Portal. In the context of My Apps, alerts are tied to an application (by Flexera ID) and a device (by inventory device name). These alerts may be associated with applications that were never requested through App Portal and are targeting devices, not users, so there is no Requester or Target in the My Apps context.
##Requester_UserName## ##Requester_Email## ##Requester_FirstName## ##Requester_PrimaryUser## ##Requester_UniqueName## ##TargetUserName##
One could argue that the following variables should be resolvable as part of My Apps email notifications, based on the user to whom the email is being sent (just a simple lookup on the WD_User table). It's just a matter of adding the code that resolves the variables in this area of the code. I would suggest submitting an Idea on our Ideas portal, describing the use case (not the technical solution). Then Product Management/Engineering can do some brainstorming to figure out the best option for providing the needed functionality (e.g. maybe they add some new ##MyApps_...## variables or maybe they just use existing variables - hopefully this would include custom catalog variables, though this could be problematic in the scenario of SmartUninstall where there is no catalog item associated with the alert).
##UserName## ##Username## ##Email## ##FullName## ##FirstName## ##UniqueName## ##UniqueUserName## ##Username##
... View more
Jul 21, 2022
09:57 AM
1 Kudo
I didn't even know this API existed or that there was documentation on it. 😀 It looks pretty straight-forward and should work as documented. But I will call out that the alternate approver feature (not specific to the API) does not allow groups or multiple individuals, and there is no recursive behavior. So, if you set an alternate approver that is also out of office, the approvals will not be routed to that alternate's alternate.
... View more
Jul 20, 2022
12:12 PM
2 Kudos
I've suggested to product management that they consider moving these settings to Site Management > Settings > Web Site > Catalog Behavior, which seems like a more logical place for them.
... View more
Jul 20, 2022
11:51 AM
1 Kudo
This has been raised with Product Management and added to their backlog for investigation. There is currently no detailed plan for updating the web extensions, but it will be looked at.
... View more
Latest posts by jdempsey
Subject | Views | Posted |
---|---|---|
30 | Mar 30, 2023 10:45 AM | |
34 | Mar 30, 2023 10:39 AM | |
39 | Mar 30, 2023 10:31 AM | |
93 | Mar 25, 2023 10:11 PM | |
238 | Mar 21, 2023 11:18 AM | |
285 | Mar 17, 2023 01:28 PM | |
295 | Mar 17, 2023 12:23 PM | |
491 | Mar 14, 2023 03:42 PM | |
504 | Mar 14, 2023 02:35 PM | |
528 | Mar 14, 2023 01:39 PM |
Activity Feed
- Posted Re: App Broker Integration with Servicenow on App Broker Forum. Mar 30, 2023 10:45 AM
- Posted Re: Is there a plan on migrating all AppPortal workflows used in ServiceNow from Workflow to the new Flow Designer? on App Broker Forum. Mar 30, 2023 10:39 AM
- Posted Re: Is there a plan on migrating all AppPortal workflows used in ServiceNow from Workflow to the new Flow Designer? on App Broker Forum. Mar 30, 2023 10:31 AM
- Got a Kudo for Re: JAMF policy for APP Portal to create catalog item uninstall policy. Mar 28, 2023 10:31 AM
- Got a Kudo for Re: JAMF policy for APP Portal to create catalog item uninstall policy. Mar 26, 2023 02:03 PM
- Posted Re: JAMF policy for APP Portal to create catalog item uninstall policy on App Broker Forum. Mar 25, 2023 10:11 PM
- Kudoed Re: Bash script to call App Portal APIs for CharlesW. Mar 24, 2023 02:06 PM
- Kudoed Re: App Broker/Portal Release Schedule for CharlesW. Mar 21, 2023 01:12 PM
- Posted Re: App Portal / FNMS Version Compatibility on App Broker Forum. Mar 21, 2023 11:18 AM
- Posted Re: User Custom query to limit AppPortal import from SCCM to only include AD users with Enabled=True on App Broker Forum. Mar 17, 2023 01:28 PM
- Posted Re: User Custom query to limit AppPortal import from SCCM to only include AD users with Enabled=True on App Broker Forum. Mar 17, 2023 12:23 PM
- Got a Kudo for Re: User Custom query to limit AppPortal import from SCCM to only include AD users with Enabled=True. Mar 15, 2023 11:34 AM
- Got a Kudo for Re: App Portal / FNMS Version Compatibility. Mar 14, 2023 06:31 PM
- Posted Re: App Portal / FNMS Version Compatibility on App Broker Forum. Mar 14, 2023 03:42 PM
- Kudoed Re: App Portal / FNMS Version Compatibility for ext-smmason. Mar 14, 2023 03:42 PM
- Posted Re: App Portal / FNMS Version Compatibility on App Broker Forum. Mar 14, 2023 02:35 PM
- Kudoed Re: "Your system is not licensed to use this application." for Big_Kev. Mar 14, 2023 02:15 PM
- Kudoed Re: "Your system is not licensed to use this application." for CharlesW. Mar 14, 2023 02:14 PM
- Posted Re: App Portal / FNMS Version Compatibility on App Broker Forum. Mar 14, 2023 01:39 PM
- Got a Kudo for Re: Bulk Update Catalog Items Actions. Mar 14, 2023 06:49 AM