It is frustrating the following local query take 5 minutes to return only 5,000 records.  I have an PK index on UserResourceID. Executing CUSTOM User query select * from ( select FirstName,LastName,DisplayName,OS,Office,City, PostalCode,Department,Title,UserName,Email, Manager,UserResourceID,ADSPath,FullName, vru.Name,UniqueName,UserDomain,Company,UserOU from Custom_ConfigMan_v_r_user vru join Custom_AD_Enabled_Users ADUsers on ADUsers.SamAccountName=vru.UserName) u WHERE EXISTS (SELECT * FROM (select T.c.value('.','nvarchar(50)') as Id from @Ids.nodes('/L/I') T(c)) Ids where u.UserResourceID = Ids.id) ... View more

Thank you. Changing the option to 'Not Defined' fixed that problem but now performance of the sync is extremely slow. I have a primary key defined on UserResourceID but that does not seem to improve.   Syncing to configuration Manager took seconds and using tables local to the AppPortal database is taking about 4 minutes per 5000 record block. create table dbo.Custom_ConfigMan_v_r_user ( UserResourceID int not null    constraint Goodyear_ConfigMan_v_r_user_PK primary key, FirstName nvarchar(64), LastName nvarchar(64), --- ... View more

I have created two custom tables in AppPortal database.  One table contains enabled AD users and the other table contains data from Configuration Manager.  Modified the "Custom User Sync Connection String" to use the AppPortal SQL database.  I click on "Test User Sync Settings" and it returns success.  I save changes and click on 'Sync Data Now'.  Problem is I get an error stating the table name I used is an invalid object, although it tested find and when I past the query in a SQL Query windows, it returns data as expected.   But when I sync data, DataSync.log indicates the table I'm referencing is an invalid object. Exception occurred while getting the User IDs for sync Invalid object name 'Custom_ConfigMan_v_r_user'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() ... View more

The idea of a staging table sounds useful but would that staging table have to reside on the SCCM database or could we join to a new staging table on our AppPortal database server using the custom query.   Our SCCM team is not too excited about creating a custom table on their side.    We are also investigating running a purge routine in SCCM to get rid of disabled employees so they don't come across in our sync and would not be rediscovered. Is there a naming convention to follow for creating tables on the AppPortal database so as not to conflict with future updates from Flexera? ... View more

Thank you John. This is very interesting.   I am guessing I would would first need to determine what minimal bandwidth would be required successfully allow agent self-updates to download without causing the update to stop and have to restart from the beginning.  Is the agent able to resume an interrupted download or would it need to download the entire package again since starting over would make self-updating take forever? ... View more

To clarify my question. If we previously targeted a selection of devices for agent upgrade using "Upgrade selected platforms in the selected targets", then selected "Upgrade selected platforms" to get all devices.  Would the warning indicate that devices previously targeted will never auto upgrade? The section of the warning that is concerning me is: "and ignores the platform for all future automatic upgrades" ... View more

The query does work when running as the Service Account.  Is there a reason it does not return values if not using the Service Account? By the way. That view is an impressive SQL statement. ... View more

No rows returned.  I find that all the grid_% views don't have data. select count(*) from Grid_VmWareInstallations 0 ... View more