Microstrategy Workstation scripts to get the quick search results - mstrio Python scripts
It is Microstrategy Workstation scripts (Python) to get the results from the search object. In the past, this is the usual thing we do in Command Manager. Lets see a use case to understand this better: List all reports and dashboards in a particular folder and get its details (Report name, Owner, Location, Create date, Mod date, etc). Usually, we create a search object in Microstrategy and save the search object in a folder. Then we run a command manager script to get the results from the search object. Here, we will see how to achieve that in Microstrategy Workstation Scripts (Python) Script Logic: 1) Import all packages 2) Establish a connection to Microstrategy project 3) Get the search results in a List object 4) #3 is a complex nested list and nested dictionaries 5) Loop through the nested list and dictionary and construct the path and get owner details 6) Move the results to a data frame 7) Remove unwanted columns from the data frame 8) Add the path and owner details that we