The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Facebook Twitter YouTube
Trending
Ragic Life+
Applications
What is Ragic
Talking Ragic
Facebook Twitter YouTube
Product
Guide
About
Trending
Ragic Life+
Applications
What is Ragic
Talking Ragic

Taking things into your own hands: Free Ragic Template for Asset and IT Request Management

By Lillian Huang

Always losing count of computers in the office? Rummaging through dusty cabinets to find out when your software license expires? Or maybe the newcomer's new computer is having software issues, and you're having trouble tracking all the face-to-face, phone, and mail conversations? How about giving Ragic's free IT Help Desk template a shot?

The IT Help Desk template is one of a series of templates from Ragic that's free to use. The IT Help Desk template deals with two basic IT needs:

(1) Asset Management, which can tell you how many computers you have, who's using it, what software licenses you own, and when they need to be renewed.

(2) IT Request Report, which replaces the traditional face-to-face, phone, or mail interactions. People who need help can simply fill out an online form and users can check online for the progress to make tracking simpler and more efficient.

Installation and Features of the Ragic IT Help Desk Template

Installation: Click this link to install and the system will register a free account for you. Before you reach 1,000 data entries, you can use the template absolutely free. No credit card information is needed, so you don't have to worry about being charged by accident.

You can also go to the Ragic Homepage, scroll down, find the template browser and locate MIS - IT Help Desk to download.

If you have never registered a Ragic account before, the system will guide you through the registration process for a free account, create a database, and install the template in this database. Registration is free and you can rest assured that we will not charge you without your consent.

Description of Sheets and How to Use Them

The IT Help Desk template includes six sheets, four of which center around information management: User Management, Hardware Asset Management, Software License Allocation, and Software License Management; and two around process management: IT Request & IT Assignment. The sheets are aimed at providing a mechanism for recording and tracking internal IT asset allocation. When the staff runs into problems, the sheets allow them to quickly submit a request so the IT personnel can efficiently solve the problem. The process is shown as follows:

The order of creating data for the sheets should be:

IT User ManagementHardware Asset Management / Software License Management → Software License Allocation → IT RequestIT Assignment



1. IT User Management

In general, company or organization staff are all users of IT assets, and this user information must be compiled into a sheet to make it easier to assign assets and manage service requests later. When the need arises, you just have to take a glance at the user management sheet to know which devices are in whose hands.

The figure below shows the IT User Management sheet, which is split into three major sections: basic information, installed hardware, and assigned software.

Most of the fields are greyed out, meaning they are read-only fields that are automatically filled without requiring manual input. So, it's very simple to create an entry for a user for the first time: just click the only writeable field, User Name, and type in the name of the user you are creating the entry for. Note that if the user has not been added as a user in your Ragic database account, they cannot be added as an IT user either.

The Basic Information section is set up to automatically fill in user information from the user page such as employee number, department, job title, phone number, extension, mobile number, and e-mail address. If a field remains empty, you can go directly to the user page and add it.

The Hardware and Software sections below are reference subtables which are automatically populated with information from the Hardware Asset Management and Software License Allocationsheets, respectively. Once the assigned software or hardware has been entered into the latter two sheets, the IT User Management sheet for the user will show the corresponding information.

2. Hardware Asset Management

If your company assigns computers for its employees, then you can record that information in the Hardware Asset Management sheet by creating one entry for each device, as shown below.

In the Asset Information section, the template has some default Device Types, such as Laptops / Notebooks or Desktops. For the Item Model, we recommend writing in the model name under which the device was sold. We also recommend filling in the device serial number if available. In this sheet, every new entry will automatically generate a new number in the Device Number field, which is a value unique to the particular device.

Note: If you want to use barcodes to manage these physical assets, you can consider creating a field that displays as a barcode, and use a formula to set the value of the barcode field equal to the Device Number field. You can then use a label maker to print the barcodes and stick them on the corresponding assets.

This way, when you need to count or identify computer equipment, all you have to do is connect a scanner to the computer, open Ragic in your browser, move the cursor to the full-text search box, scan the barcode, and voila! You are shown the detailed equipment information. You can also use the iOS app to do a barcode search. (See this page for details)

The "Status" section records information such as to whom the device is assigned and its current location. The user e-mail is linked and loaded from the e-mail field of the IT User Management sheet. If the device had been assigned to different people at different points in time, you can record this information in the Asset Transfer Information section. The greyed-out Maintenance Record section does not need to be filled out as it is automatically filled by the IT Request sheet.

3. Software Management: Software License

For software management, since you may buy several licenses of the same product (e.g. Microsoft Office or Ragic) to assign to different users, we have separated ”buying licenses" and "assigning them" to users into two different sheets. The two sheets are linked to each other hierarchically; the Software License Allocationis a new sheet generated from the subtable inside the Software License Management sheet.

Every time you purchase software, you can add a new entry inside Software License Management. In that sheet, each entry represents one software purchase. A sample entry is shown below:

Once you've added a new entry in Software License Management, the Software License Allocation sheet will generate data corresponding to the newly added data in the License Allocation subtable. For example, if an entry in Software License Management has three new rows of data in the License Allocation subtable, then the Software Assignment List sheet will also have three new assignment entries. If the Software License Management sheet has three entries, each with 3 software assignments, then the Software License Allocationsheet will have 9 entries.

A sample Software License Allocation entry is shown below.

As you can see, aside from the Installation Date and Note fields, every other field is a greyed-out, read-only field. These read-only fields contain linked information from the License Allocationsubtable in the parent sheet. To avoid altering the data in the subtable, it has been set to read-only, you need to go to the parent sheet to add or edit the content.

The two writeable fields in the Software License Allocationallow you to fill in more details.

4. IT Request

If a company employee needs to set up a computer, install software, purchase software, or call an IT staff to look over a computer problem, communicating by phone or e-mail is often less efficient than filling out a form. You can ask employees to fill out an IT Request form to expedite the process and allow tracking:

When you add a new entry (fill out a form), the system automatically generates an entry number and the current date. All you have to do is select the requester e-mail, and the rest will be automatically filled in. If you are filling out the form for someone else, you can note this as well.

In the Description section, the default request types are IT Installations and Report IT Incidents. If you select IT Installations, the system automatically hides the fields for Related Device, Related Software, and their respective numbers (conditional formatting).

All you have to do is fill out the problem description. If you select Report IT Incidents, you need to select the correct options from the list of related devices or software to give the IT staff more clues to work with. The Tracking Record section does not need to be filled out by the user. This is where you can check on the latest updated information from the IT staff without spending the time to e-mail or call them.

5. IT Assignment

The IT Assignment sheet is a multiple version of the IT Request sheet. The two share their data but with different access rights set up. Only users who are in the system default IT user group have Admin rights. Other users cannot see nor modify the data in this sheet as it is meant for the IT or other relevant staff to assign tasks internally. You can go to the Tracking Record section to assign the task to someone and fill out the progress. The Priority field allows the assigned staff to rank their tasks by importance and is not visible to the requester.

Advanced Settings

You can customize these sheets to fit your needs. However, if you want to modify the design of more than 3 sheets in the free templates, you need to upgrade to the paid Professional Plan at USD $19 per user per month. (See here for the plans and their pricing)

Here are some advanced settings and ways to modify the design:

Customized Numbering for Assets

To simply adjust the sequence status, please refer to this page. If you want to use your own numbering system, you can change the field type to free text or numeric and manually input the value or use a string formula if needed.

Still have questions? Shoot us an email at support@ragic.com!

Category: Applications, Templates

Powered by Ragic! : Data Management That Actually Works
Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
Create your first database now!
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com