{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Read Me","API Control","SelectionOptions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":30,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,1,22,2],[3,1,3,3],[5,1,5,3],[7,1,7,3],[9,1,9,3],[10,1,10,3],[19,1,19,3],[20,1,20,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[16,1,16,3],[18,1,18,3]]}
[]
["Stratusphere API Builder Version 1.2"]
[]
["Purpose:","The purpose of this Excel workbook is to provide examples to help you model and construct Stratusphere API strings."]
[]
["Before Getting Started:","Must be running Liquidware Labs Stratusphere version 5.6.2 or greater. Stratusphere API access must be setup for each IP address or subnet via the Administration menu in the Stratusphere Hub Appliance. On the Configuration tab, under Other Settings, you will note an \"API Client IPs\" field where IP address authentication is granted. See Stratusphere API QuickStart Guide for more detailed help."]
[]
["How to Use:","Select the \"API Control\" tab below and complete the GREEN fields to configure appropriate settings. Once configured, data worksheets will be generated based on information selected when \"Get Data\" button is clicked."]
[]
["Notes:","You must be using Stratusphere version 5.6.2 or 5.6.4 for this MS Excel Workbook to work"]
[null,"Stratusphere 5.6 and higher support the JSON API"]
[null,"Not all API calls used in this workbook were supported until Stratusphere 5.6.2"]
[null,"This version of the API Builder was created and tested with versions 5.6.2 and 5.6.4 of Stratusphere"]
[]
[null,"The Stratusphere API instruction set is growing. Newer versions of the API may render this workbook obsolete. Please be sure to update this Excel API Builder accordingly."]
[]
[null,"This worksheet was tested with Microsoft Excel versions 2010 and 2013. Other versions may not function as intended. Feel free to modify this worksheet as needed -- to unprotect the locked and hidden features in these worksheets, use password Stratusphere. No support is given, expressed or implied."]
[]
["Resources:","Extend Visibility with the Stratusphere APIs (blog post)"]
[null,"Stratusphere API Knowledge Base"]
[null,"Stratusphere API Video How-To"]
[]
["Last Updated:","2014-09-11"]
["Last Updated By:","dk@liquidwarelabs.com"]
[]
["Revision History:","Release Date","Version","Updates"]
[null,"2014-07-16","1.1","First GA Release"]
[null,"2014-09-11","1.2","Logic improved for versioning"]

{"sheet":"API Control","index":1,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[29,2,32,3],[40,2,40,3],[42,2,42,3],[44,2,44,3],[47,2,47,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[38,2,38,3],[27,0,27,3],[28,2,28,3],[3,0,3,3],[4,2,4,3],[13,2,13,3],[11,2,11,3],[15,2,15,3],[22,1,22,3]]}
[]
["Stratusphere API Builder Version 1.1"]
[]
["Please update all GREEN fields"]
["Stratusphere Hub Appliance:","demo.liquidwarelabs.com","Enter DNS name or IP address of Stratusphere Hub Appliance"]
[]
[]
[]
[]
[]
[]
["Data Output Type:","This Excel Workbook","Output format type (pulldown)"]
[]
["Data Output Name:","Data Worksheet 1","Worksheet name for Stratusphere API query"]
[]
["Update String Live:","Yes","Stratusphere API string update mode (pulldown)"]
[]
[]
[]
[]
[]
[]
["Generated API String:","https://demo.liquidwarelabs.com/cgi-bin/mentok/run.cgi?json={\"inspector\":\"summary\",\"basis\":\"users\",\"date\":\"24 hours\",\"sort_order\":\"1\",\"output\":\"1\",\"delimiter\":\"1\",\"header\":\"1\"}"]
[]
[]
[]
[]
["Select API string details here"]
["Time Range: ","Last 24 Hours","Select Time Range  (pulldown)"]
["Custom Start Date:","2014-07-01","Select custom start and end date/time"]
["Custom Start Time:","08:00:00"]
["Custom End Date:","2014-07-04"]
["Custom End Time:","17:00:00"]
[]
["Time Window:","All","Select Time Window -  Across time range selected (pulldown)"]
["Time Window Start:",8]
["Time Window End:",17]
[]
["Query Resolution:","Summary","Select Query Output Resolution (pulldown)"]
[]
["Inspector Name:","Summary","Select the Stratusphere Inspector name (pulldown)"]
[]
["Inspector Basis:","Users","Select the Stratusphere Inspector basis (pulldown)"]
[]
["Machine Type:","Virtual & Physical","Select Query for virtual or physical devices, or both (pulldown)"]
["Application Inspector Options:","Both","Application Process Type: User,System or Both (pulldown)"]
[]
["Primary Sort Order:","Ascending","Select the output sort order (pulldown)"]

{"sheet":"SelectionOptions","index":2,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[1,3,1,4],[11,7,11,10],[5,3,5,4],[14,7,14,12],[1,11,1,12]]}
["TAB:","SelectionOptions",null,"DO NOT Modify This Information"]
["Purpose:","Selection Options for other TABs",null,"Custom Time Range Rows",null,null,null,"Application","Machine","Resolution","Time Window","Time Window"]
["Last Updated:","2014-07-07",null,"Start ROW","End ROW",null,null,"Inspector Option","Type","Options","Selection Options","Start ROW","End ROW"]
["Last Updated by:","Chris.Walker@liquidwarelabs.com",null,30,33,null,null,"Custom Row","Custom Row","Summary","All",36,37]
[null,null,null,null,null,null,null,46,45,"day","Custom"]
[null,null,null,"Query Selectable Column",null,null,null,"Application",null,"hour"]
[null,null,null,"Start ROW","End Row",null,null,"Inspector Options",null,"hourly"]
[null,null,null,45,56,null,null,"User",null,"dow"]
[null,null,null,null,null,null,null,"System"]
[null,null,"Simple Yes/No Selection","Sort Order","Machine Types",null,null,"Both"]
[null,null,"Yes","Ascending","Physical "]
[null,null,"No","Descending","Virtual",null,null,"Basis Row Depth - Number of Options"]
[null,null,null,null,"Virtual & Physical",null,null,4,4,1,4]
[]
[null,null,"Time Range Options","(Option 1)",null,null,null,"Basis for Inspectors - (Option 2)"]
[null,null,"Report Time Ranges","Inspector Names","API Output Types",null,"Inspector:","Summary","Application","Hosts","PCOIP","User_Groups","Machine_Groups"]
[null,null,"Today","Summary","This Excel Workbook",null,null,"Users","Users","HostName","Users","Date","Date"]
[null,null,"Yesterday","Applications","Browser - CSV Format",null,null,"User_Groups","User_Groups","Date","User_Groups"]
[null,null,"Last 7 Days","Hosts","Browser - TAB Format",null,null,"Machines","Machines",null,"Machines"]
[null,null,"Last 1 Hour","Sessions","Browser - JSON Format",null,null,"Machine_Groups","Machine_Groups",null,"Machine_Groups"]
[null,null,"Last 2 Hours","User_Groups",null,null,null,"Date","Date",null,"Date"]
[null,null,"Last 4 Hours","Machine_Groups",null,null,null,"Login_User:Domain","Application_Name"]
[null,null,"Last 6 Hours","Folders",null,null,null,"Login_ID","application_version"]
[null,null,"Last 8 Hours","Extensions",null,null,null,"Login_Name","Process_Name"]
[null,null,"Last 24 Hours","Network",null,null,null,"Login_Domain","Owner_User_Name"]
[null,null,"Last 48 Hours","Alerts",null,null,null,"O/S_Name","Owner_Name"]
[null,null,"Custom",null,null,null,null,"O/S_Version","Owner_Domain"]
[null,"X","Custom Column Values",null,null,null,null,"datastore","PID"]
[null,null,"NONE",null,null,null,null,"datastore_name","Login_User:Domain"]
[null,null,"NONE",null,null,null,null,"datastore_type","Login_ID"]
[null,null,"NONE",null,null,null,null,"host","Login_Name"]
[null,null,"NONE",null,null,null,null,"current_host","Login_Domain"]
[null,null,"NONE",null,null,null,null,"disk_name","O/S_Name"]
[null,null,"NONE",null,null,null,null,null,"O/S_Version"]
[null,null,"NONE",null,null,null,null,null,"datastore"]
[null,null,"NONE",null,null,null,null,null,"datastore_name"]
[null,null,"NONE",null,null,null,null,null,"datastore_type"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]
[null,null,"NONE"]