Keyboard Data aka SMS asset management

SMS is a great tool for asset information, the key to SMS is under standing what information is available.

 

Some people might ask why I should care about keyboard information!

The answer is that at some time management will ask a question like:

How may “TBITS-5 Bilingual Keyboard” do we have?

 

It is always good to understand what data is within SMS, so that you can answer questions like this by saying “Give me a few minutes to write this query for you, would you like it as a web report or as a one off Excel spreadsheet?”

 

SELECT DISTINCT

v_GS_KEYBOARD_DEVICE.Description0 AS ‘KB’, Count(v_GS_KEYBOARD_DEVICE.Description0) AS ‘Count’

FROM

.v_GS_KEYBOARD_DEVICE v_GS_KEYBOARD_DEVICE

GROUP BY

v_GS_KEYBOARD_DEVICE.Description0

ORDER BY

v_GS_KEYBOARD_DEVICE.Description0

Leave a Reply

Your email address will not be published. Required fields are marked *