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.





        • 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