Administration
Organizations
Adding an Organization
-
From the Admin menu, click Organizations.
-
Click the Create button and then enter your Meraki API key.
-
Press Look Up and DataMagic will provide a drop down box to select which Organization you wish to add.
-
Once an Organization is selected, DataMagic will query the Meraki API and populate your Organizations information.
-
Ensure Enabled is ticket & select Save.
DataMagic will begin to collect your data from the Meraki API and after a few minutes, Networks and Devices will appear on the Networks and Devices pages.
You can collect data for multiple organizations allowing you to analyse all data in one place, so repeat steps 4-6 to add further organizations.
Removing an Organization
To delete an organization:
- From the Admin menu, click Organizations.
- Click to select the required Organization (use the search box if needed)
-
Click Edit
- In the dialog box that appears, click the Delete button.
- You are prompted to be sure you want to delete the organization.
- If you wish to proceed with deletion, click Yes and the organization is deleted.
Mac Vendors
In order to interpret MAC Vendors, Meraki DataMagic holds some Master Data Records (MDRs) for MAC Vendors. We provide some initial MDRs, but you should maintain this. In particular, you should ensure that the MAC Vendor priority field is set to the appropriate value for your organization. For MACs that you wish to be included in reports, you should set the priority to any value above 0 (we recommend 100).
You are able to upload a JSON file containing MAC Vendors to DataMagic. The format of this data should be in the same format as those available here: https://maclookup.app/downloads/json-database. You can augment this format with priority information by adding a priority field to any records that you wish to have a value other than the default/current value.
For example:
{ "macPrefix": "00:00:00", "vendorName": "XEROX CORPORATION", "private": false, "blockType": "MA-L", "lastUpdate": "2023/06/01", "priority": 100 }
Users
There is no need to perform proactive user management in DataMagic. When a user first logs in, they are automatically created in DataMagic, but are not approved. As a Tenant Administrator, you will receive notification that a user is awaiting approval and can simply respond to that mail. Once approved, the user can log in and access the system. Alternatively, you can pro-actively create/approve users in DataMagic and they will be able to log in immediately.
Note that because DataMagic uses Microsoft Azure Active Directory for authentication, there is no benefit to creating a user in DataMagic that will not exist in Azure AD.
If you wish to suspend a user's access to DataMagic, you can do so by "un-approving" them.
If you wish to remove a user from DataMagic, you can do so by clicking the Delete button on the Users page.
If you need to use a different Single Sign On (SSO) solution, please raise a Support Request using the Feedback link in the top right of the page.
Accessing your data
You can access your data:
- Through the UI at https://data.magicsuite.net
- Via remote SQL queries
To access your data with remote SQL queries, we require some additional information to ensure data security. You can provide this information by raising a Support Request:
- Click the Feedback link in the top right of this page.
- Select the Support Request type from the Type drop down
- In the Summary, please enter Company Name - Remote SQL Access
-
Then in the Description, please enter:
- The IP Address Range(s) of the machine you wish to access the database from.
- The username(s) that require access
- Any table constraints you wish to put in place for each user
- Click Submit and wait to hear from Support.
Requests are actioned in UK business hours.