Chicago Endpoint Management User Group

 View Only

SQL Query for Dell Client Manager 

Nov 24, 2008 02:07 PM

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.

License:AJSL
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
Support:User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.

Statistics
0 Favorited
0 Views
2 Files
0 Shares
0 Downloads
Attachment(s)
jpg file
6363.jpg   5 KB   1 version
Uploaded - Feb 25, 2020
txt file
Dell_Client_Manager_HardwareReports.txt   479 B   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Nov 26, 2008 03:46 AM

You can actually JOIN [inv_aex_ac_primary_user] table inorder to get the PRIMARY USER of the machine.
Following is the modified query:
SELECT d.Manufacturer, d.Model, vc.Name as 'Workstation', PU.[User], b.BuildNumber as 'Bios Version', hd.DeviceID, hd.Model as 'Hard Drive Model', hd.Partitions, hd.MediaType, hd.totalPhysicalSize
FROM Inv_OMCA_Discovery d
JOIN Inv_OMCA_BIOS_Element b ON b._ResourceGuid = d._ResourceGuid
JOIN Inv_OMCA_Disk_Drive hd ON hd._ResourceGuid = d._ResourceGuid
JOIN vcomputer vc ON vc.Guid = d._ResourceGuid
JOIN [inv_aex_ac_primary_user] PU ON PU.[_ResourceGuid] = vc.Guid
WHERE PU.[Month] = datename(month, getdate())
ORDER BY d.Model, vc.Name

Nov 25, 2008 09:52 AM

SQL query is missing a table.
"rd.login_name as 'User'
rd.Equip_status"
There's nothing in FROM named as "rd"

Related Entries and Links

No Related Resource entered.