Do you see any hints in the logs?  Is there any log activity showing at least an attempt to sync catalog items to ServiceNow?  Some things to check would be verifying that the integration account has the correct roles in ServiceNow, checking that sync has been enabled within App Broker (on the ServiceNow Integration page within the App Broker admin UI), and checking that individual catalog items have been marked for sync to ServiceNow (you can do this on the properties dialog for individual catalog items, or there is a button on the ServiceNow Integration page within the App Broker admin UI that allows you to enable all catalog items for sync into ServiceNow).  Also, keep in mind that General catalog items do not sync into ServiceNow.  Only Software catalog items will be synced to ServiceNow, so if you only have General catalog items, that would explain it. ... View more

I guess I should add that if there isn't already an Idea posted for this, I would encourage you to submit one (if it's important to you).  It's certainly possible that Flexera could offer the workflow in both formats for those customers that are already using Flow Designer for other things. ... View more

And here is the Jamf documentation that states a package must be indexed in order to be uninstalled. ... View more

When you use a custom sync query that doesn't go directly against your SCCM database, you need to change the sync type. Change "Syncing Users" to "Not Defined".  If you have it configured for "ConfigMgr", it will try to build the connection string from the server/database settings on the ConfigMgr tab instead of using the connection string you provide with the custom query. ... View more

I have multiple customers on App Portal 2022 R1 SP1 that are connecting to Flexera One ITAM or FNMS 2022 R2, and Flexera Engineering doesn't generally make changes to the API interface used by App Broker.  So, that's why I'd be surprised if there is anything in the Flexera documentation that says these versions are incompatible.  Please note that absence of an explicit statement about specific versions does not imply incompatibility.  It generally just means that the documentation will be updated at the next release cycle or that nothing has changed that would cause issues with the previous compatibility. ... View more

Can you please provide a link to the page that says these versions are incompatible?  As far as I'm aware, there should be no compatibility issues between these versions.  If you can point me to where that's stated, I can put in a request to have that information validated/updated. ... View more

Are you able to configure your ITSM actions at the global level (i.e. applying to all catalog items)?  Or do you need to apply them selectively to specific catalog items? To get rid of the existing Remedy actions, I believe you could use something like this... $SCRIPT:logfile = "C:\Path\To\Logfile.log" $SCRIPT:ConnectionStringAppPortal = "EnterYourAppPortalConnectionStringHere" ########################################################################## # Log ########################################################################## function Log([object]$logobj) { ForEach ($obj in $logobj) { (Get-Date -Format G) + ' ' + $obj.ToString() | Out-File -FilePath $SCRIPT:logfile -Append # Write-Host (Get-Date -Format G) $obj.ToString() } } ########################################################################## # ExecuteSimpleSQLQuery1 ########################################################################## function ExecuteSimpleSQLQuery1($szConnect, $szQuery, $szParam1) { $szResult = "" $result = 0 $con = New-Object System.Data.SqlClient.SqlConnection Try { $con.ConnectionString = $szConnect $con.Open() $command = $con.CreateCommand() $command.CommandText = $szQuery $res = $command.Parameters.AddWithValue('@Param1', $szParam1) $result = $command.ExecuteScalar() } Catch [System.Exception] { Log ('EXCEPTION: ' + $_.Exception) $Error.Clear() } Finally { $con.Close() } if ($result -ne $null) { $szResult = $result.ToString() } return $szResult } ########################################################################## # ExecuteSimpleNonSQLQuery1 ########################################################################## function ExecuteSimpleNonSQLQuery1($szConnect, $szQuery, $szParam1) { $result = 0 $con = New-Object System.Data.SqlClient.SqlConnection Try { $con.ConnectionString = $szConnect $con.Open() $command = $con.CreateCommand() $command.CommandText = $szQuery $res = $command.Parameters.AddWithValue('@Param1', $szParam1) $result = $command.ExecuteNonQuery() } Catch [System.Exception] { Log ('EXCEPTION: ' + $_.Exception) $Error.Clear() } Finally { $con.Close() } return $result } ########################################################################## # RemoveAllItsmActions ########################################################################## function RemoveAllItsmActions($APPackageID) { # Check to see if there are actions configured for the specified catalog item $Query = 'SELECT [ID] from [WD_ITSM_Actions] WHERE [PackageID] = @Param1' [int] $ExistingAction = ExecuteSimpleSQLQuery1 $SCRIPT:ConnectionStringAppPortal $Query $APPackageID if ($ExistingAction -eq 0) { return } Log ("Removing all ITSM actions") # Update the database to remove all actions from the specified catalog item $Query = 'DELETE FROM [WD_ITSM_Actions] WHERE [PackageID] = @Param1' $Rows = ExecuteSimpleNonSQLQuery1 $SCRIPT:ConnectionStringAppPortal $Query $APPackageID Log (' Deleted ' + $Rows.ToString() + ' row(s) from WD_ITSM_Actions') if ($Rows -gt 0) { Log (" Successfully removed all ITSM actions.") } else { Log (" Failed to remove all ITSM actions") } } Then to add your ServiceNow actions, add them in the global actions configuration (if possible).  If that isn't possible and you need to add them to individual catalog items, then you could probably modify this code to suit your needs (this is written for command line actions like PowerShell scripts rather than ITSM actions, so it won't work as-is for your purposes). ########################################################################## # ExecuteSimpleSQLQuery3 ########################################################################## function ExecuteSimpleSQLQuery3($szConnect, $szQuery, $szParam1, $szParam2, $szParam3) { $szResult = "" $result = 0 $con = New-Object System.Data.SqlClient.SqlConnection Try { $con.ConnectionString = $szConnect $con.Open() $command = $con.CreateCommand() $command.CommandText = $szQuery $res = $command.Parameters.AddWithValue('@Param1', $szParam1) $res = $command.Parameters.AddWithValue('@Param2', $szParam2) $res = $command.Parameters.AddWithValue('@Param3', $szParam3) $result = $command.ExecuteScalar() } Catch [System.Exception] { Log ('EXCEPTION: ' + $_.Exception) $Error.Clear() } Finally { $con.Close() } if ($result -ne $null) { $szResult = $result.ToString() } return $szResult } ########################################################################## # ExecuteSimpleNonSQLQuery3 ########################################################################## function ExecuteSimpleNonSQLQuery3($szConnect, $szQuery, $szParam1, $szParam2, $szParam3) { $result = 0 $con = New-Object System.Data.SqlClient.SqlConnection Try { $con.ConnectionString = $szConnect $con.Open() $command = $con.CreateCommand() $command.CommandText = $szQuery $res = $command.Parameters.AddWithValue('@Param1', $szParam1) $res = $command.Parameters.AddWithValue('@Param2', $szParam2) $res = $command.Parameters.AddWithValue('@Param3', $szParam3) $result = $command.ExecuteNonQuery() } Catch [System.Exception] { Log ('EXCEPTION: ' + $_.Exception) $Error.Clear() } Finally { $con.Close() } return $result } ########################################################################## # AddScriptCommandToEvent - This function is not currently being used ########################################################################## function AddScriptCommandToEvent($APPackageID, $ActionName, $EventName) { Log ("Adding Script Command '" + $ActionName + "' to event '" + $EventName + "'.") # Map EventName to EventID switch ($EventName) { "On Submit" {$EventID = 0} "On Submit No Approval" {$EventID = 12} "On Submit Approval" {$EventID = 13} "On Approver Approval" {$EventID = 1} "On Request Approval" {$EventID = 2} "On Request Rejected" {$EventID = 8} "On Submit For Install" {$EventID = 3} "On Submit For Uninstall" {$EventID = 4} "On Success Install" {$EventID = 5} "On Fail Install" {$EventID = 6} "On Success Uninstall" {$EventID = 10} "On Fail Uninstall" {$EventID = 11} "By URL" {$EventID = 7} "On Cancel" {$EventID = 9} "On Check Status" {$EventID = 99} Default {Log ("ERROR: Invalid event name '" + $EventName + "' specified."); return} } Log (" EventID = " + $EventID.ToString()) # Look up the ActionID associated with the specified ActionName $Query = 'SELECT [ExtensionID] from [WD_ClientCommands] WHERE [ExtensionName] = @Param1' [int] $ActionID = ExecuteSimpleSQLQuery1 $ConnectionStringAppPortal $Query $ActionName if ($ActionID -eq 0) { Log (" Failed to add Script Command '" + $ActionName + "' to event '" + $EventName + "'. No such Script Command found.") return } Log (" ActionID = " + $ActionID.ToString()) # Check to see if there is already an action configured for the specified ActionID, EventID, and PackageID $Query3 = 'SELECT [ID] from [WD_Actions] WHERE [EventID] = @Param1 AND [ActionID] = @Param2 AND [PackageID] = @Param3' [int] $ExistingAction = ExecuteSimpleSQLQuery3 $ConnectionStringAppPortal $Query3 $EventID $ActionID $APPackageID if ($ExistingAction -gt 0) { Log (" Script Command '" + $ActionName + "' is already connected to event '" + $EventName + "' for Package ID " + $APPackageID + ".") return } # Update the database to add the specified action to the specified event for the specified catalog item $Query3 = 'INSERT INTO [WD_Actions] ([ActionClass], [EventID], [ActionID], [PackageID], [OrderIndex], [StatusID], [WorkflowName]) VALUES (1, @Param1, @Param2, @Param3, 0, 0, NULL)' $Rows = ExecuteSimpleNonSQLQuery3 $ConnectionStringAppPortal $Query3 $EventID $ActionID $APPackageID Log (' Inserted ' + $Rows.ToString() + ' row(s) into WD_Actions') if ($Rows -gt 0) { Log (" Successfully added Script Command '" + $ActionName + "' to event '" + $EventName + "'.") } else { Log (" Failed to add Script Command '" + $ActionName + "' to event '" + $EventName + "'.") } }   ... View more

What I have done in several cases is to create a custom table in the App Broker database and then run my custom sync queries against that custom table.  If I'm using SCCM or Jamf or some other DB source to combine with other custom data/logic, I usually set up an external sync process to sync those sources into App Broker as well.  For example, I might have a PowerShell script (or SQL job) that syncs v_R_User to a table in the App Broker database called Custom_v_R_User or SCCM_v_R_User or something like that, and then I'll have another table with my data to be joined (e.g. Custom_ActiveUserData).  Then my custom sync query can run a JOIN against those tables (or I guess you could "pre-join" everything into one table and custom query against that).  As for naming of tables, it doesn't really matter, though I would avoid using WD_xxxxx.  I normally either use Custom_ as a prefix or <InsertCustomerNameHere>_ as a prefix for the table names. ... View more

I vaguely recall doing something like that for a customer a few years back.  When I get a chance later, I'll take a look and see if I can find it. ... View more