I've created a SQL query that joins all the important info one might need from the Dell Client Manager Solution. It's much easier than using the NS reports. FYI the rd table refence is a join to an outside database so you can take it out and the query will still work.
This is a general query which should run on any database.