Installing Python On IIS
Question: Some users might want to install python on their IIS, for example in order to establish SSO by using python code. How can I install it? Solution: In order to do so, follow these steps: Insure you have CGI installed on your IIS: Go to Start -> Control Panel -> Programs and Features -> on the left hand side, go to "Turn Windows Features on or off" -> Under the IIS node, make sure CGI is installed: Download Python for Windows, from python.org (doesn't matter 2.7 or python 3, depends on your preference). Make sure you get the x64 version if you have an x64 version of Windows. Unpack and install that python MSI. Choose the default, which puts python into c:\PythonX (X will be replaced with your Python version) Create a directory to hold your "development" python scripts. Eg, c:\dev\python Set the permissions on the files in the directory c:\dev\python to allow IIS to read and execute. Do this by running these two icacls.exe commands from the command line: cd \dev\python icacls . /grant "NT AUTHORITY\IUSR:(OI)(CI)(RX)" icacls . /grant "Builtin\IIS_IUSRS:(OI)(CI)(RX)" Open the IIS manager, and create a new application. Specify the virtual path as /py and the physical path as c:\dev\python: Within the new IIS application, add a script map for *.py , and map it to c:\python27\python.exe %s %s: create a "HelloWorld.py" file in c:\dev\python with this as the content: print('Content-Type: text/plain') print('') print('Hello, world!') Test that the script is working - invoke in the browser http://localhost/py/helloworld.py *You should be able to use all Python libraries you have installed on your system. *In case that you try to open the script and it returns a 502 error, it means that something is wrong in the script. In such cases, debug it on your IDLE instead through the browserHow to Export a List of Sisense Users
Question: How can I export a list of Sisense users, for example users from a specific group? Solution: Using the REST API you can pretty quickly get this info in JSON document format. The GET /users API supports group ID: You could run GET /groups with the group name to get it's ID: Then use that group ID in the GET /users call which will provide users who are members of that group. You can even use the 'fields' parameter to include or exclude fields. If you use the "v1" API instead, which is at /api/v1/users, you could simplify the results from this API by specifying which fields should be returned, via the "fields" parameter: or as it would be in the URL: http://10.50.12.161:30845/api/v1/users?fields=userName%2Cemail Other solution is to connect to Sisense MongoDB through Mongo Connector https://documentation.sisense.com/latest/managing-data/connectors/mongodb_online.htm#gsc.tab=0 , before that you need to setup read user on your mongo for Sisense via this API: After you setup this user and connect using it to Mongo on Sisense you will be able to select connecting to some databases and you should select this one: The in Collections look for Users and Groups tables. Due to JSON structure mongo connector can generate multiple tables for Users and Groups depending on how many nested JSON structures are within it. That should be relatively easy to go through, and then you should have a full structure of Users per Group. What is more, this can be imported inside Sisense Elasticube so you will be able to create a dashboard based on this and export it into any format.