SQL Query for Dell Client Manager
networkchic
November 24th, 2008
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. |
Missing table
SQL query is missing a table.
"rd.login_name as 'User'
rd.Equip_status"
There's nothing in FROM named as "rd"
Getting Primary User on the machine
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
Would you like to reply?
Login or Register to post your comment.