/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;

Comments

This post is locked

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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