These scripts can be run using SQL Management Studio on a Carousel 7 SQL Database Server to gather information about your current system in preparation for a Cloud Conversion. The scripts only ‘read’ the data from SQL, no information is being edited or changed.
Players.sql - Pulls the Player Name, IP Address, Current Channel, and Version (implies type)
Channels and Zones List.sql - Pulls the Channel(s) into one column, Zones for the Channel(s) into the next column, and Full Alert(s) for the Channel(s) into the third column
Zone Tags.sql - Pulls all the Zone Tags in one column and any associated Zones into the next column
Linked Bulletins.sql - Pulls all zones that contain a linked bulletin (may be none)
Shared Zones.sql - Pulls all zones that are shared by more than one channel (may be none)
Users and Zones Access with Activity Date.sql - Pulls all the Users in one column, any Zones which they have access rights to in the next column (Admin users with access to all zones will return NULL), and the last date of account activity. Data migration or a software update can modify the last activity date, so keep this in mind when reviewing the output.
System Info SQL Scripts.zip - All six scripts in a single zip file
Instructions:
Download all six scripts onto the desktop of your Carousel 7 server, and double click one to open SQL Management Studio. If accessing the server remotely, you may be prompted to click Connect on two pop-ups. Once you see the script open, select the heading of the script window and then click the Execute button. After the script has run, another heading will open below displaying the results. Click ‘Results’ so that the section is highlighted and then File > Save Results As… to save as a Text file (Tab delimited .txt). Preferably name the .txt file the same as the SQL script that you just ran. Close the script by clicking the x on the heading of the script window, and minimize SQL Management Studio or navigate back to the desktop and follow the same procedure for the other two scripts. Note: each script can only be run one time without closing the heading window and re-opening.
If you’d like to keep this data for your own use, the text files can easily be brought into a spreadsheet (like this one) by using the import or 'paste special' feature and choosing tab separated values. Happy data gathering!