Common Tab
On the Common tab of the Deployment view, you need to select the deployment technology that App Portal should use to perform user syncing, computer syncing, evaluating collection membership, and other tasks.
You can connect App Portal to multiple deployment technologies: Microsoft Intune, System Center 2012 Configuration Manager, Symantec Altiris, Workspace ONE UEM (mobile applications), Jamf Pro (Macintosh desktop applications), and Jamf Cloud. You can also specify a custom connection string to another third-party deployment technology. You are permitted to set up App Portal to perform some tasks with one deployment technology and other tasks with a different deployment technology.
The Common subtab includes the following properties:
| Property | Description |
|---|---|
| Define order for detecting client deployment technology | If you have entered connection settings for more than one deployment technology, specify the order in which App Portal will check them to determine which deployment technology the end user’s computer is a client of. |
| Syncing Users | Select the deployment technology that App Portal should use to sync users using built-in sync queries: Not Defined ConfigMgr SCCM 2012 Intune Altiris If you are going to specify a custom user sync connection string in the Custom User Sync Settings area below, set this field to Not Defined . |
| Syncing Computers | Select the deployment technology that App Portal should use to sync computers using built-in sync queries: Not Defined ConfigMgr SCCM 2012 Intune Altiris If you are going to specify a custom computer sync connection string in the Custom Computer Sync Settings and Custom User Computer Map Sync Settings areas below, set this field to Not Defined . |
| Evaluating collection membership | Select the deployment technology that App Portal should use to evaluate collection membership for standard conditions: Not Defined ConfigMgr SCCM 2012 Altiris |
| Inventory / OS Deployment | Select the deployment technology that you want App Portal to use to perform OS deployments and to read inventory data: Not Defined ConfigMgr SCCM 2012 Not supported for Altiris unless also using FlexNet Manager Suite. |
| Sync Page Size | Specify the batch size that App Portal should use to process users and computers. The default value is 100. |
| Sync Command Timeout (in seconds) | Specify the timeout value in seconds for the Sync Data command. The default value is 300. |
| Sync Data Now | Click to sync App Portal using the current selections. Until you sync user and computer data with the selected deployment technology, App Portal will not recognize the logged in user. The sync also happens at 2:00 a.m. each morning. To configure the time, open the Site Management > Settings > Timers tab and edit the Time of day to sync users and computers field. |
| Custom User Sync Settings | If you want App Portal to use custom user sync queries, enter those queries in the following text boxes: Custom User ID Sync SQL Query —Query to obtain user IDs so that App Portal can process them in batch. See example in Custom User ID Sync SQL Query. Custom User Sync SQL Query —Query to obtain all user columns. Some of the columns and their names are mandatory, as described in the provided query sample. See example in Custom User Sync SQL Query. Custom User Sync Connection String —If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Users . See example in Custom User Sync Connection String. If you are using a custom source for user syncing, be sure to set the Syncing Users property to Not Defined . |
| Custom Computer Sync Settings | If you want to use custom computer sync queries, enter those queries in the following text boxes: Custom Computer ID Sync SQL Query —Query to obtain computer IDs so that App Portal can process them in batch. See example in Custom Computer ID Sync SQL Query. Custom Computer Sync SQL Query —Query to obtain all computer columns. Some of the columns and their names are mandatory, as described in the provided query sample. See example in Custom Computer Sync SQL Query. Custom Computer Sync Connection String —If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Users . See example in Custom Computer Sync SQL Query. If you are using a custom source for computer syncing, be sure to set the Syncing Computers property to Not Defined . |
| Custom User Computer Map Sync Settings | If you want to use custom user computer map sync settings, enter those queries in the following text boxes: Custom User Computer Map ID Sync SQL Query —Query to obtain user IDs and computer IDs so that App Portal can process them in batch. See example in Custom User Computer Map ID Sync SQL Query. Custom User Computer Map Sync SQL Query —Query to obtain all user and computer columns. Some of the columns and their names are mandatory, as described in the provided query sample. See example in Custom User Computer Map Sync SQL Query. Custom User Computer Map Sync Connection String —If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Users . See example in Custom User Computer Map Sync Connection String. |
Custom User Sync Settings
This section provides examples of code that could be used in the Custom User Sync Settings area of the Deployment > Common subtab:
Custom User ID Sync SQL Query
The following is example code of a custom user ID sync SQL query:
| Type | Sample Code |
|---|---|
| Altiris | SELECT DISTINCT Guid as UserResourceID, Name FROM vUser ORDER BY Name |
| ConfigMgr SCCM 2012 | SELECT vru.ResourceID as UserResourceID FROM v_R_User vru ORDER BY vru.Name0 |
App Portal is specifically looking to read the mandatory UserResourceID column.
To verify your query and its columns, first click Save, and then click the Test User Sync Settings button.
Custom User Sync SQL Query
The following is example code of a custom user sync SQL query:
Custom User Sync SQL Query Example
| Type | Sample Code |
|---|---|
| Altiris | SELECT DISTINCT u.[Given Name] AS FirstName, u.[Surname] AS LastName, '' AS OS, u.[Office Location] AS Office, u.City as City, u.Zip AS PostalCode, u.Department AS Department, u.[Job Title] AS Title, u.Name AS UserName, u.Email AS Email, m.ManagerDN AS Manager, u.Guid AS UserResourceID, ad.[Distinguished Name] AS ADSPath, u.[Display Name] AS FullName, '' AS Name, u.Domain + '\' + Name AS UniqueName, '' AS UserDomain, u.Company AS Company, ou.[Distinguished Name] AS UserOU FROM vUser u INNER JOIN Inv_Global_Active_Directory_Details ad on ad._ResourceGuid = u.Guid INNER JOIN Inv_OU_Membership ou on ou._ResourceGuid = u.Guid LEFT JOIN ( SELECT ra.ParentResourceGuid, it.Name as Manager, ra.ChildResourceGuid, ad.[Distinguished Name] as ManagerDN FROM ResourceAssociation ra LEFT JOIN vItem it ON ra.ChildResourceGuid = it.Guid INNER JOIN Inv_Global_Active_Directory_Details ad on ad._ResourceGuid = it.Guid WHERE ra.ResourceAssociationTypeGuid = '049C633F-8413-42AE-93EA-F4EB7EDAFC65' ) m on m.ParentResourceGuid = u.Guid |
| ConfigMgr SCCM 2012 | 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 |
App Portal is specifically looking to read the following mandatory columns:
UserResourceID FirstName LastName Office City PostalCode Department Title UserName Email Manager ADSPath FullName UniqueName [in the format of Domain\UserName] UserDomain Company UserOU
Custom User Sync Connection String
The following is example code of a custom user sync connection string:
| Type | Sample Code |
|---|---|
| Altiris ConfigMgr SCCM 2012 | Data Source=<span class="Emphasis">DBSERVERNAME</span>;Initial Catalog=<span class="Emphasis">DBNAME</span>;Integrated Security=True |
If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Users. To verify your connection string, first click Save, and then click the Test User Sync Settings button.
Custom Computer Sync Settings
This section provides examples of code that could be used in the Custom Computer Sync Settings area of the Deployment > Common subtab:
Custom Computer ID Sync SQL Query
The following is example code of a custom computer ID sync SQL query:
Custom Computer ID Sync SQL Query Example
| Type | Sample Code |
|---|---|
| Altiris | SELECT DISTINCT Guid AS ResourceID, Name AS MachineName FROM vComputerEx ORDER BY Name |
| ConfigMgr SCCM 2012 | SELECT vrs.ResourceID, vrs.Netbios_Name0 FROM v_R_System vrs ORDER BY vrs.Netbios_Name0 |
App Portal is specifically looking to read the mandatory ResourceID column.
To verify your query and its columns, first click Save, and then click the Test Computer Sync Settings button.
Custom Computer Sync SQL Query
The following is example code of a custom computer sync SQL query:
Custom Computer Sync SQL Query Example
| Type | Sample Code |
|---|---|
| Altiris | SELECT DISTINCT c.Guid AS ResourceID, c.Name AS MachineName, c.[User] AS SMSUserName, '' AS ADSite, c.IsManaged AS Client, c.IsManaged AS Active, 0 AS ClientType, 0 AS Obsolete, c.Domain AS UserDomain, c.Domain AS MachineDomain, '' AS ManagedBy, ou.[Distinguished Name] AS SystemOU FROM dbo.vComputerEx c INNER JOIN Inv_OU_Membership ou ON ou._ResourceGuid = c.Guid |
| ConfigMgr SCCM 2012 | SELECT DISTINCT vrs.ResourceID, Netbios_Name0 AS MachineName, User_Name0 AS SMSUserName, AD_Site_Name0 AS ADSite, Client0 AS Client, Active0 AS Active, Client_Type0 AS ClientType, Obsolete0 AS Obsolete, User_Domain0 AS UserDomain, Resource_Domain_OR_Workgr0 as MachineDomain,vrs.Operating_System_Name_and0 as OperatingSystem, ra.System_OU_Name0 as SystemOU, ( SELECT top 1 IP_Addresses0 FROM v_RA_System_IPAddresses WHERE v_RA_System_IPAddresses.IP_Addresses0 not like '%:%' --ignore ipv6 address AND v_RA_System_IPAddresses.ResourceID=vrs.ResourceID ) AS [IPAddress] , ManagedBy0 as ManagedBy FROM dbo.v_R_System vrs left join v_RA_System_SystemOUName ra on ra.ResourceID = vrs.ResourceID |
App Portal is specifically looking to read the following mandatory columns:
ResourceID MachineName SMSUserName ADSite Client Active ClientType Obsolete UserDomain MachineDomain ManagedBy SystemOU
Custom Computer Sync Connection String
The following is example code of a custom computer sync connection string:
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 Altiris | Data Source=<span class="Emphasis">DBSERVERNAME</span>;Initial Catalog=<span class="Emphasis">DBNAME</span>;Integrated Security=True |
If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Computers. To verify your connection string, first click Save, and then click the Test Computer Sync Settings button.
Custom User Computer Map Sync Settings
This section provides examples of code that could be used in the Custom User Computer Map Sync Settings area of the Deployment > Common subtab:
Custom User Computer Map ID Sync SQL Query
There are two examples of Custom User Computer Map ID Sync SQL queries:
Primary Example
The following is example code of a custom user computer map ID sync SQL query for a primary device:
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 (Only) | SELECT DISTINCT vrs.ResourceID, vrs.Netbios_Name0 AS MachineName FROM v_R_System AS vrs INNER JOIN vUsersPrimaryMachines ON vrs.ResourceID = vUsersPrimaryMachines.MachineID INNER JOIN v_R_User AS vru ON vUsersPrimaryMachines.UserResourceID = vru.ResourceID ORDER BY vrs.Netbios_Name0 |
| Altiris | SELECT uc._ResourceGuid as [ResourceID], uc.Name AS [MachineName] FROM Inv_AeX_AC_Identification uc LEFT OUTER JOIN Inv_AeX_AC_Primary_User pu ON pu._ResourceGuid = uc._ResourceGuid ORDER BY uc.Name |
App Portal is specifically looking to read the mandatory ResourceID and MachineName columns.
To verify your query and its columns, first click Save, and then click the Test User Computer Map Sync Settings button.
Last Logon User Example
The following is example code of a custom user computer map ID sync SQL query for a last logon user:
Custom User Computer Map ID Sync SQL Query / Last Logon User
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 | SELECT DISTINCT vrs.ResourceID, vrs.Netbios_Name0 AS MachineName FROM v_R_System AS vrs LEFT OUTER JOIN v_R_User AS vru ON vrs.User_Name0 = vru.User_Name0 AND vrs.User_Domain0 = vru.Windows_NT_Domain0 ORDER BY vrs.Netbios_Name0 |
| Altiris | SELECT uc._ResourceGuid AS [ResourceID], isnull(uc.[Name], uc.[Name]) AS [MachineName] FROM Inv_AeX_AC_Identification uc ORDER BY uc.Name |
App Portal is specifically looking to read the mandatory ResourceID and MachineName columns.
To verify your query and its columns, first click Save, and then click the Test User Computer Map Sync Settings button.
Custom User Computer Map Sync SQL Query
There are two examples of Custom User Computer Map Sync SQL queries:
Primary Example
The following is example code of a custom user computer map sync SQL query for a primary device:
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 (Only) | SELECT DISTINCT vrs.ResourceID, vru.Unique_User_Name0 AS UniqueName, vrs.Netbios_Name0 AS MachineName, 1 AS Active FROM v_R_System AS vrs INNER JOIN vUsersPrimaryMachines ON vrs.ResourceID = vUsersPrimaryMachines.MachineID INNER JOIN v_R_User AS vru ON vUsersPrimaryMachines.UserResourceID = vru.ResourceID |
| Altiris | SELECT * from ( SELECT uc._ResourceGuid AS [ResourceID], uc.Name AS [MachineName], isnull([pu].[Domain] + N'\' , N'' ) + isnull( [User] , N'' ) AS [UniqueName], 1 AS [Active] FROM Inv_AeX_AC_Identification uc LEFT OUTER JOIN Inv_AeX_AC_Primary_User pu ON pu._ResourceGuid = uc._ResourceGuid ) uc |
App Portal is specifically looking to read the following mandatory columns:
ResourceID MachineName SMSUserName ADSite Client Active ClientType Obsolete UserDomain MachineDomain ManagedBy SystemOU
Last Logon User Example
The following is example code of a custom user computer map sync SQL query for a last logon user:
Custom User Computer Map Sync SQL Query /Last Logon User
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 | SELECT DISTINCT vrs.ResourceID, vrs.Netbios_Name0 AS MachineName, vru.Unique_User_Name0 AS UniqueName, 1 AS Active FROM v_R_System AS vrs LEFT OUTER JOIN v_R_User AS vru ON vrs.User_Name0 = vru.User_Name0 AND vrs.User_Domain0 = vru.Windows_NT_Domain0 |
| Altiris | SELECT * FROM ( SELECT uc._resourceguid AS ResourceID, isnull( uc.[Name], uc.[Name]) AS [MachineName], isnull( uc.[Last Logon Domain] + N'\', N'' ) + isnull( uc.[Last Logon User], N'' ) AS [UniqueName], 1 AS [Active] FROM Inv_AeX_AC_Identification uc ) uc |
App Portal is specifically looking to read the following mandatory columns:
ResourceID MachineName SMSUserName ADSite Client Active ClientType Obsolete UserDomain MachineDomain ManagedBy SystemOU
Custom User Computer Map Sync Connection String
The following is example code of a custom user computer map sync connection string:
| Type | Sample Code |
|---|---|
| ConfigMgr SCCM 2012 Altiris | Data Source=<span class="Emphasis">DBSERVERNAME</span>;Initial Catalog=<span class="Emphasis">DBNAME</span>;Integrated Security=True |
If you do not specify a custom connection string, App Portal will default to the connection string of the technology selected for Syncing Users and Syncing Computers. To verify your connection string, first click Save, and then click the Test User Computer Map Sync Settings button.
Workaround for Intune Domain Name Sync Limitation
Microsoft Intune has a limitation of not being able to provide the domain value of the device. Due to this, if Intune is chosen as the source of device data sync, App Portal does not currently have support for license governance capabilities like license reservation and license reclamation. This is because device domain is an important value while getting license position and usage details from FlexNet Manager Suite. Due to this limitation, for customers who have a comanaged setup where they are using both Configuration Manager and Intune, for now, the recommendation would be to use Configuration Manager as the source of data sync until Intune provides the capability to fetch domain name. However, if Intune is chosen as the source for data sync, a workaround is provided to fetch the device domain data which is detailed in Intune Domain Name Limitation and Workaround.
See Also