Installation by Admin History

[Jeff Stanton]

I am looking for a report or SQL query that can provide me with the installations performed within the Altiris console (using quick run) by a specific user over a period of time within a specific timeframe (such as a month/year, etc.).

Thanks for the help.

[Alex Hedley]

Report informing who installed an Update if it was the user or if it was the Altiris
https://www.symantec.com/connect/forums/report-informing-who-installed-update-if-it-was-user-or-if-it-was-altiris

 

You could check the "Source" column of "Inv_InstalledSoftware"

SELECT * FROM Inv_InstalledSoftware

[Jeff Stanton]

How do I correspond the "Source" to a username?

[Alex Hedley]

Apologies, misunderstood what you needed.

You can check "[ExecutedBy]" in "[Inv_Task_Summary_By_Task]"

Filter by "[TaskItemGuid]" for ones you know.

You might be able to join on [vItem] and get the [Class] to get particular types of Tasks.

[Jeff Stanton]

Thanks Alex!  Somehow I overlooked that table.