Here we will show you how to use the mapping tables in WipeQ
Start off by going to the settings tab on the left-hand panel of your dashboard.
Click mapping table. The mapping tables is an interface that will allow you to normalize the data and clean it up according to your company’s standards.
Many times, when you are using auditing tools, the data coming out of the BIOs may not match your exact formatting or specifications.
An example would be Wi-Fi. Under Wi-Fi, you will see all the various values coming in. The left column will indicate what values are being collected in WipeQ.
Let’s say you’re not interested in seeing this full document or title of this item and want to convert it to something more meaningful and easier to understand.
We can say anytime this comes in, convert it to wireless included. Now anytime that value comes in, it will automatically be converted to wireless included.
From all this wireless included, we can select all and copy/paste. Wireless included will now be the converted value when a laptop is audited and sees this in the reporting and APIs.
This is important to do.
Another example is Optical drives.
For example, let’s say everything that comes in that’s CD/DVD-W. You can see there are a bunch of options below. These are all models TS-U633J and maybe you are not interested, or your customers don’t care other than that is a CD/DVD-W.
You will convert these, place your cursor in the converted values and begin typing in what you want to see. Add a CD-DVD-W and hit enter.
Now since all of these are identical, you will copy/paste it across the board and now you will have an exceptionally cleaned up value of what the data will output to.
You can continue through the various items, go to optical drives, and see we have DVD-RAM. We can start off with a search for DVD-RAM and typically these are all identical. There are mixed variations and with the integration, you will go in and type in DVDRAM, copy and hold down ctrl shift and paste that in.
This is a fast way to normalizing your data. So, you can go through all the different tables and see what is being collected in WipeQ. And clean up how you want to be converted.
So, this how you would clean up the data and normalize values and can normalize all the tables included in WipeQ.
Chassis information is a good example that a lot of companies would like to clean up. If we look at low profile desktop you can convert to what you like, Lunch Box you can convert to a small form factor.
The main Server chassis can be converted to Rack Mount Chassis so if you wanted to keep the data clean, make these adjustments. So, you have a notebook and you also have a Laptop so you might want to keep them all identical. Maybe you want to call it a laptop.