ITMS Administrator Group

Expand all | Collapse all

Installation by Admin History

Jump to Best Answer
  • 1.  Installation by Admin History

    Posted 12-14-2018 09:40 AM

    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.



  • 2.  RE: Installation by Admin History
    Best Answer

    Trusted Advisor
    Posted 12-18-2018 04:33 AM

    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.



  • 3.  RE: Installation by Admin History

    Trusted Advisor
    Posted 12-14-2018 11:44 AM

    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


  • 4.  RE: Installation by Admin History

    Posted 12-17-2018 12:56 PM

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



  • 5.  RE: Installation by Admin History

    Posted 12-18-2018 07:42 AM

    Thanks Alex!  Somehow I overlooked that table.