Better Tools, Better Management!

The RMM Suite not only automates VSA agent management, but includes tools to simplify common administrative tasks as well. The current set of Offline Administration tools includes Customer and Site management, Server Patch Management, and Password Ciphering. New tools are always being added to help make VSA administration faster and easier.

Customer & Location Manager Tools

Customer Locations SpreadsheetThis tool lets you create new customer organizations and/or locations by simply adding a record to an Excel spreadsheet. Define the Org ID, customer name, and a few other parameters to define what kind of devices will be maintained at each location. Run the Prep tool and the location (country, region/state, and city) will be looked up in the United Nations LOCODE database. This will be used for the default location group name. You can then edit the spreadsheet to modify or replace the location ID. The Update tool is then used to read the spreadsheet and automatically update VSA with the new organizations, locations, and appropriate machine-group structure. This ensures a consistent structure with minimal effort.

The example above shows the mega-co locations in NYC and San Francisco, plus an Azure data center associated with the NYC location. The codes were inserted by automation from the LOCODE spreadsheet, then adjusted manually to define the Azure location. The W/S/T/P column designated the first NYC location as the primary, and the Azure location as only having server devices. The tool will make sure that the customer and all necessary location and agent-type groups are created.

Server Patch Management Tools

Patch Management SpreadsheetManage and report on server patch schedules using an Excel Spreadsheet. The GetPatchCodes tool collects the list of servers, customers, and currently defined patch schedule codes from Kaseya and populates an Excel spreadsheet. This allows the administrator to assign schedule codes to each sever and immediately verify the code is correct. The spreadsheet displays the week, day, and time that the schedule code represents. Once all of the servers have been assigned schedule codes, the spreadsheet is saved, and the SetPatchCodes tool updates VSA with the data from the spreadsheet. Hundreds of servers can be accurately scheduled for Windows Updates in just minutes. The spreadsheet can then be used to generate reports showing which servers (and customers) will be updated at any given time. This is an ideal report to send to your on-call team each week. In the example shown here, the patch codes are defined and the corresponding schedule is displayed in the blue fields. Note the servers in the data center ("dc" prefix") are scheduled for the last cycle of patching (Week 1) and spread out to ensure that the systems reboot in a sequence that allows the application dependencies to be handled.

Password Ciphering Tool

The RMM Suite heavily leverages Managed Variables to define customer-specific information. This can be used to define both customer-specific and MSP-specific accounts. Unfortunately, the Managed Variables are stored in clear-text, making them visible to anyone with VSA access. Our Cipher tool allows the VSA administrator to cipher the password and store the ciphered value in the managed variable. The ciphers are customer-specific and use a proprietary method that is fast and secure. A password of just 6 characters can result in over 281 trillion unique cipher combinations. The ciphered value is secure while "at rest" in the Kaseya VSA and while "in flight" to the agent. The application that we developed to create or update local accounts can determine from VSA if the password is ciphered. If it is, it requests the customer-specific part of the key, then deciphers the password just prior to making the system call to create or update the local account.