70488 - The scenario parameters auditing script in SAS® Visual Investigator

Sample 70488: The scenario parameters auditing script in SAS® Visual Investigator

In SAS Visual Investigator, you can use the information in the Action History User Interface (UI) to audit changes to scenario parameters. However, it's difficult to view this information from a high level.

The data required to view changes to scenario parameters exists in the Scenario Admin schema; there just isn't a UI for browsing the changes. As a result, the SAS R&D team developed a Python script that fetches the data from the schema and renders the data in a Microsoft Excel spreadsheet.

Script Instructions

The script is available on the Downloads tab.

Install Python

To install Python, see the following link: https://www.python.org/downloads/

Then, run the following scripts:

Install the requests module

pip install requests

Install Pandas Module

pip install pandas

Openpyxl

pip install openpyxl

Running the script

Use the following Python syntax to execute the script:

py getScenarioParameterChanges.py -g <guid> -p <protocol> -s <server> -u <user> -w <password> -o <filename.xlsx>

Here is an example:

py getScenarioParameterChanges.py -g 5410ead9-489b-4323-9a47-883346a4647a -p http -s internalDevServer.na.sas.com -u user1 -w user1Password -o output.xlsx

Find your Flow guid

To locate your flow_guid, run the following SQL query:

SELECT flow_guid FROM svi_vsd_service.vsd_flow

WHERE flow_nm = '<flow name>'

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Sample python script

The Action History User Interface (UI) contains information about changes to Scenario Parameters, but this information is difficult to view from a high level. As a result, the SAS R&D team developed a Python script that fetches the data from the schema and renders it in an Excel spreadsheet.

Type:

Sample

Date Modified:	2023-11-16 09:35:47
Date Created:	2023-11-06 09:36:25

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
Product Family	Product	Host	Starting	Ending	Starting	Ending
SAS System	SAS Visual Investigator (on SAS Viya 3.x)	Linux for x64	10.8		Viya
SAS System	SAS Visual Investigator	Linux for x64			Viya platform

Support