Use a PowerShell script to retrieve a list of all policies and schedules for your organization and put them in an Excel spreadsheet.
Note: Due to the way Excel auto-formats numbers, the “schedule months” column may show in scientific notation due to the length. To fix the display of them, highlight the column, right-click on the column, click Format Column, choose Custom, then set the Type to 0.
There are two areas in the code that you’ll need to update to get the script to function:
You will need your Org ID, which can be found by looking at the URL. Select the value after the
Note: The user must be a Global or Zone administrator to manage API keys for a zone. See Managing Keys for more information.
In your console, go to Settings → Keys and select the API key. Note that the API key is per user, so that another user will have different API keys.
Policy List and Schedules Script
Use this script to retrieve a list of all your policies in your organization and put them in an Excel spreadsheet.
See also Scheduling Examples and Trailing Zeros description.
Scheduling Examples and Trailing Zeros
Example days per week
For scheduling days of the week, there will be 7 digits with a trailing zero to mark the end. This starts on Sunday and ends on Monday. 1 represents ON and 0 represents OFF for each day of the week.
Every Day :
Mon/Wed/Fri only :
Example weeks per month
Weeks are scheduled similarly to days, except there are 5 digits with a trailing zero. This starts on the 5th week of the month and ends with the 1st week of the month.
2nd/4th weeks only:
Example months per year
Months continue the trend with 12 digits with a trailing zero. Starting with December and ending with January.