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
Recent Comments