1 Reply Latest reply on Sep 10, 2015 12:00 PM by jpozucek

    Reports on Provisioning History

    jpozucek Apprentice

      I would like to report on the Provisioning History data on a device but it's not an option in the Query Editor.  Is there a way to extract this data?  I would like to pull up reports on devices that have old images so I can start a refresh process.

       

      I have access to the SQL Database but I am not familiar with the schema and haven't been able to find the appropriate tables.

       

      Any help would be appreciated.

       

      Thanks,

       

      Jim

        • 1. Re: Reports on Provisioning History
          jpozucek Apprentice

          I actually figured out the SQL for it:

           

          SELECT        Computer.Computer_Idn, Computer.DeviceName, MAX(PROV_HISTORY_TASK.LAST_ACTION_STATUS_DATE) AS MaxDate, PROV_HISTORY_TASK.TASK_NAME

          FROM            Computer INNER JOIN

                                   PROV_HISTORY_TASK ON Computer.Computer_Idn = PROV_HISTORY_TASK.COMPUTER_IDN

          WHERE        (cOMPUTER.DeviceName=COMPUTER.LoginName) AND  (PROV_HISTORY_TASK.LAST_ACTION_STATUS_DATE <= CONVERT(DATETIME, '2014-09-01 00:00:00', 102))

          GROUP BY Computer.DeviceName, Computer.Computer_Idn,PROV_HISTORY_TASK.TASK_NAME

          order by Computer.DeviceName

           

          Just need to stream line it and make it available publicly.

           

          1 of 1 people found this helpful