/build/static/layout/Breadcrumb_cap_w.png

Inventory report that lists all models currently in the K1000/SMA and the count of each model

This report will list each model of computer currently in your K1000/SMA and give a count of all the computers of each model type as well.

SELECT DISTINCT CS_MODEL,COUNT(*) FROM ORG1.MACHINE GROUP BY CS_MODEL;
Posted 6 years ago 3705 views

Comments

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ