Client Management Suite

Hi All,

Is there a way to run a sql report on every computer managed by Altiris with the primary account attached to that computer?

 

I need a list of all computers with the primary accounts user name.

 

What would be the easiest way to get that information?

Create a new SQL report with this and see if it gets what you need. It is a big report with good info. It will return: Computer, OS, Type, Last User, MAC, IP, Make, Model, Serial Number.

SELECT *
FROM vComputer vc
INNER JOIN vHWComputerSystem hw
ON vc.Guid = hw._ResourceGuid
WHERE hw.Model LIKE '%'
AND vc.[OS Name] LIKE '%'
AND vc.[System Type] LIKE '%'

 

Use the [Reports > Discovery and Inventory > Inventory > Windows > User > Primary User >] "Primary User by Computer" report. Right-click and "View as XML" to see the underlying SQL used.

Great thank you all for your help.