#Get0 personne en discute

Hi all.

I am new on Python and and I wrote a code which is comparing the Site users between 2 servers (Prod and DEV) for validation purposes.

What I would like to know is: How to get ALL users from a Site and from a Project, as the GUI list?

My issue is after collecting the users source_server.users.get(), it is not reporting ALL the site users as I can see in the GUI.

I did identified that Server Administrators are not returning with this Site specific function, but there is also Viewer or Explorer only members that are missing in the API list.

May it be because these users does exist in multiple Sites?

with target_server.auth.sign_in(target_tableau_auth):

      target_all_sites, pagination_item = target_server.sites.get()

 for source_site in source_all_sites:

      source_tableau_auth.site_id = source_site.content_url

      with source_server.auth.sign_in(source_tableau_auth):  ⌗Connect to Source Site

        print("\nConnected to Source '{0}' Site on {1} Server".format(source_tableau_auth.site_id, source_server.server_address))

        source_all_users, pagination_item = source_server.users.get()  #Get User list from Source Site

We are using Azure Devops to build a CICD pipeline for mulesoft. We are using the hybrid on prem model.

At the moment I have a build pipeline outputting a .jar file as an artifact using maven package

My Release pipeline takes this file using the Anypoint-cli and deploys it onto either dev, qa or production.

I am using the following command to modify an application and setting the correct OS env variables:

runtime-mgr standalone-application modify [options] <identifier> <zipfile>

I would like to pass properties using anypoint-cli along with my deployment but there doesn't appear to be an option. Whereas I notice that the cloudhub version does have the option to pass in properties.

Therefore, the work around I can see is to go into runtime manager on the anypoint platform to update properties manually. This works, but it is not going to be a great long term solution.

Is there a way to deploy an application which is already a .jar (build once, deploy anywhere), to multiple environments without having to intervene manually? We need environment variables to be set at the time of deployment, for security reasons. Therefore we can't have multiple yaml files at build time, even as secure-configuration properties.

Is a later version of Anypoint Platform CLI going to have this functionality?

Or perhaps have I missed something here and is this already possible?

Thanks so much in advance,

Toby.

How to update / create users coming from Active Directory in Tableau?🙂

I have been asked this question many times in last few months in many forums, how to automatically inactive the users in Tableau server if they are getting inactive in Active Directory or how to create Users in Tableau Server in case any users are newly on boarded in AD users groups available in Tableau, hence writing this solution here

I will not write full code here, it will give you fair enough idea how to achieve the other things

Requirements

1. Active Directory details
2. PowerShell
3. Obdc Driver to reach to Tableau Postgres data base
4. Make sure Tableau database should be enabled
5. Administrative privileges on the Tableau server

Script:

Clear

⌗Get users from ad server

Get-ADUser -Filter * -Properties Name, SamAccountName, EmailAddress, UserPrincipalName, Enabled, Company | Select-Object Name, SamAccountName,UserPrincipalName, EmailAddress, Enabled, Company | where {$_.company -eq "ABHICL"} | Export-Csv "E:\Sandip_SQL\ADUsers_group.csv"

⌗export all the users from Tableau Server

⌗importing my tableau server postgres details kept in csv file

$PostgreSQL_Connection_String = import-csv -path "E:\Sandip_SQL\PostgreSQL_Connection_String.csv"

foreach ($Row in $PostgreSQL_Connection_String)

{

$connectionString = "Driver=$($Row.Driver);Server=$($Row.Server);Port=$($Row.Port);Database=$($Row.Database);Uid=$($Row.User);Pwd=$($Row.Password);"

}

$connection = New-Object System.Data.Odbc.OdbcConnection

$connection.ConnectionString = $connectionString

$connection.Open()

$query = "SELECT name AS UserID,friendly_name AS UserName,licensing_role_name AS Role FROM public._users where name not in ('_system','guest')”

$command = $connection.CreateCommand()

$command.CommandText = $query

$command.CommandTimeout = 0 

$result = $command.ExecuteReader()

$table = new-object “System.Data.DataTable”

$table.Load($result)

$table |Export-Csv -path "E:\Sandip_SQL\tableauusers.csv" ⌗ROWS_INSERTED

$connection.Close()

⌗importing both files ad users and Tableau users

$adusers = import-csv -path "E:\Sandip_SQL\ADUsers_group.csv"

$tabusers = import-csv -path "E:\Sandip_SQL\tableauusers.csv"

#I will first check the records only if exist in both csv and then will mark them unlicensed in Tableau server if their status is not active in AD and License type is still allocated to user

⌗matching counter and monitoring of time taken by the script

$matchcounter

$start = [system.datetime]::Now

# create new CSV file

foreach ($order1 in $adusers){

  $matched = $false

  foreach ($order2 in $tabusers){

    $obj = "" | select "SamAccountName","Ad_Status","Tableau_Role"

    if(($order1.SamAccountName ) -eq $order2.userid ){

      $matchCounter++

      $matched = $true

      $obj.SamAccountName = $order1.SamAccountName

      $obj.Ad_Status = $order1.Enabled

      $obj.Tableau_Role = $order2.role

      Write-Host "Match Found Orders " "$matchCounter"

      $obj | Export-Csv -Path E:\Sandip_SQL\AD_Tableau_Users_Match.csv -Append -NoTypeInformation

    }

  }

}

$end = [system.datetime]::Now

$resultTime = $end - $start

Write-Host "Execution took : $($resultTime.TotalSeconds) seconds."

$updateuser = import-csv -path "E:\Sandip_SQL\AD_Tableau_Users_Match.csv"

# Setup to connect

$server = "your tableau server url"

$s = Invoke-RestMethod -Uri $server/api/3.7/serverinfo -Method get ⌗works on server version 10.1 and later

$api = $s.tsResponse.serverInfo.restApiVersion #2020.1 server

echo $api

⌗make sure you should use either site admin or administrator account only to perform below activity

$username = “your tableau user”

$password = “your tableau password”

$sitelogin = "" ⌗keep site as blank in case of default site

# generate body for sign in

$signin_body = (’<tsRequest>

 <credentials name=“’ + $username + ’” password=“’+ $password + ’” >

  <site contentUrl="'+$sitelogin +'" />

 </credentials>

</tsRequest>’)

$response = Invoke-RestMethod -Uri $server/api/$api/auth/signin -Body $signin_body -Method post

# save the auth token, site id and my user id

$authToken = $response.tsResponse.credentials.token

$siteID = $response.tsResponse.credentials.site.id

$myUserID = $response.tsResponse.credentials.user.id

$siteURL = $response.tsResponse.credentials.site.contentUrl

echo $siteID

# set up header fields with auth token

$headers = New-Object “System.Collections.Generic.Dictionary[[String],[String]]”

# add X-Tableau-Auth header with our auth token

$headers.Add(“X-Tableau-Auth”, $authToken)

⌗tests whether logged in user is an Administrator (site or server)

$loginUserid = Invoke-RestMethod -Uri $server/api/$api/sites/$siteID/users/$myUserID -Headers $headers -Method Get

$admin = $loginUserid.tsResponse.user.siteRole -like "*Administrator"

if($admin)

{

foreach ($line in $updateuser )

  {

    if($line.Ad_Status -eq "FALSE" -and $line.Tableau_Role -ne "Unlicensed")

      {

        $userid = $line.SamAccountName

        $SiteRole = "Unlicensed"

        ⌗user update body

        $userupdate = ( '<tsRequest> <user siteRole="'+$SiteRole+'" /> </tsRequest>' )

        $response = Invoke-RestMethod -Uri $server/api/$api/sites/$siteID/users/$userid -Headers $headers -Method Put -Body $userupdate

        write-host $response.tsResponse.user

      }

  }

}

@Ciara Brennan​  @David Browne​  @Veronica Simoes​ 

I'm not sure the best way to put this into words, so I wrote it out in what I hope is an English legible pseudo code. # denotes a comment for explanation purposes. I've been trying to do this in tableau with LOD descriptions, for example {FIXED [Subscriber ID]:COUNT([Subscriber ID])} counts the number of instances of the same ID but it doesn't exclude those not made within 24 hours of one another. Any help would be greatly appreciated

for each entry:

     get list of all other entries with same UserID

          for each entry in list:

               if thisEntry.date-entryWithSameUserID.date < 24 hours:

                    add to resultsList

                    break

⌗now I have a results list with a bunch of entries that were logged

⌗within 24 hours of one another from the same user ID

⌗note that if a user made 2 entries in our data base on 1/1/2019

⌗and then the same user made 2 entries in our data base on 2/2/2019

⌗the same user would be in our results list multiple times for the

⌗two seperate occasions that s/he made multiple purchases within 24 hours

for each entry in resultsList

     ⌗get how many entries were made within a 24 hour period per ID

     Count instances of each ID

     ⌗get which purchases led to more purchases within 24 hours

     ⌗ex. if someone buys a puppy, are they likely to also buy a bed within 24 hours?

     ⌗ex. if someone buys a puppy, are they likely to also buy a bed AND food within 24 hours?

     for each set of purchases made within 24 hours

          count which purchases were made with the earliest date

Hi There,

We are trying to parse XML using REST API "Query Workbooks for Site" to get the workbook id, workbook name, tags associated with the workbook and the project it belongs to.

Expected Response body:

<tsResponse>

  <pagination pageNumber="page-number"

  <workbooks>

    <workbook id="workbook-id" name="name"

      <project id="project-id" name="project-name" />

      <owner id="user-id" />

      <tags>

        <tag label="tag"/>

        ... additional tags ...

     </tags>

   </workbook>

   ... additional workbooks ...

  </workbooks>

We are unable to get the project id, project name, owner id and the tags associated with the workbook

We use the below to parse XML.

import xml.etree.ElementTree as ET

Below is the query

def query_workbooks():

    paged_url = url + "?pageSize={}&pageNumber={}".format(pageSize, pageNum)

    server_response = requests.get(paged_url, headers={"x-tableau-auth": TOKEN},verify=False)

    total_count_of_workbooks = int(xml_response.find('t:pagination', namespaces=xmlns).attrib.get('totalAvailable'))

````````````````

for WB in list_of_workbooks:

        print("IN A WB : "+ str(WB))

        '''

        a = a + 1

        print("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ :" + str(a))

        print("WB #" + str(a) + "           is:" +  WB.get('name'))

        print("              id is:        " +  WB.get('id'))

        print("      contentUrl is:" +  WB.get('contentUrl'))

        print("       updatedAt is:" +  WB.get('updatedAt'))

        '''

    for tag in list_of_tags:

        print("IN A TAG"  + tag.get(tag))

Can someone help us to understand what's wrong with this query, why we are not able to get the tags, project id, project name, owner id in the response.

Thanks,

Shoba