[SAMP] Client Access data population in Software Asset Management ProfessionalIssue <!-- div.margin{ padding: 10px 40px 40px 30px; } table.tocTable{ border: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .6em; padding-bottom: .6em; padding-left: .9em; padding-right: .6em; } table.noteTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:2; } table.internaltable { white-space:nowrap; text-align:left; border-width: 1px; border-collapse: collapse; font-size:14px; width: 85%; } table.internaltable th { border-width: 1px; padding: 5px; border-style: solid; border-color: rgb(245, 245, 245); background-color: rgb(245, 245, 245); } table.internaltable td { border-width: 1px; padding: 5px; border-style: solid; border-color: #E0E0E0; color: #000000; } .title { color: #D1232B; font-weight:normal; font-size:28px; } h1{ color: #D1232B; font-weight:normal; font-size:21px; margin-bottom:-5px } h2{ color: #646464; font-weight:bold; font-size:18px; } h3{ color: #000000; font-weight:BOLD; font-size:16px; text-decoration:underline; } h4{ color: #646464; font-weight:BOLD; font-size:15px; text-decoration:; } h5{ color: #000000; font-weight:BOLD; font-size:13px; text-decoration:; } h6{ color: #000000; font-weight:BOLD; font-size:14px; text-decoration:; } ul{ list-style: disc outside none; margin-left: 0; } li { padding-left: 1em; } --> Client Access Data: While using the SAMP-Oracle package, we may required to populate client access data such as Oracle named user and license calculation for reconciliation. If we goto the tables, we can see that there are two different tables with name samp_client_access and samp_sw_client_access. We may get confused between these two tables as the naming is same. The real table used for the client access data is samp_sw_client_access. Note: Currently, there is no option to auto populate the table samp_sw_client_access (like by using the discovery). Until Madrid release, the expectation is that table samp_sw_client_access should be populated manually. Whats there on Client Access form: Name: You can give any name that describes what model and instance (if any) in short form. Software Model: Select the Model of client access data that you wanted to calculate. Database Instance: This is visible only when the selected Software model product is Oracle Database Total device count: Enter the number of Unique devices allowed to access the product. Total user count: Enter the number of Unique users allowed to access the product. Note: In case of Oracle DB: it's the number of user that is using this oracle instance Automate the Client Access data population Currently, we do not have any OOB soilution to auto populate the table samp_sw_client_access (like by using the discovery). Either by some manual automated process like import sets or others. By manual entry.By using the scheduled import sets and transform maps. Please refer below for scheduled import sets and transform maps. Scheduled Import Sets Transform maps Release All releases up-to Madrid. Environment Any. Additional Information Import sets Client Access [samp_sw_client_access]